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

Figure 1-5:
Adding a new Most Likely scenario for the sales forecast.
Exploring Different Scenarios 653
4. Type a descriptive name for the new scenario in the Scenario Name text box.
Now, you should check over the cell references in the Changing Cells text box to make sure that they’re correct. You can modify them if nec- essary by clicking the Changing Cells text box and then by clicking the cells in the worksheet while holding down the Ctrl key. You can also edit the note in the Comment box if you want to add more information about your assumptions as part of the new scenario.
By default, Excel protects a scenario from changes when you turn on protection for the worksheet (see Book IV, Chapter 1, for details) so that you can’t edit or delete the scenario in any way. If you want Excel to hide the scenario as well when worksheet protection is turned on, click the Hide check box. If you don’t want to protect or hide the scenario when worksheet protection is turned on, click the Prevent Changes check box to remove its check mark, and leave the Hide check box as it is.
5. In the Protection section of the Add Scenario dialog box, choose what kind of scenario protection that you need, if any, with the Prevent Changes and Hide check boxes.
Now you’re ready to specify the changing values for the new scenario.
6. Click OK in the Add Scenario dialog box.
This action closes the Add Scenario dialog box and then opens the Scenario Values dialog box, similar to the one shown in Figure 1-6.
The Scenario Values dialog box numbers and shows the range name (assuming that you named each of the cells), followed by the current value for each of the changing values that you selected in the worksheet before starting to define different scenarios for your spreadsheet.
You can accept the values shown in the text box for each changing cell if it suits the current scenario that you’re defining, or you can increase or decrease any or all of them as needed to reflect the scenario’s assumptions.
Book VII Chapter 1
Performing What-If Scenarios