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

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... 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: B1 Again, if you add a Scenario, Excel may show the reference cell that was in the previous Scenario. If not, you can use the little lookup button to click on Cell B1, the Price, or type it.   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 B1: 2.00 Keeeeeeep going... Data -> Data Tools ->What-If Analysis -> Scenario Manager