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 sum-product function and the use of double dashes. The Journal of

Accountancy is available either in print or online at www.aicpa.org.)*