CREATE SCENARIOS

Prev Show Me Step-By-Step Next
Get Ready
Locate the cells Scenario Manager can change.
Example: E7:E15 (Current Interest Rates)
Identify appropriate values for the changing cells.

Begin
Display the Tools menu and then click the word Scenarios.
To add a scenario:
Click the Add button.
To edit an existing scenario:
Click the name of your scenario.
Click the Edit button.
If necessary, enter a name for your scenario.
Select the cells to be changed.
Click the OK button. The Scenario Values dialog box will display.
As necessary, enter a value for each of the changing cells.
Click the OK button. The Scenario Manager dialog box will display again. If you want, create or edit another scenario.
To show your scenario in the worksheet:
Select the name of your scenario.
Click the Show button.