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