Microsoft Office Tutorials and References
In Depth Information
Analyze Data with Scenarios
11
chapter
Analyzing Data
Display Scenarios
1 Click the Data tab.
2 Click What-If Analysis (
).
3 Click Scenario Manager .
The Scenario Manager dialog box
appears.
4 Click the scenario you want to
display.
5 Click Show .
B Excel enters the scenario values
into the changing cells and
displays the formula result.
6 Repeat Steps and to display 5
other scenarios.
7 Click Close .
How do I edit a scenario?
If you need to make changes to a scenario,
you can edit the name, the changing cells, the
description, and the scenario’s input values.
Click the Data tab, click , and then click
Scenario Manager . In the Scenario Manager
dialog box, click the scenario you want to
modify, and then click Edit .
How do I remove a scenario?
Click the Data tab, click , and then click
Scenario Manager . Click the scenario you
want to delete. Note that Excel does not ask
you to confirm the deletion, so double-check
that you have selected the correct scenario.
Click Delete and then click Close .
Search JabSto ::




Custom Search