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

