Excel 2003 In Pictures
Making Data Visible
, calculate the amount financed.
Add the price and the finance charge.
, calculate the estimated monthly payment for the Cooper Mini.
Divide the amount financed by the number of payments.
, calculate the average price of both cars.
, calculate the maximum finance charge.
Calculate the finance charge, amount financed, and estimated monthly payment on the Hummer.
When you're done, the worksheet should look like this:
Save the workbook as
Practice Excel Files
Close the workbook.