Kips IT Class 10 Chapter 6 Solutions Analysing Data in a Spreadsheet Part-B

TextbookKips Information Technology Class 10
Subject Code402
UnitUnit-2 Electronic Spreadsheet (Advanced)
Chapter6 Analysing Data in a Spreadsheet
Other Chapters SolutionsKips IT Class 10 Solutions

A. Select the correct option.

1. This is a command of Calc that collates the data from different ranges and places it in a worksheet.

  • Consolidate
  • Combining
  • Subtotals

2. It generates a subtotals to summarise the data.

  • Define range
  • Total
  • Subtotals

3. Which menu holds the ‘Multiple Operations’ tool?

  • Tools
  • Data
  • Sheet

4. It is the elaborate form of Goal Seek.

  • Detective
  • Solver
  • Scenario

5. It is used to set a goal to find the optimum value for one or more target variables.

  • Scenario
  • Goal Seek
  • Detective

B. Fill in the Blanks.

1. A Scenario is a Set of values that you enter in a worksheet to perform calculations.

2. It is good in practice to use the Sorted data while applying the Subtotals command to it.

3. The Multiple Operations tool displays the result of applying formula to a list of alternative values for variables in a separate range of cells.

4. Goal Seek can process only one input values at a time.

5. Solver deals with equations with multiple unknown variables.

C. Answer the following questions.

What is Data Consolidation?

Consoling Data means combining data from different sources into one place. For example, you have sales data from four different zonal heads in four different worksheets. In such a case to analyse data, you need to collate everything into one worksheet.

Explain the use of Scenarios.

The Scenarios is an important feature of Calc that you use to test the ‘What-if’ questions. It enables you to analyse the data by putting different input values.

What is Goal Seek.

Goal Seek is a useful tool of Calc. It is used to set a goal to find the optimum value for one or more target variables, given with the certain conditions.

What is the basic difference between ‘Scenarios’ and ‘Multiple Operations’ tools?

Multiple Operations tools create a formula array Where Scenarios enable you to analyse the data by putting different input values.

How do you name a range of cells?

To assign a name to a range, click on Data > Define Range, a dialog box opens, enter name in the Name field and click on OK.

Comments are closed.