Ission deadline. Alter that, assignments will not be accepted Assignment From the file "CanadianSales Data.xlsx", generate the following ten results using pivot tables. Each pivot table should appear on a separate worksheet. Within each pivot table, the cell(s) containing the required information should be highlighted, preferably in light orange. In the highlight tab, the theme colors block has "Orange, Accent 2. Lighter 60%" - you can hover your cursor over colors to see their names. But if you have trouble figuring it out, any non-obnoxious light color shade for highlighting is fine. 1) Show the sum of Sales for Customer Segment = Corporate and Region = West 2) Show the sum of Sales for Region = Prairie and Province = Saskatchewan, separately for each month from 1/2019 to 5/2019 (use Order Date) 3) Show the 10 customers who have the highest sum of Sales during 2018 (use Ship Date) 4) Show all orders (use Order ID) where Sales > $600 and the Product Category is Furniture 5) From the Region with the highest sum of Sales, show the three Product Sub-Categories with the highest sum of Sales 6) Show the average Sales value for each combination of Region and Order Priority 7) Show the average Sales value for each combination of Ship Mode and Customer Segment 8) For each Province, show the sum of Sales separately for each month from 1/2020 to 6/2020 (use Order Date) 9) For the entire year 2019, show each Region's sum of Sales as a percentage of the sum of all Sales during the year (use Ship Date) 10) Show the 10 largest Order Quantities where Product Container = Wrap Bag and Order Priority = Critical Ission deadline. Alter that, assignments will not be accepted Assignment From the file "CanadianSales Data.xlsx", generate the following ten results using pivot tables. Each pivot table should appear on a separate worksheet. Within each pivot table, the cell(s) containing the required information should be highlighted, preferably in light orange. In the highlight tab, the theme colors block has "Orange, Accent 2. Lighter 60%" - you can hover your cursor over colors to see their names. But if you have trouble figuring it out, any non-obnoxious light color shade for highlighting is fine. 1) Show the sum of Sales for Customer Segment = Corporate and Region = West 2) Show the sum of Sales for Region = Prairie and Province = Saskatchewan, separately for each month from 1/2019 to 5/2019 (use Order Date) 3) Show the 10 customers who have the highest sum of Sales during 2018 (use Ship Date) 4) Show all orders (use Order ID) where Sales > $600 and the Product Category is Furniture 5) From the Region with the highest sum of Sales, show the three Product Sub-Categories with the highest sum of Sales 6) Show the average Sales value for each combination of Region and Order Priority 7) Show the average Sales value for each combination of Ship Mode and Customer Segment 8) For each Province, show the sum of Sales separately for each month from 1/2020 to 6/2020 (use Order Date) 9) For the entire year 2019, show each Region's sum of Sales as a percentage of the sum of all Sales during the year (use Ship Date) 10) Show the 10 largest Order Quantities where Product Container = Wrap Bag and Order Priority = Critical
