Page 672 - Excel 2013 All-in-One For Dummies

654 Exploring Different Scenarios
Figure 1-6:
Specifying the changing values in the Scenario Values dialog box.
7. Check the values in each changing cell’s text box and modify the values as needed.
Now you’re ready to close the Scenario Values dialog box, which com- pletes the definition of the new scenario.
8. Click the Add button in the Scenario Values dialog box.
This action closes the Scenario Values dialog box and returns you to the Add Scenario dialog box, where you can define a new scenario name for the changing cells.
9. Repeat Steps 4 to 7 to add all the other scenarios that you want to create.
After you finish defining all the different scenarios you want to apply to the changing values in the spreadsheet, you can close the Scenario Values dialog box and then return to the Scenario Manager dialog box, where you can use the Show button to see how using different sets of changing values affects your spreadsheet.
10. Click OK in the Add Values dialog box and then click the Close button in the Scenario Manager dialog box.
When you return to the Scenario Manager dialog box, the names of all the scenarios that you added appear in the Scenarios list box. For example, in Figure 1-7, you see that three scenarios — Most Likely, Best Case, and Worst Case — are now listed in the Scenarios list box.
To show a particular scenario in the worksheet that uses the values you entered for the changing cells, you simply double-click the scenario name in this list box or click the name and then click the Show command button. Figure 1-7 shows the results in the sample forecast worksheet after showing the Worst Case scenario.