Assignment Details

Functions Practice

Academic Year 2017/18

Computer Applications 1st Period Tue/Thu/FriB

Date Due

April 20, 2018

Additional Info
  1. Open an existing Excel workbook Functions Practice.
  2. Create a function that contains one argument. If you're using the example, use the SUM function in cell B16to 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.