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

Data Tools: Goal Seek Goal Seek asks the question backwards, starting from the answer. In this spreadsheet, the question is: how much money did you make? The answer is the SUM in Cell E29.   In this sales spreadsheet, Goal Seek asks: How much do you want to make? Which value do you want to change: Price, Start or Increment?   Keep going, please...