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
sets”).
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.
1
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.
2
Click Add to open the Add Scenario dialog box.
3
In the Scenario name field, enter 2DayIncrease .
4
At the right edge of the Changing cells field, click the Collapse Dialog button so the
worksheet contents are visible.
5
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 .
8
 
Search JabSto ::




Custom Search