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

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. Here are the steps to follow:

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

2 Select the scenario you want to modify.

3 Click Edit.The Edit Scenario dialog box appears.

4 Modify the scenario name, changing cells, and comment, as needed.

5 Click OK.The Scenario Values dialog box appears.

6 Modify the scenario values, as needed.

7 Click OK.Excel returns you to the Scenario Manager dialog box.

8 Click Close.