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
   155   156   157   158   159   160   161   162   163   164   165