A worksheet is formatted and filled with sales figures from Q1. Functions are used to find the total (sum), average, median, maximum and minimum figures for the salespeople and each item.

Excel Workbook Download
E2010T6.xlsx