One of the best-designed sites ever. Learning is made so easy.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2010

Single page view print copy

Working with Basic Functions

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.
1 2 3 4 5 6