Using Functions

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

Challenge!

  • In Excel, re-create the spreadsheet shown below.
  • In cell address B11, enter the sum of the range B5:B9 using the Sum function.
  • Copy the formula to the other columns (C11:F11), totaling columns C, D, E, and F.
  • In cell address B12, enter the average of the range B5:B9 using the Edit Formula button.
  • Copy the function to the other columns (C12:F12), averaging columns C, D, E, and F.
  • Use the Paste Function button Paste Function Button to enter the COUNT in cell B13. Copy the function to the other columns (C13:F13).

Mary's Boutique Example