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
   214   215   216   217   218   219   220   221   222   223   224