Excel Project.REQUIREDa. Create a spreadsheet that contains the following data:...

Excel Project.

REQUIRED

a. Create a spreadsheet that contains the following data:

SALESPERSON	DATE	CALLS MADE
Smith	07/03/2014	100
Barnes	07/05/2014	110
Martinez	07/13/2014	95
Jackson	07/20/2014	115
Hsu	07/28/2014	120
Smith	08/01/2014	125
Barnes	08/02/2014	115
Hsu	08/10/2014	110
Barnes	08/10/2014	100
Martinez	08/14/2014	135
Jackson	08/20/2014	115
Smith	08/22/2104	90
Barnes	08/23/2014	85
Martinez	09/01/2014	100
Jackson	09/02/2014	90
Hsu	09/05/2014	95
Jackson	09/11/2014	140
Hsu	09/11/2014	150
Smith	09/15/2014	110
Barnes	09/20/2104	120
Martinez	09/30/2014	120
Jackson	09/30/2014	90
Hsu	09/30/2014	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.)*

* Life-long learning opportunity: see p. xxii in preface.