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

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