Question: 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
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.)*
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help