Show the Scenario

The Scenario Manager has three different Scenarios: Best, Worst and Expected. How does it work? Say you wanted to show off the Best Case Scenario. Here are the steps.

 

6. Try it: Show the Scenarios

Select a Scenario: Best Case

Click on Show.


The Price in Cell B1 changed from $3.25 to $5.00. All of the formulas in Column E updated and used the new Price to calculate the Revenue. Yeah!

 

Try This, Too: Show Another Scenario

Select a Scenario: Worst Case

Click on Show.

The Price in Cell B1 changed from $5.00 to $2.00. Boo Hoo.

 

And Try This: Show A Different Scenario

Select a Scenario: Expected Price.

Click on Show....Very Good.

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

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

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