Microsoft Office Tutorials and References
In Depth Information
Analyze Data with Scenarios
11
chapter
Analyzing Data
The Scenario Manager dialog box
appears.
5 Click Add .
The Add Scenario dialog box
appears.
6 Type a name for the scenario.
7 Click inside the Changing cells
box.
8 Select the cells you want to
change in the scenario.
9 Type a description for the
scenario.
0 Click OK.
Are there any restrictions on the changing
cells?
When you are building a worksheet model
for use with scenarios, make sure that each
changing cell is a constant value. If you
use a formula for a changing cell, Excel
replaces that formula with a constant value
defined in the scenario, so you lose your
formula.
Do I need to add a description to each scenario?
Yes. Your scenarios appear in the Scenario
Manager and for each scenario you see its
changing cells and its description. The
description is often very useful, particularly if
you have several scenarios defined, so be sure to
write a detailed description in Step to help 9
you differentiate your scenarios later on.
continued
Search JabSto ::




Custom Search