Page 219 - TP_IT_V1.0_C10_flipbpookl
P. 219
Step 5: Click on the OK button to create a scenario.
Step 6: Modify the spreadsheet with the new values for Student – Rohan.
Step 7: Select the Tools Scenarios option from the Menu bar. The Create Scenario dialog box will open.
Step 8: Do the given changes in this Create Scenario dialog box and click on the OK button:
Step 9: Repeat the above steps to create two more scenarios. The spreadsheet will appear with the list of scenarios
created if you click on the drop-down list of cell B4.
In the given example, we have created 4 scenarios of four students’ marks. You can easily switch between these sets
using a drop-down list which can be shown beside the changing cells or the selecting the Scenarios option in the
Navigator pane, which is open by clicking the Navigator button in the Sidebar or by selecting the View Navigator
option in the Menu bar.
Electronic Spreadsheet (Advanced) using LibreOffice Calc 217

