Format Paint BIU 3 Merge & Centers Clipboard % Conditional Forma Formatting the Norma 10 MIKE'S MUSIC - Sales List MNO 2 Invoice # Salesperson Product Location Quantity Sold 1231 Bill Guitar Store 1232 Haley Amp Store 1233 Shaun Guitar Store 1234 Bill Keyboard Store 1235 Haley Drums Phone 1236 Shaun Amp Phone 1237 Moonbeam Guitar Store 1238 Moonbeam Guitar Store 1239 Joe Drums Phone 12 1240 Shaun Keyboard Phone 13 1241 Shaun GuitarPhone 1242 Haley Amp Store 15 1243 Bill Keyboard Store 16 1244 Haley Amp Phone 1245 Shaun Keyboard Store 18 1246 Moonbeam Drums Phone 19 1247 Joe Drums Phone 1248 Haley Amp Store 21 1249 Joe Drums Phone 22 1250 Bill Guitar Store 23 24 1Create a pivot table showing which products are being sold by which sales people. Save Worksheet at "Products by Salesperson." 25 2) Create a pivot table bar chart showing how many products are sold by each sales person. The chart can be on the "Products by Salesperson worksheet. 26 2) Create a pivot table showing how many products are being sold in the Store. Save Worksheet as "Store Sales." 273) Create a pivot table showing how many keyboards are being sold at the store versus over the phone. Save Worksheet at "Keyboard Sales NNNN 17