Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.4 Create Scenarios: Use What If Analysis Tools Including Goal Seek

Data -> Data Tools->What-If Analysis-> Goal Seek Data: Goal Seek Options 3. What Do You See? The Goal Seek Status shows the Target Value of 15000. The Current Value in Cell E29 is set to $15,000.   What Else Do You See? The Price in Cell B1 changed from $3.25 to 4.207574. This is the new Price you need to reach the goal of $15,000 in sales. If you click OK, the new Price in Cell B1 will be kept.   Do This, Please: Click CANCEL to undo the changes made by the Goal Seek.   Memo to Self: The Price in Cell B1 looks odd with all the decimal places. You can format Cell B1 for currency if you wish.