What-If Analysis

In Excel what if analysis lets you answer questions with data. With what if analysis Excel also lets you experiment with data.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Use Goal Seek to determine an unknown value. If you're using the example, go to the History Class worksheet and use Goal Seek to determine what grade you would need on Test 3 to earn a final grade average of 90.