Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.2. Apply data analysis: Data Tools What-If Analysis

Add: Edit the Scenario

2. What Do You See? You will be prompted to Edit the Scenario.

 

Please enter the following:

Scenario Name: Expected Price

Changing Cells: $B$1

You can click on Cell B1, the Price, or type the reference if you wish. This is an Absolute Reference.

 

Click OK. Keep going...

Data -> Data Tools->What-If Analysis-> Scenario Manager