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

Textbook	Kips Information Technology Class 10
Subject Code	402
Part	B
Unit	Unit-2 Electronic Spreadsheet (Advanced)
Chapter	6 Analysing Data in a Spreadsheet
Other Chapters Solutions	Kips IT Class 10 Solutions

Contents

A. Select the correct option.
B. Fill in the Blanks.
C. Answer the following questions.
What is Data Consolidation?
Explain the use of Scenarios.
What is Goal Seek.
What is the basic difference between ‘Scenarios’ and ‘Multiple Operations’ tools?
How do you name a range of cells?

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.