Page 218 - TP_IT_V1.0_C10_flipbpookl
P. 218
The Create Scenario dialog box will open.
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.
• 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:
w Display border: It has a colour palette which gives you options to give different colours to different scenarios.
w Copy back: The changes if you make in a scenario are copied back into the active scenario.
w Copy entire sheet: The copy of the active scenario is displayed in a newly created permanent sheet.
w Prevent changes: If the sheet is protected then it prevents the changes with the enabled Copy back option.
Step 4: Specify the scenario name and settings for the scenario.
216 Trackpad Information Technology (Ver. 1.0)-X

