Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

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

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

Add Another Scenario

At this point, the Scenario Manager has one Scenario: the Expected Price. Here are the steps to Add another Scenario.

 

4. Try This: Add Another Scenario

The Scenario Manager is open.

Click on: Add

 

You will be prompted to fill in the blanks:

Scenario Name: Best Case

Changing Cells: $B$1

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

 

Click OK. When you click on OK, the Scenario Manager will prompt you to enter a new value for each reference cell.

 

Try This, Too: Enter the Scenario Value

Scenario Value for $B$1: 5.00

 

Keep going...