Working with Basic 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 2010 workbook. If you want, you can use this example.
  2. Create a function that contains more than one argument.
  3. Use AutoSum to insert a function. If you are using the example, insert the MAX function in cell E15 to find the highest-priced supply.
  4. Insert a function from the Functions Library. If you are using the example, find the PRODUCT function (multiply) to calculate the Unit Quantity times the Unit Price in cells F19 through F23.
  5. Use the Insert Function command to search and explore functions.