Excel Project.

REQUIRED

a. Create a spreadsheet that contains the following data:

SALESPERSON DATE CALLS MADE Smith 07/03 100 Barnes 07/05 110 Martinez 07/13 95 Jackson 07/20 115 Hsu 07/28 120 Smith 08/01 125 Barnes 08/02 115 Hsu 08/10 110 Barnes 08/10 100 Martinez 08/14 135 Jackson 08/20 115 Smith 08/22 90 Barnes 08/23 85 Martinez 09/01 100 Jackson 09/02 90 Hsu 09/05 95 Jackson 09/11 140 Hsu 09/11 150 Smith 09/15 110 Barnes 09/20 120 Martinez 09/30 120 Jackson 09/30 90 Hsu 09/30 60

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.

CALLS MADE BY SALESPERSON THIS QUARTER JULY AUGUST SEPTEMBER Barnes Hsu 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.)*