More Than One Value

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

 

2. Try it: Edit the Values

Scenario Value for $B$1: 6.00

Scenario Value for $B$1: 200

Scenario Value for $B$1: 20

 
Click OK to return to the Scenario Manager.

 

Try This, Too: Add One More Scenario

Click on: Add

 

You will be prompted to fill in the blanks:

Scenario Name: Change Back

Changing Cells: $B$1, $B$2, $B$3

 

Now, Try it: Edit the Values

Scenario Value for $B$1: 5.00

Scenario Value for $B$1: 100

Scenario Value for $B$1: 5

 

Keep 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