Microsoft Office Tutorials and References
In Depth Information
Scenario Manager appears (see Figure C-21), but no scenarios are defined. Use the dialog box to add,
delete, or edit scenarios.
Initial Scenario Manager dialog box
When working with the Scenario Manager dialog box and any following dialog boxes, do not use the Enter key to navigate. Use
mouse clicks to move from one step to the next.
To define a scenario, click the Add button. The Edit Scenario dialog box appears. Type Recession-High
Inflation in the field under Scenario name. Then type the input cells in the Changing cells field (in this case,
C8:C9). Better yet, you can use the button next to the field to select the cells in your spreadsheet. If you do,
Scenario Manager changes the cell references to absolute cell references, which is acceptable (see Figure C-22).
Defining a scenario name and input cells