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

