Calc 2.0 In Pictures

Practice: Basic Calculations

  1. On the Toolbar, click the icon to open a new workbook.
  2. Enter the following data:

     

    A

    B

    C

    D

    E

    F

    G

    1

    Buying an HDTV

    2

    3

    Dream Television

    LCD

    Plasma

    Total

    Diff

    Avg

    Max

    4

    Price

    4000

    17000

    4

    Payments

    36

    24

    4

    Interest Rate

    .11

    .12

    7

    Finance Chg

    8

    Amt Financed

    9

    Est Monthly Pmt
  3. In cell D4, calculate the total price of both televisions together.
  4. In cell D5, calculate the total payments made for both televisions.
  5. In cell E4, calculate the difference in price between the two televisions.
  6. In cell E5, calculate the difference between the number of payments.
  7. In cell B7, calculate the finance charge for the LCD television.

    TIP: Multiply its price by the interest rate.
  8. In cell B8, calculate the amount financed.

    TIP: Add the price and the finance charge.