Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek questions answers

Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek questions answers

Dear students here you will get exercise as well as additional questions answers of Class 10 IT Chapter 4 Analyse Data using Scenarios and Goal Seek

D. Answer the following questions

1. Define the terms

(a) Consolidate function

Ans: What -if analysis is a planning tool for what – if questions. In this, the output is not shown in the same cells, whereas it uses a drop-down list to display the output depending upon the input. It is useful to check in the beginning to understand from the output for the efficiency. This tool uses two arrays of cells, one array contains the input values and the second array uses the formula and display the result.

(b) What – if analysis

Ans: What -if analysis is a planning tool for what – if questions. In this, the output is not shown in the same cells, whereas it uses a drop-down list to display the output depending upon the input. It is useful to check in the beginning to understand from the output for the efficiency. This tool uses two arrays of cells, one array contains the input values and the second array uses the formula and display the result.

(c) Goal seek

Ans: Goal seek is an useful tool in spreadsheets that helps in finding out the input value needed to achieve a desired output. It allows the user to determine the desired input value for a formula when the output value is already known. It is very helpful in various types of financial analysis.

2. Give one point of difference between

(a) Subtotal and What-if

Ans: Subtotal tool in spreadsheets creates the group automatically and applies common functions like sum, average on the grouped data.

Whereas What – if is a planning tool for what – if questions. In this the output is not shown in the same cells, whereas it uses a drop – down list to display the output depending upon the input.

(b) What – if scenario and What – if tool

Ans: What – if Scenario is a set of values that can be used within the calculations in the spreadsheet . A name is given to the scenario and several scenarios can be created on the same sheet.

Whereas What – if is a planning tools for what – if questions. In this, the output is not shown in the same cells, whereas it uses a drop-down list to display the output depending upon the input.

3. Give any two advantages of data analysis tools.

Ans: i. Data analysis can help businesses identify potential problems before they occur, minimizing risks. 

ii. Data analysis can help companies gain a deeper understanding of the market and adapt their strategies accordingly. 

4. Name any two tools for data analysis .

Ans : Microsoft Excel and Libre Office Calc.

5. What are the criteria for consolidating sheets ?

Ans: The criteria for consolidating sheets are-

i. The data types of all the sheets to be consolidated must match.

ii. The labels of all the sheets to be consolidated must match .

iii. The first column should be entered as the primary column on the basis of which the data is to be consolidated.

6. Which tool is used to create an outline for the selected data ?

Ans: Group and Outline tool in Calc is used to create an outline for the selected data.