Using Functions

When using Excel XP functions play an important role in finding values for a range of cells. Learn all about using functions in Excel XP.

Challenge!

  • Type the following information:

    In cell A1, type 7842.
    In cell A2, type 5681.
    In cell A3, type 3947.
    In cell B1, type 2594.
    In cell B2, type 9024.
    In cell B3, type 6505.
  • Create a formula in cell A4 that uses the AutoSum function to add the values in cell A1, cell A2, and cell A3.
  • Create a formula in cell B4 that uses the Average function to find the averages of values in cell B1, cell B2, and cell B3.