GCFLearnFree.org

This site covers more than I ever dreamed.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2010
  • Using What-If Analysis

Excel 2010

Single page view print copy

Using What-If Analysis

Challenge!

  1. Open an existing Excel workbook. If you want, you can use this example.
  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.
  3. Insert the PMT function into the worksheet. If you are using the example, go to the Car Loan worksheet and insert the function into cell B5.
  4. Use Goal Seek to find the interest rate you will need in order to have a monthly payment of $400. What interest rate would you need if you could only afford a $380 monthly payment?
previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.