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!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Create a function that contains one argument. If you're using the example, use the SUM function in cell B16 to calculate the total quantity of items ordered.
  3. Use the AutoSum command to insert a function. If you are using the example, insert the MAX function in cell B23 and use the cell range D3:D15 for the argument to find the most expensive item that was ordered.
  4. Explore the Function Library, and try using the Insert Function command to search for different types of functions.