Excel Project.

REQUIRED

a. Create a spreadsheet that contains the following data:

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.

(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.)*

Transcribed Image Text:

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