Excel 2013 & 365 In Pictures

6 In cell E4, calculate the difference in price between the two cars.

7 In cell E5, calculate the difference between the number of payments.

8 In cell B7, calculate the finance charge for the Cooper Mini.

TIP: Multiply its price by the interest rate.

9 In cell B8, calculate the amount financed.

TIP: Add the price and the finance charge.

10 In cell B9, calculate the estimated monthly payment for the Cooper Mini.

TIP: Divide the amount financed by the number of payments.

11 In cell F4, calculate the average price of both cars.

12 In cell G4, calculate the maximum price of the two cars.

13 On the Hummer, calculate the:

Finance charge
Amount financed
Estimated monthly payment

When you're done, the worksheet should look like this:

14 Save the workbook as Cars on the desktop.

15 Close the workbook and Excel.