Microsoft Office Tutorials and References
In Depth Information
Defining an alternative data set
IMPORTANT If you save and close a workbook while a scenario is in effect, those values
become the default values for the cells changed by the scenario! You should seriously consider
creating a scenario that contains the original values of the cells you change or creating a
scenario summary worksheet (described in the next section, “Defining multiple alternative data
In this exercise, you’ll create a scenario to measure the projected impact on total revenue of
a rate increase on two-day shipping.
SET UP You need the 2DayScenario workbook located in the Chapter08 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
On the Data tab, in the Data Tools group, click What-If Analysis and then, in the list,
click Scenario Manager to open the Scenario Manager dialog box.
Click Add to open the Add Scenario dialog box.
In the Scenario name field, enter 2DayIncrease .
At the right edge of the Changing cells field, click the Collapse Dialog button so the
worksheet contents are visible.
In the worksheet, click cell C5 and then, in the Add Scenario dialog box, click the
Expand Dialog button. $C$5 appears in the Changing Cells field, and the dialog box
title changes to Edit Scenario .