Читать книгу Excel Data Analysis For Dummies - Paul McFedries - Страница 42

The real value of a scenario is that no matter how many changing cells you’ve defined or how complicated the formula is, you can apply any scenario with just a few straightforward steps. Don’t believe me? Here, I’ll prove it:

1 Choose Data ⇒ What-If Analysis ⇒ Scenario Manager.The Scenario Manager dialog box appears.

2 Select the scenario you want to display.

3 Click Show.Without even a moment’s hesitation, Excel enters the scenario values into the changing cells and displays the formula result.

4 Feel free to repeat Steps 2 and 3 to display other scenarios. When it’s this easy, why not?

5 When you’ve completed your analysis, click Close.