en uk

Viewing a scenario Microsoft Excel 2007

    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 8-11).

    4. Click the name of the scenario you want to view.

    5. Click Show.

    Excel shows the values in the cells defined by your chosen scenario.

    6. Click Close.




BACK NEXT TOP

Site is a private collection of materials and is an amateur informational and educational resource. All information is obtained from public sources. The administration does not apply for authorship of the materials used. All rights belong to their owners.