Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.4 Create Scenarios: Use the Scenario Manager

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