12.13 Excel Project REQUIRED a. Create a spreadsheet that contains the following data: CALLS MADE 100 110 95 115 120 125 SALESPERSON Smith Bames Martinez Jackson Hsu Smith Bames Hsu Bames Martinez Jackson Smith Bames Martinez Jackson 115 DATE 07/03 07/05 07/13 07/20 07/28 08/01 08/02 08/10 08/10 08/14 08/20 08/22 08/23 09/01 09/02 09/05 09/11 09/11 09/15 09/20 09/30 09/30 09/30 Hsu 110 100 135 115 90 85 100 90 95 140 150 110 120 120 90 60 Jackson Hsu Smith Bames Martinez Jackson Hisu b. On the same worksheet, but to the right of the data above, create the following table to show calls made by each salesperson this quarter. Use the sumproduct function to create a formula that automatically calculates the total calls handled. SEPTEMBER CALLS MADE BY SALESPERSON THIS QUARTER JULY AUGUST Barnes Hisu Jackson Martinez Smith (Hint: Read the article "Supercharge Your Excel Sum Operations: Add data by up to 30 criteria." by J.D. Kern in the July 2009 issue of the Journal of Accountancy for an explanation of the sumproduct function and the use of double dashes. The Journal of Accountancy is available either in print or online at www.aicpa.org.)*