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

656 Exploring Different Scenarios Producing a summary report
After creating the different scenarios for your worksheet, you can use the Summary button in the Scenario Manager dialog box to create a summary report that shows the changing values used in each scenario and, if you want, key resulting values that each produces. When you click the Summary button, Excel opens a Scenario Summary dialog box, similar to the one shown in Figure 1-8, where you may designate a cell selection of result cells in the Result Cells text box to be included in the report. After selecting the result cells for the report, click OK to have Excel generate the summary report and display it in a new worksheet window.
In the example shown in Figure 1-8, the cell range C7:G7, containing the pro- jected income figures for the sales forecast, are designated as the result cells to be included in the summary report. Figure 1-9 shows the actual summary report generated for this sample worksheet in a new document window. Note that because all the changing and result cells in this worksheet are named, the summary report uses their range names in place of their cell references. Also, when the Scenario Manager generates a summary report, it automatically outlines the summary data, thus creating two vertical levels — one for the changing cells and another for the result cells.
Figure 1-8:
Designating the result cells in the Scenario Summary dialog box.