Page 151 - IT_V1.0_Class10
P. 151

21 st
                                                    Lab Assignment ‘n Activity                   Century   #Technology Literacy
                                                                                                   Skills


                      Complete the following activity and tick the circle.

                      Use the Subtotal command to display the total number of students in each grade
                      level. Also, display the grand total number of students in the entire school.
















                   WHAT-IF SCENARIOS

                 Scenario is a set of cell values that can be used within your calculations in a spreadsheet. Each Scenario is
                 named, can be edited and formatted separately, and can be chosen from a drop-down list in the Navigator
                 and the title bar of the Scenario. When the spreadsheet is printed, only the contents of the currently active
                 Scenario are printed. By adding a Scenario, you can easily view new results for the arguments of a formula.
                 You can create several scenarios for any given range of cells. It is used to explore and compare various
                 alternatives under changing conditions. At the start of any project, this tool helps optimise the output by
                 predicting results based on varying inputs. This allows for selecting the best course of action. For example,
                 Radha is a saleswoman in a car showroom. She is asked to plan for sales for the next quarter by building
                 multiple scenarios under different situations.
                 Create a table in Calc as below and add multiple scenarios based on number of cars that she will be able to
                 sell for each of the car models. To create a Scenario:

                 Step 1:  Select  the  cells  that  contain                                     2
                         the values which will change
                         between scenarios. To select
                         multiple cells, hold  the Ctrl key
                         and then click on each cell.

                 Step 2:  Click on Tools menu.
                                                             1
                 Step 3:  Select Scenarios option. Create
                         Scenario dialog box appears on
                         the screen.
                 Step 4:  Type a name for the new scenario.
                         This name will  be displayed on                                                               3
                         the title bar  of the scenario on
                         the sheet itself. By default the name of the scenario is SheetName_Scenario_1.

                 Step 5: In the Comment section, you may write any comment to explain the given scenario. Here for Sales 1
                         we have given a comment as “Expected minimum sales with no festivities”.


                                                                        Analyse Data using Scenarios and Goal Seek   149
   146   147   148   149   150   151   152   153   154   155   156