Microsoft Office Tutorials and References
In Depth Information
It’s a good idea to create an “undo” scenario named Normal that holds the original values
of the cells you’re going to change before they’re changed in other scenarios. For example,
if you create a scenario named High Fuel Costs that changes the sales figures in three cells,
your Normal scenario restores those cells to their original values. That way, even if you
accidentally modify your worksheet, you can apply the Normal scenario and not have to
reconstruct the worksheet from scratch.
Tip Each scenario can change a maximum of 32 cells, so you might need to create more than
one scenario to ensure that you can restore a worksheet.
In this exercise, you’ll create scenarios to represent projected revenue increases from
two rate changes, view the scenarios, and then summarize the scenario results in a
SET UP You need the MultipleScenarios_start workbook located in your Chapter08
practice file folder to complete this exercise. Open the MultipleScenarios_start
workbook, and save it as MultipleScenarios . Then follow the steps.
1. On the Data tab, in the Data Tools group, click What-If Analysis and then, in the
list, click Scenario Manager .
The Scenario Manager dialog box opens.
2. Click Add .
The Add Scenario dialog box opens.
3. In the Scenario name field, type 3DayIncrease .
4. At the right edge of the Changing cells field, click the Collapse Dialog button.
The Add Scenario dialog box collapses.
5. In the worksheet, click cell C4 and then, in the dialog box, click the Expand Dialog
$C$4 appears in the Changing Cells field, and the dialog box title changes to Edit
6. Click OK .
The Scenario Values dialog box opens.
7. In the value field, type 11.50 .