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

Add: Edit the Scenario 2. What Do You See? You will be prompted to Add the Scenario.   Please enter the following: Scenario Name: Expected Price Changing Cells: B1 You can use the lookup button on the right side to click on Cell B1, the Price, or type the reference if you wish.   Click OK. Keep going... Data -> Data Tools->What-If Analysis-> Scenario Manager