Page 197 - Trackpad 402_Class-X_Final
P. 197

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   Click on Tools menu and select Scenarios option. The Create Scenario dialog box will open. Do the changes in
                    this dialog box as per the details shown below:


























                    The options available in the window are:
                    •  Name of scenario: Has the default name as Sheet1_Scenario_1. Change it to a relevant name that clearly
                      identifies a scenario in the drop-down list and in the Navigator window. In the above example, the scenario
                      name is Friend - Amita.
                    •  Comment: It is optional and is the extra information required. When you select the scenarios then this
                      information is displayed in the Navigator.
                    •  Settings: It has several options where the settings can be changed as per the situations:
                         Display border: It has a color palette which gives you options  to give different colours to different
                        scenarios. In the above example we are keeping pink border for Friend - Amita.
                         Copy back: The changes if you make in a scenario are copied back into the active scenario.
                         Copy entire sheet: The copy of the active scenario is displayed in a newly created permanent sheet.
                         Prevent changes: If the sheet is protected then it prevents the changes with the enabled Copy back option.
































                                                                                 Electronic Spreadsheet (Advanced)  197
   192   193   194   195   196   197   198   199   200   201   202