Add Yet Another Scenario

Now there are two Scenarios: Expected Price and Best Case. Here are the steps to Add the Worst Case Scenario. When all 3 Scenarios are done, you'll see how it works... and it really does work well.

 

5. Try This: Add Yet Another Scenario

The Scenario Manager is open.

Click on: Add

 

You will be prompted to fill in the blanks:

Scenario Name: Worst 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: 2.00

 

Keeeeeeep going...

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