To create a summary report for a given scenario, choose Tools->Scenarios from the menu bar to display the Scenario manager.

In the scenario manager box, click the Summary button.

This will display the Scenario Summary box. Here you can choose to create a PivotTable based on the scenarios, or a scenario summary by selecting the appropriate radio button. In this example, scenario summary is selected. The next step is to select the result cells that you want to be shown in the summary report and then click OK to create the summary.

The summary report will be created on a new worksheet. The report contains a list of cell references for the changing cells from the various scenarios. It also contains a column of current values, for the changing cells, and a column of changed values corresponding to each of the available scenarios. There is also a row of scenario names across the top of the columns to identify which scenario a given column of values belongs to. At the bottom of the report, you can see the values for the results cells corresponding to each scenario.