Microsoft Office Tutorials and References
In Depth Information
Creating Multiple Scenarios
Figure 9-18:
Type in
new values
for your
selected
cells.
Figure 9-19:
The
Scenario
Manager
dialog box
lets you
view, edit, or
delete your
different
scenarios.
12. Click Show.
Excel replaces any existing data with the data you typed in Step 10.
13. Click Close.
The data from your scenario remains in the spreadsheet.
Viewing a scenario
After you create one or more scenarios, you can view them and see how they
affect your data. To view a scenario, follow these steps:
1. Click the Data tab.
2. Click the What-If Analysis icon in the Data Tools group.
A pull-down menu appears.
3. Choose Scenario Manager.
The Scenario Manager dialog box appears (refer to Figure 9-19).
 
Search JabSto ::




Custom Search