Page 160 - IT_V1.0_Class10
P. 160
iii. A is true but R is false.
iv. A is false but R is true.
Assertion (A): Goal Seek can only work with one input variable at a time.
Reason (R): Goal Seek uses an iterative process to adjust the input value to reach the desired output.
21 st
E. Statement-based question. Century #Critical Thinking
Skills
In the following question, two statements are given. Statement 1 and Statement 2. Examine the statements
and mark the correct option:
i. Statement 1 is true , Statement 2 is true
ii. Statement 1 is false , Statement 2 is false
iii. Statement 1 is true , Statement 2 is false
iv. Statement 1 is false , Statement 2 is true
Statement 1: Scenarios in LibreOffice Calc allow users to test multiple hypothetical cases.
Statement 2: Scenarios are permanent and cannot be edited after creation.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. Explain the options available under What-If Scenarios dialog box.
2. Which setting options do you need to specify while creating multiple scenario? Explain each of them in short.
3. Write steps to provide results using multiple operations.
4. Write the procedure to perform Goal Seek.
5. Write the steps to use Solver.
21 st
Century #Critical Thinking
B. Application-based question. Skills
Neha has a sales report with sales amounts listed for various representatives under different regions. She wants to calculate
the total for each region. Which feature in LibreOffice Calc can she use to automatically insert totals by region?
158 Information Technology Play (Ver 1.0)-X

