Practice: Performing Basic Calculations


  1. In the Title Bar, click the drop-down arrow, then New.

  2. Then click the icon.

    This will create a new workbook.
  3. Enter the following data:

  4. In cell D4, calculate the total price of both cars together.
  5. In cell D5, calculate the total payments made for both cars.
  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.
  1. TIP: Add the price and the finance charge.
  2. In cell B9, calculate the estimated monthly payment for the Cooper Mini.

    TIP: Divide the amount financed by the number of payments.
  3. In cell F4, calculate the average price of both cars.
  4. In cell G7, calculate the maximum finance charge.
  5. Calculate the finance charge, amount financed, and estimated monthly payment on the Hummer.

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

  6. Save the workbook as Cars in the Practice Excel Files folder.
  7. Close the workbook.