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

Data -> Data Tools ->What-If Analysis -> Scenario Manager Add Another Scenario At this point, the Scenario Manager has one Scenario: the Expected Price. Here are the steps to Add another Scenario.   4. Try This: Add Another Scenario The Scenario Manager is open. Click on: Add   You will be prompted to fill in the blanks: Scenario Name: Best Case Changing Cells: B1 When you add another Scenario, Excel may display the reference cell that was used in the previous Scenario. If not, you can use the 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: 5.00   Keep going...