Every day I fall a little more in love with your site.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2013

Single page view print copy

Functions

Challenge!

  1. Open an existing Excel workbook. If you want, you can use the Lesson 16 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.
1 2 3 4 5