1231 1 1232 2 1233 3 1234 1 1235 1 1236 1 1237 2 1238 1

1231 1 1232 2 1233 3 1234 1 1235 1 1236 1 1237 2 1238 1 1239 3 1240 1 1241 2 1242 2 1243 2 1244 1 1245 3 1246 1 1247 2 1248 1 1249 3 1250 4 Using the following data use pivot tables to answer the following questions: 1. Prepare a pivot table that shows how many of each specific product is sold by each salesperson. 2. Prepare a pivot table that shows phone sales and store sales for each salesperson Invoice Salesperson Product Location Qty sold Bill Haley Shaun Joyce Joe Guitar Amp Keyboard Drums Store Phone
Attachments: