Calculate averages


  1. Click in cell A13, then type:

    Subsidies

  2. In cells A14 through C14, type:

    2000

    2001

    2002

  1. In cells A15 through C15, type:

    2000

    2001

    2002

    10000

    8000

    12000

  2. In cell E14, type:

    Average

  1. In cell F14, type:

    =average(

    TIP: Don't forget to type the ( opening parenthesis. It tells Excel to begin averaging a series of cells.
  2. Highlight cells A15 through C15.

    The worksheet should look like this:

  1. Press the ENTER key.

    The average subsidy should be 10000:

  2. Click cell F14.

    The Formula Bar should show:

    =AVERAGE(A15:C15)



    TUTORIAL EXCEL 2007