Page 217 - TP_IT_V1.0_C10_flipbpookl
P. 217

Now, the data is grouped based on the Class and subtotal based on the section and Strength, as shown in below figure.






































                 When you use the subtotal tool, the outline is positioned to the left of the row numbers. This outline visually represents
                 the hierarchical arrangement of data.  You can expand or collapse different levels by clicking on the group indicators:
                 the plus sign to expand and the minus sign to collapse. You can remove the outline from the sheet by selected the
                 Data   Group and Outline   Remove Outline option from the Menu bar.


                         USING WHAT IF SCENARIOS

                 A What-if scenario is a collection of values applicable for calculations in a spreadsheet. In LibreOffice Calc, multiple
                 scenarios can create on a single sheet. Each scenario is assigned a name and a formatting style.

                 By defining different sets of values for variables within a model, users can explore how changes in these variables
                 affect the outcomes or results of their calculations. What-if scenario is a powerful tool for decision-making, allowing
                 users to compare various alternatives and optimise their plans based on different scenarios. It enable users to predict
                 outcomes and make informed decisions.

                 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 take an example to create a scenario. We will create scenarios of students getting marks in different exams and
                 calculate their total 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 student named Amita.

                 Step 2:   Select cells C4, C7, C8, C9 to use in creating Scenarios. To select multiple cells, hold down the Ctrl key with
                         each mouse click.
                 Step 3:  Select the Tools   Scenarios option from the Menu bar.


                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  215
   212   213   214   215   216   217   218   219   220   221   222