Microsoft Office Tutorials and References
In Depth Information
Defining multiple alternative data sets
From within the dialog box, you can choose the type of summary worksheet you want to
create and the cells you want to display in the summary worksheet. To choose the cells to
display in the summary, click the Collapse Dialog button at the right of the Result Cells field,
select the cells you want to display, and then expand the dialog box. After you verify that
the range in the box represents the cells you want to have included on the summary sheet,
click OK to create the new worksheet.
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 new
SET UP You need the MultipleScenarios 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 3DayIncrease .
At the right edge of the Changing cells field, click the Collapse Dialog button to
collapse the Add Scenario dialog box.
In the worksheet, click cell C4 and then, in the dialog box, click the Expand Dialog
button. $C$4 appears in the Changing Cells field, and the dialog box title changes to
Edit Scenario .