this image contain instruction please solve it ASAP i will give you hundred percent postive response

Customer 315 315 233 14 572 A B 1 OrderDate ProductID ProductName 2 04-Jan-11 22 Mozzarella cheese 3 04-Jan-11 16 Romaine lettuce 4 05-Jan-11 30 Red onions 5 06-Jan-11 16 Romaine lettuce 6 07-Jan-11 2 Black olives 7 07-Jan-11 16 Romaine lettuce 8 07-Jan-11 16 Romaine lettuce 9 08-Jan-11 30 Red onions 10 09-Jan-11 16 Romaine lettuce 11 10-Jan-11 16 Romaine lettuce 12 10-Jan-11 39 Pineapple 13 11-Jan-11 39 Pineapple 14 14-Jan-11 16 Romaine lettuce 15 14-Jan-11 16 Romaine lettuce 16 15-Jan-11 85 Pepperoni 17 15-Jan-11 100 Parmesan cheese 18 16-Jan-11 100 Parmesan cheese 1918-Jan-11 100 Parmesan cheese 2018-Jan-11 16 Romaine lettuce 21 | 20-Jan-11 4 Tomatoes 22 21-Jan-11 31 Peppers 23 | 21-Jan-11 22 Mozzarella cheese 24 | 23-Jan-11 2 Black olives 25 | 24-Jan-11 22 Mozzarella cheese 26 26-Jan-11 16 Romaine lettuce 27 27-Jan-11 100 Parmesan cheese 28 28-Jan-11 31 Peppers 29 28-Jan-11 22 Mozzarella cheese 30 29-Jan-11 4 Tomatoes D E F G H 1 Quantity Unit Price Total Sales Unit Cost Total Cost Profit 47 $ 24.00 $ 1,128.00 $ 18.00 $ 846.00 $ 282.00 91 $ 15.00 $ 1,365.00 $ 14.00 $ 1,274.00 $ 91.00 33 $ 12.00 $ 396.00 $ 8.00 $ 264.00 $ 132.00 71 $ 15.00$ 1,065.00$ 14.00 $ 994.00 $ 71.00 81 $ 12.00 $ 972.00 $ 6.00 $ 486.00 $ 486.00 45 $ 15.00 $ 675.00$ 14.00 $ 630.00 $ 45.00 51 $ 15.00$ 765.00$ 14.00$ 714.00 $ 51.00 43 $ 12.00$ 516.00 $ 8.00 $ 344.00 $ 172.00 65 $ 15.00 $ 975.00 $ 14.00 $ 910.00 $ 65.00 55 $ 15.00$ 825.00 $ 14.00 $ 770.00 $ 55.00 41 $ 33.00 $ 1,353.00 $ 28.00 $ 1,148.00 $ 205.00 72 $ 33.00 $ 2,376.00 $ 28.00 $ 2,016.00$ 360.00 15 $ 15.00 $ 225.00 $ 14.00 $ 210.00 $ 15.00 25 $ 15.00$ 375.00$ 14.00 $ 350.00 $ 25.00 38 $ 53.00 $ 2.014.00 $ 35.00 $ 1,330.00 $ 684.00 11 $ 8.00 $ 88.00 $ 4.00 $ 44.00 $ 44.00 71 $ 8.00 $ 568.00 $ 4.00 $ 284.00 $ 284.00 11 $ 8.00 $ 88.00 $ 4.00 $ 44.00 $ 44.00 41 $ 15.00 $ 615.00 $ 14.00 $ 574.00 $ 41.00 45 $ 9.00 $ 405.00 $ 7.00$ 315.00$ 90.00 31 $ 21.00 $ 651.00 $ 12.00 $ 372.00 $ 279.00 11 $ 24.00 $ 264.00 $ 18.00 $ 198.00 $ 66.00 95 $ 12.00 $ 1,140.00 $ 6.00 $ 570.00 $ 570.00 48 $ 24.00 $ 1,152.00 $ 18.00 $ 864.00 $ 288.00 55 $ 15.00 $ 825.00 $ 14.00 $ 770.00 $ 55.00 65 $ 8.00 $ 520.00 $ 4.00 $ 260.00 $ 260.00 86 $ 21.00 $ 1.806.00 $ 12.00 $ 1,032.00$ 774.00 11 $ 24.00 $ 264.00 $ 18.00 $ 198.00 $ 66.00 4115 9.00 $ 369 00 $ 700 $ 287 00 15 82 00 23 6 95 846 557 315 846 557 572 14 14 95 95 14 23 846 95 23 557 23 572 6 846 6 K Customer SalesRep The Station PJ Helgoth The Station Roberta Cross Bert's Bistro Loraine Schultz Smoke House Roberta Cross Flagstaff House Loraine Schultz Two Bitts Loraine Schultz Pierce Arrow Roberta Cross Mamm'a Pasta Palace Loraine Schultz The Dandelion Loraine Schultz Carmens Loraine Schultz The Station Loraine Schultz The Dandelion Loraine Schultz Carmens Loraine Schultz Flagstaff House PJ Helgoth Smoke House Roberta Cross Smoke House Loraine Schultz Mamm'a Pasta Palace Roberta Cross Mamm'a Pasta Palace Loraine Schultz Smoke House Roberta Cross Two Bitts Loraine Schultz The Dandelion Roberta Cross Mamma Pasta Palace PJ Helgoth Two Bitts Roberta Cross Carmens Loraine Schultz Two Bitts Loraine Schultz Flagstaff House Loraine Schultz Pierce Arrow Loraine Schultz The Dandelion PJ Helgoth Pierce Arrowsettings Roberta Cross A B D F G . 2 3 4 6 7 Q# Name Total 8 1 2 9 10 3 11 4 12 5 13 6 7 Schweitzer Distribution Analysis Question Who is the company's best customer by total sales? Who is the company's worst customer by total sales Who is the company's best customer by profit? Who is the company's worst customer by profit? What is the company's best selling product by total sales? What is the company's worst selling product by total sales? What is the company's best selling product by profit? What is the company's worst selling product by profit? Who is the company's best sales representative by profit? Who is the company's worst sales representative by profit? What is the best sales representative's best selling product (by total profit)? Who is the best sales representative's best customer (by total profit)? What is the best sales representative's worst selling product (by total profit)? Who is the best sales representative's worst customer (by total profit)? 14 15 8 16 17 9 10 11 18 19 12 13 20 21 14 ** Select the name using the drop down list Activate Windows 26 MIDT LOL INTRO TO MANAGEMENT INFORMATION SYSTEMS Excel Assignment 05 Due: Thursday, 08 June 2021 by 11:59pm Points Possible for This Assignment: 50 Requirements: You have been asked to assist the company's owner, Bob, to answer several questions he has about his customers and salespeople. The Excel file can be found Bb in the Content Excel Assignments Project Excel Assignment 05 folder. Create Pivot Tables for each question on the Solution tab of the spreadsheet. Answer the questions on the Solution tab in the spreadsheet. For each question, create a New Worksheet for each pivot table and name the worksheet Q1, Q2, Q3,...,014, depending on which question you are answering, The tabs (worksheets) must be renamed to correspond to the question being answered. The order of the tabs in your final Excel file must be in the following order: Customer Relations, Solution, Q1, Q2, Q3, ..., Q14. Attach your resulting spreadsheet to the Excel Assignment 05 assignment in Blackboard. It can be found in the Excel Assignments/Project content area, in the Excel Assignment 05 folder