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 sum product function to create a formula that automatically calculates the total calls handled.

 
 

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 07/05 07/13 07/20 07/28 08/01 08/02 08/10 08/10 08/14 08/20 08/22 08/23 09/01 09/02 09/05 09/11 09/11 09/15 09/20 09/30 09/30 09/30 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 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 07/05 07/13 07/20 07/28 08/01 08/02 08/10 08/10 08/14 08/20 08/22 08/23 09/01 09/02 09/05 09/11 09/11 09/15 09/20 09/30 09/30 09/30 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

Answer rating: 100% (QA)

14G Vo 1 826 l Lea III Answer Cla Paste prcial avu Step 1 of 5 a Spreadsheet with th... View the full answer