Page 159 - IT_V1.0_Class10
P. 159
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. Which of the following are the different tools of What-if Analysis?
i. Scenario ii. Goal Seek iii. Solver iv. All of these
2. The ............................. tool creates a formula array which is a separate set of cells that give all the alternative results
for the formulas used.
i. Auto ii. Goal Seek iii. What-if iv. Multiple Operations
3. ............................. is specifically designed to minimise or maximise the result according to a set of rules that you
define in a spreadsheet.
i. Data Analysis tool ii. Scenario iii. Solver iv. Subtotal
4. Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve
85 percent in aggregate. Suggest him the suitable option out of the following to do so. [CBSE Sample Paper 2021]
i. Macro ii. Data Analysis tool iii. Goal Seek iv. Sub Total
5. Scenarios in spreadsheets are primarily used for performing ............................. analysis.
i. Financial ii. What-if iii. Statistical iv. Logical
B. Fill in the blanks.
1. The data consolidation function takes data from a series of sheets or spreadsheets and summarises it into a
..............................
2. ............................. is a powerful feature in spreadsheets that helps run reverse calculations.
3. ............................. is a more descriptive form of Goal Seek.
4. When you use the ............................. tool, Calc inserts an outline to the left of the row number column.
5. The ............................. option allows you to organise selected data by creating an outline, enabling you to group
rows or columns together.
C. State whether the following statements are true or false:
1. The Group and Outline feature helps in organising and hiding groups of rows or columns for
better data management. ............................
2. Subtotals cannot be automatically added to a dataset to calculate totals based on grouping criteria. ............................
3. What-If Analysis allows you to explore different outcomes based on varying input values in
your data. ............................
4. Subtotal outline is used to display or hide subtotal rows in a dataset for better readability. ............................
5. Consolidating data does not allow you to combine data from multiple sheets into one using
a specified function. ............................
21 st
D. Assertion and reasoning question. Century #Critical Thinking
Skills
The following question consists of two statements – Assertion (A) and Reason (R). Answer the question by
selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
Analyse Data using Scenarios and Goal Seek 157

