Excel 2010

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?