Create and Show a Scenario : What If Scenario « Data Analysis « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Data Analysis
3. What If Scenario

Click the Data tab. 
           Click the What-If Analysis button, 
           and then click Scenario Manager.

Click Add.

Type a name that identifies the scenario.

Type the cells you want to modify in the scenario.

Select the Prevent changes check box to protect the cell.

Click OK.

Type values for each of the displayed changing cells.

Then Click OK. Click Close.

10.6.What If Scenario
	10.6.1.	Create a 'What-If' Scenario with Goal Seek
	10.6.2.	Create and Show a Scenario
	10.6.3.	Show a Scenario
	10.6.4.	Create a Scenario Summary or PivotTable Report