Page 196 - Trackpad 402_Class-X_Final
P. 196

You will see the subtotal of strength class wise will be done and displayed in the sheet as shown below:






























        Up to 3 levels of grouping is allowed in OpenOffice Calc. If you wish to use more than one group, then the data need
        to be arranged either in the ascending or descending order.



                USING WHAT-IF SCENARIOS

        Scenarios are what-if analysis tools of OpenOffice Calc. It helps you set multiple values for the same cell that can be
        used for calculations or data analysis. After the scenarios are created, they can be edited and formatted independent
        of each other. You can easily switch between the scenarios using the drop-down list or Navigator and can create several
        scenarios for any given range of cells.

        Let us first learn how to create a scenario. We will create scenarios of friends getting marks in different exams and
        calculate their total and percentage based on the set of cells created using different scenarios.
        To do this, follow the given steps:
        Step 1:  Create a spreadsheet with marks of a friend named Amita as shown below:
































          196   Trackpad Information Technology-X
   191   192   193   194   195   196   197   198   199   200   201