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

