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 Enter the Values 3. Try This: Enter the Values When you are done editing the Scenario and click OK, you will be prompted to Enter a value. Please type in 3.25.   Click OK, again and you will return to the Scenario Manager.   This step makes a benchmark: This is Expected Price, $3.25, what we started with. In the following pages, we will Add a Scenario for Worst Case and one for the Best Case.   Each of these examples will change one Reference Cell-the Price in Cell B1. At the end of this lesson, we see how to create a Scenario with more than one reference Cell.   So, keep going...