Assignment From the file CanadianSalesData.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 AutoSave OF AA Canadian Sales Data Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibrl (Body) v 11 v AP h Wrap Text General Insert v X [ G 7 0 v Delete v Paste BIU :- ~ Ar = = = Merge & Center v Y Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity # Format Find & Select Analyze Data V M8079 X f British Columbia F G H K M 0.07 B Row ID Order ID 2 1 3 2 6 6 32 5 3 32 4 32 7 5 32 A 7 35 9 8 35 10 S 36 11 10 55 12 11 56 13 12 69 14 13 59 15 14 70 16 15 70 17 16 96 18 17 97 19 18 129 20 15 130 21 20 130 22 21 130 23 23 132 24 22 132 25 24 134 26 25 135 27 26 156 22 27 193 29 28 194 30 25 194 31 30 195 32 31 197 33 32 224 34 33 224 35 34 224 36 35 225 37 36 225 38 37 229 39 38 229 40 39 230 41 10 230 42 41 231 43 42 258 44 13 258 Sheet1 D C Order Date Order Priority 10/11/18 Low 2/18/20 Not Specified 7/13/19 High hi 7/13/19 High 7/13/19 High 7/13/19 High 10/20/15 Not Specified 10/20/19 Not Specified 10:31/19 Critical 3/15/15 Critic 1/17/17 Law 6/1/17 Not Specified 541/17 Net Specified 12/15/18 Law 12/15/18 Low 1/14/17 High 1/25/18 Medium 11/16/20 Low 5/5/20 High 5/5/20 High 5/5/20 High S/B/18 Medium 5/8/18 Medium 4/29/20 Not Specified 10/18/15 Not Specified 9/9/19 High 8/5/18 Critical 4/2/20 Medium 4/2/20 Medium 12./25/18 Medium 4/1/18 High 6/15/17 Not Specified 6/15/17 Not Specified 6/15/17 Not Specified 5/22/15 Critical 5/22/19 Critica 12/26/18 Critic 12/25/18 Critical 10:/24/18 Critical 10/24/18 Critic 9/25/17 High 12/26/18 Critical 12/25418 Critic + Order Quantity Sales 6 261.54 2 5.93 15 140.56 26 280RON 24 1751.4 23 160.2335 30 288.56 14 1892.848 46 2484.746 32 3812.73 41 108.15 42 1180.16 28 51.53 48 S0.05 46 7904.53 37 4158.124 26 75.57 4 32.72 3 161.89 29 575.11 23 236.46 30 1011,65 27 192.814 11 1132.6 25 125.85 10 567.936 14 174.99 49 329.03 20.15 34 1315.74 23 310.52 25 184.86 44 267.95 33 528.5 24 125.58 1 1 23.7 43 586.11 24 599.2 47 2029.75 11 1118.396 2 689.74 21 154.33 7 7 201.36 Discount Ship Mode 0.04 Regler All 0.01 Regular Alr 0.04 Regular Air 0.07 Reguler Air 0.09 Delivery Truck 0.04 Regular Air 0.03 Reguler Air 0.01 Regular Ale 0.1 Regular Air 0.02 Regler Air 0.09 Regular Air 0.09 Regular Air 0.03 seres 0.03 Express Air 0.03 Regular Air 0.05 Regular Air 0.01 Regler Air 0.03 Regular Air 0.09 Regular Air 0.05 Express Air 0.02 Regular Ale 0.05 Regular Air 0.05 Delivery Truck 0.03 Regular Lir 0.01 Regular Air 0.09 Regular Air 0.02 Express Air 0.06 Regular Air 0.1 Reguler Air 0.04 Regular Ale 0.03 Regular Air 0.01 Reguler Air 0.09 Regular Air 0.04 Regular Air 0.04 Regier Air 0.06 Regular All 0.05 Regular Air 0.11 Reguler Air 0.02 Regular Air 0.06 Regular Air 0.06 Regal Air 0.06 Regular All Regular Air O Diver Truck Profit -213 25 4.54 -128 38 1054 82 -1748.56 -95.13 6072 48.99 657.48 1470 30 7.57 511.69 035 107.00 2057 17 1228 80 28.24 -22.59 -309 82 71.75 -134.31 -503 80 86.20 -310.21 -89 25 -126 09 -37.04 -197 25 13.44 260.87 3322 33.95 -65.43 -119 92 18.27 8.97 9844 3.82 32037 -212 33 490.84 -91.14 -28440 Unit Price hipping Cos Customer Name 38.94 35 Rosemarie Orkney 2.08 2.55 Sandra Bragatti 9.46 9.99 LBoine Reaman 107.53 5.81 Marie Domelow 70.89 89.3 Cinderella Racsdale 7.99 5.03 Maribel Ilieve 9.11 2.25 Kerwin Caalen 155.99 8.99 Rosemarie Orkney 65.99 4.2 Horatia Verce . 115.79 1.99 Sergio Nudes 2.83 0.7 Miller Warthing 30.93 3.92 Beltran Heyball 1.66 0.7 Sommy Balir forth 1.85 2.58 Dorelle conden 205.99 5.99 Wanca Heathcott 125.99 B.99 Ode Mallere 2.89 Os arvin Eccot 6.49 9.19 Jenn Gainsburgh 150.98 13.99 Katee Geele 18.97 9.03 Cristina Festass 9.71 9.45 Starton Matei 130.98 51.74 leri Dilleston 7.99 5.03 Live Nesterov 95.99 35 Mari Gossop 4.98 4.62 Natalie Hanney 262 Naval 55.99 8.99 Elihu Space 12.44 6.27 Zsuzsa McCarver 7.28 7.58 Waly Andraletti 3.14 1.92 Macdy Pouden 36.35 13.99 Addaice Dak 12.98 3.14 Merrielle Scrimshire 7.38 5.21 Granville Frickey 5.98 5.15 Petr Jimeno 15.12 10.68 Barby Noades 5.55 0.7 Isabel Di Angelo 19.94 4.1 Rancell Altres 12.64 4.58 Rupert Boup 24.92 12.98 Darb Binton 43.99 9.99 Morton Castells 125.99 B.08 Gideon Burke 353.25 19.99 Henry Rosenblatt 6.49 9.74 Gasparo Mall 20.9 53.08 Nanterne Province Nunavut Alberta Saskatchewan Alberta Alberta Alberta Darius British Columbia British Columbia Alberta Ontario Alberta Saskatchewan Saskatchewa Quebec Quebec Manitoba Yukon Ontario Saskatchewan Saskatchewan Saskatchewan Nova Scotia Quebec Ontario Quebe Manitobs Quebec Alberta Alberta Yukon Manitoba Yukon Yukon Yukon Quebec Quebec Nova Scotia Saskatchewan Ontario Ontario Manitoba Nova Scotia Naya Sentia N 0 Replon Customer segment Product Category Product Sub-Category Nungut Small Business Office Supplies Stare & Organization West Corporate Orice Supplies Scissors, Rulers and Trimmers Prairie corporal Technology Computer Peripherals We Corporate Furniture Office Furnishing West Corporate Furniture Tables West Corporate Techrology Telephones and Communication We Corporate Office Supplies Pers & Art Supplies West Corporate Technology Telephones and Communication West Home Office Technology Telephones and Communication Onteric Corporate Technology Computer Peripherals West Consumer Orice Supplies Pons Art Supplies Prairie Corporate Furniture Office Furnishing mam Prairie Corporate Office Supplies Pers & Art Supplies Quebec Home Olice Orice Supplies Rubber Bands Quebec Home Office Technology Telephones and Communication Prairie Homece Technology Telephones and Communication Muker Consumer Orice Supplies Labas Ontario Corporate Ofice Supplies Paper Prairie Corporate Technology Office Machines Prairie Corporate Office Supplies Paper Prairie Corporate Office Supplies Storage & Organisation Allers Consumer Furniture Bookcase Quebec Consumer Technology Telephanes and Communication Ontario Home Office Office Supplies Storage & Organisation Qurbe Consumer Technology Computer Peripherals Prairie Consumer Tochralogy Telephanes and Communication Quebec Consumer Office Supplies Storage & Organisation Corporate Furniture Office Furnishing West Corporate Orice Supplies Scissors, Rulers and Trimmers Yukor Home Office Oflice Supplies Pens & Art Supplies Prairis Home Office Office Supplies Scissors, Rulers and Trimmers Yukon Corporate Furniture Orice Furnishing Yukar Corporate Office Supplies Paper Vukor Corporate Office Supplies Store & Organization Quebec Home Office Orice Supplies Pons Art Supplies Quebec Home Office Office Supplies Pers & Art Supplies Atlantic Consumer Furniture Office Furnishing Prairie Consumer Omice Supplies Binders and Binder Accessories Ontario Corporate Ofice Supplies Pens & Art Supplies Ontario Corporate Technology Telephones and Communication Prairie Small Business Orice Supplies Appliances Atlantic Home Office Office Supplies Paper Allsti Home Office offunnies Stars & Oupanization Ready + 100% AutoSave OF A A Ao Canadian Sales Data Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibrl (Body) v 11 v AP 2 Wrap Text General Insert v X G 0 0 v Delete v Paste BIU :- Av = = = Merge & Center v Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data Sensitivity V M8079 X f British Columbia V w X Y Z Prairie 1 hipping Cos Customer Name 2 35 Rosemarie Orkney 3 2.56 Sandra Braguetti 4 9.99 Lone Reaman 5 5.81 Maurie Domelow 39.3 Cinderella Rascale 7 5.03 Maribel ilire 8 2.25 Kerwin Conten 8.99 Rosorarie Orkney 10 4.2 Horatia Voyce 11 1.99 Sergio Nudds 12 0.7 Milicen Warthing 13 3.92 Beltran Heyball 14 0.7 Sammy Balm forth 15 2.58 Dorelle cancion 16 5.99 Wanda Heathcott 17 8.99 Ode Mallard 12 0.5 Ervin Eccott 19 9.19 Jenn Gainsburst 20. 20 13.99 Kale Giecie 21 9.03 Olsira Ferlass 22 9.45 Stanion Meth 23 54.74 Jeri Dilleston 24 5.03 Llwie Nesterav 25 35 Mari Gossop 26 4,62 Natalie Hanney 27 8.99 Elihu Space 28 6.27 Zsazsa McCarver 29 7.98 Waly Ardraletti 30 1.92 Maddy Pouiden 31 13.99 Addaide Dax 32 3.14 Merrielle Scrimshire 33 5.21 Granville Frickey 34 5.13 Petr Jirreno 35 10.68 Barby Neades 36 0.7 Iscabal Di Angelo 37 4.1 Rancel Altres 38 4.98 Ruper accup 39 12.98 Darbintan 40 9.99 Morton Castells 41 8.08 Gideon Barke 42 19.99 Henry Rosenblatt 43 9.74 Gasparo Vall 44 53.03 Dante Reme Sheet1 + M Province Nunavut Alberta Saskatchewan Alberts Alberta Alberta Baile British Columbia British Columbia Alberta Ontario Alberta Saskatchewan Saskatchewan Quebec Quebec Manitoba Yukon Ontario Saskatchewa Saskatchewan Saskatchewan Nova Scotia Quebec Ontario Quebe Manitoba Quebec Alberts Alberta Yukon Manitoba Yukon Yukon Yukon Quebec Quebec Nova Scotia Saskatchewan Ontario Ontario Manitob Nova Scotia Nova Scotia N Q Region Customer Segment Product Category Product Sub-Category Nunnut Small Business Office Supplies Store & Organization West Corporate Orice Supplies Scissors, Rulers and Trimmers Prairie Corporate Technology Computer Peripherals West Corporate Furniture Office Furnishings West Corporate Furniture Tables West Corporate Technology Telephones and Communication Corporate Office Supplies Pers & At Supplies West Corparate Technology Telephones and Communication West Home Office Technology Telephones and Communication Ontario Corporate Technology Computer Peripherals West Consumer Orice Supplis Pons Art Supplies Prairie Corporate Furniture Office Furnishing Prairie Corporate Office Supplies Pens & Art Supplies Quebec Home Dice Orice Supplies Rubber Bands Quebec Home Office Technology Telephones and Communication Prairie Home Office Technology Telephones and Communication Yukon Consumer Orice Supplies Labels Ontario Corporate Office Supplies Paper sesupp Corporate Techrolo Orice Machines Prairie Corparate Orice Supplies Paper Prairie Corporate Ofice Supplies Storage & Organization Atlantic Consumer Bookcases Quebec Consumer Technology Telephones and Communication Ontario Home Office Office Supplies Storage & Organisation Que Consumer Technology Computer Peripherals Prairie Consumer Technology Telephones and Cammunication Quebec Consulter Ofice Supplies Storage & Organization Corporate Furniture Office Furnishings West Corporate Orice Supplies Scissors, Rulers and Trimmers Yukon Home Office Ofice Supplies Pens & Art Supplies & Prairie Home Office Office Supplies Scissors, Rulers and Trimmers Yukan Corporate Furniture Orice Furnishings Corporate Office Supplies Paper Yukar Corporate Office Supplies Storage & Organization Queber Home Office Orice Supplies PensArt Supplies Quebec Home Office Office Supplies Pens & Art Supplies Atlantis Consumer Furniture Office Furnishings Prairie Consumer Orice Supplies Sinders and Binder Accessories Ontario Corporate Ofice Supplies Pens & Art Supplies Ontario Corporate Technology Telephones and Communication Prairie Small Businex Orice Supplies Appliances Atlantic Home Office Ofice Supplis Paper Allantic Homelice of Sun Store & Danilson R U Product Name Product Container oduct Base Mary ship Date Eldor Base for stable storage shel Large Box 0.8 10/18/18 Kleancut' Farged Office Shears by Small Pack 0.55 2/19/20 Imation 3.5 IBM Disketes 10/Box Small Pack 0.79 7/14/19 Tenes Contemporary Contur Chair Medium Box 0.55 7/15/19 Kl Conference Tables Jumbo Box 0.72 7/14/19 Bell Sorecor JB700 Caller ID Medium Box 0.6 7/15/19 Dixon Ticanderos Core-lock Color Wrap Bee 0.52 10/21/19 CF685 Small Box 0.58 10/22/19 61621 Small Box 0.55 10/31/19 020 Verbatim DVD-R, 1.7GB, Spindle W Srall Pack 049 3/16/19 Newell 340 Wrap Bag 0.56 1/17/17 Advantus Employee of the Month Ce Small Pack 0.44 6/17 1220 Newell 308 Wrap Be 0.6 6/3/17 Super Bands, 12/rack Wrap Bag 0.82 12/20/18 3285 Small Vox 0.59 12/20/18 SC78681 Sir all Box 0.55 4/16/17 Avery 498 Small Box 0.38 1/27/18 Xerox 217 Small Vox 0.37 11/25/20 Canon MP4 10H Printing Calculator Medium Bor 0.38 577/20 Computer Printout Paper with Let Small Box 0.37 5/6,20 Filing, storage Tots and Swivel Cast Small Box 0.6 5/4/20 O'Sullivan Elevations Bookcase, Che lumbo Box oo 0.59 5/11/18 Bell Sorocar Jezon Caller ID Medium Box 0.6 6/9/18 Safco industrial Wire Shelving Large Box 4/30/20 Irratier 3.5", DISKETTE 44765 HGHUSrall Pack 0.54 10/20/19 1270 Small Box 0.55 9/11/19 Edon Simplefile Box Office Medium Box 0.57 9/7/18 Master Caster Door Stop, Large Neor Wrap Bee 042 1/4/20 Serrated Blade ar Curved Handle Hai Wrap Bag 0.84 4/4/20 Dixon Ticonderoga Core Lock Color Wrap Bag 0.41 12/27/18 Acme & Straight Scissors Sirall Pack 0.6 1/6/19 Eden Expressions Viood Desk Ac Small Box 0.56 5/16/17 Xerox 193 Small Vox 0.36 6/16/17 Decoflex Hanging Personal Folder Fi Sir all Box 0.58 5/16/17 Newell 314 Wrap Bag 0.6 5/23/19 Prismacolor Color Pencil Set Wrap Bag 0.44 5/24/19 Nu-Dell Executive Frame Sirall Pach DAB 12/28/18 GEC Standard Therm A Bind Covers Small Box 0.39 12/27/18 Boston 1645 Deluxe Hesvier-Outy Small Pack 0.58 10/26/18 Star TAC ST7762 Sir all Rex 0.57 10/26/18 Hoover Wind Tunnel Plus Canister Small Box 0.57 9/28/17 Xerox 1984 Small Box 0.36 12/28/18 Tervolexkes Cran Jumbo Drum 0.78 12/27018 Furniture Yukon Ready + 100% Assignment From the file CanadianSalesData.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 AutoSave OF AA Canadian Sales Data Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibrl (Body) v 11 v AP h Wrap Text General Insert v X [ G 7 0 v Delete v Paste BIU :- ~ Ar = = = Merge & Center v Y Conditional Format Cell Formatting as Table Styles Sort & Filter Sensitivity # Format Find & Select Analyze Data V M8079 X f British Columbia F G H K M 0.07 B Row ID Order ID 2 1 3 2 6 6 32 5 3 32 4 32 7 5 32 A 7 35 9 8 35 10 S 36 11 10 55 12 11 56 13 12 69 14 13 59 15 14 70 16 15 70 17 16 96 18 17 97 19 18 129 20 15 130 21 20 130 22 21 130 23 23 132 24 22 132 25 24 134 26 25 135 27 26 156 22 27 193 29 28 194 30 25 194 31 30 195 32 31 197 33 32 224 34 33 224 35 34 224 36 35 225 37 36 225 38 37 229 39 38 229 40 39 230 41 10 230 42 41 231 43 42 258 44 13 258 Sheet1 D C Order Date Order Priority 10/11/18 Low 2/18/20 Not Specified 7/13/19 High hi 7/13/19 High 7/13/19 High 7/13/19 High 10/20/15 Not Specified 10/20/19 Not Specified 10:31/19 Critical 3/15/15 Critic 1/17/17 Law 6/1/17 Not Specified 541/17 Net Specified 12/15/18 Law 12/15/18 Low 1/14/17 High 1/25/18 Medium 11/16/20 Low 5/5/20 High 5/5/20 High 5/5/20 High S/B/18 Medium 5/8/18 Medium 4/29/20 Not Specified 10/18/15 Not Specified 9/9/19 High 8/5/18 Critical 4/2/20 Medium 4/2/20 Medium 12./25/18 Medium 4/1/18 High 6/15/17 Not Specified 6/15/17 Not Specified 6/15/17 Not Specified 5/22/15 Critical 5/22/19 Critica 12/26/18 Critic 12/25/18 Critical 10:/24/18 Critical 10/24/18 Critic 9/25/17 High 12/26/18 Critical 12/25418 Critic + Order Quantity Sales 6 261.54 2 5.93 15 140.56 26 280RON 24 1751.4 23 160.2335 30 288.56 14 1892.848 46 2484.746 32 3812.73 41 108.15 42 1180.16 28 51.53 48 S0.05 46 7904.53 37 4158.124 26 75.57 4 32.72 3 161.89 29 575.11 23 236.46 30 1011,65 27 192.814 11 1132.6 25 125.85 10 567.936 14 174.99 49 329.03 20.15 34 1315.74 23 310.52 25 184.86 44 267.95 33 528.5 24 125.58 1 1 23.7 43 586.11 24 599.2 47 2029.75 11 1118.396 2 689.74 21 154.33 7 7 201.36 Discount Ship Mode 0.04 Regler All 0.01 Regular Alr 0.04 Regular Air 0.07 Reguler Air 0.09 Delivery Truck 0.04 Regular Air 0.03 Reguler Air 0.01 Regular Ale 0.1 Regular Air 0.02 Regler Air 0.09 Regular Air 0.09 Regular Air 0.03 seres 0.03 Express Air 0.03 Regular Air 0.05 Regular Air 0.01 Regler Air 0.03 Regular Air 0.09 Regular Air 0.05 Express Air 0.02 Regular Ale 0.05 Regular Air 0.05 Delivery Truck 0.03 Regular Lir 0.01 Regular Air 0.09 Regular Air 0.02 Express Air 0.06 Regular Air 0.1 Reguler Air 0.04 Regular Ale 0.03 Regular Air 0.01 Reguler Air 0.09 Regular Air 0.04 Regular Air 0.04 Regier Air 0.06 Regular All 0.05 Regular Air 0.11 Reguler Air 0.02 Regular Air 0.06 Regular Air 0.06 Regal Air 0.06 Regular All Regular Air O Diver Truck Profit -213 25 4.54 -128 38 1054 82 -1748.56 -95.13 6072 48.99 657.48 1470 30 7.57 511.69 035 107.00 2057 17 1228 80 28.24 -22.59 -309 82 71.75 -134.31 -503 80 86.20 -310.21 -89 25 -126 09 -37.04 -197 25 13.44 260.87 3322 33.95 -65.43 -119 92 18.27 8.97 9844 3.82 32037 -212 33 490.84 -91.14 -28440 Unit Price hipping Cos Customer Name 38.94 35 Rosemarie Orkney 2.08 2.55 Sandra Bragatti 9.46 9.99 LBoine Reaman 107.53 5.81 Marie Domelow 70.89 89.3 Cinderella Racsdale 7.99 5.03 Maribel Ilieve 9.11 2.25 Kerwin Caalen 155.99 8.99 Rosemarie Orkney 65.99 4.2 Horatia Verce . 115.79 1.99 Sergio Nudes 2.83 0.7 Miller Warthing 30.93 3.92 Beltran Heyball 1.66 0.7 Sommy Balir forth 1.85 2.58 Dorelle conden 205.99 5.99 Wanca Heathcott 125.99 B.99 Ode Mallere 2.89 Os arvin Eccot 6.49 9.19 Jenn Gainsburgh 150.98 13.99 Katee Geele 18.97 9.03 Cristina Festass 9.71 9.45 Starton Matei 130.98 51.74 leri Dilleston 7.99 5.03 Live Nesterov 95.99 35 Mari Gossop 4.98 4.62 Natalie Hanney 262 Naval 55.99 8.99 Elihu Space 12.44 6.27 Zsuzsa McCarver 7.28 7.58 Waly Andraletti 3.14 1.92 Macdy Pouden 36.35 13.99 Addaice Dak 12.98 3.14 Merrielle Scrimshire 7.38 5.21 Granville Frickey 5.98 5.15 Petr Jimeno 15.12 10.68 Barby Noades 5.55 0.7 Isabel Di Angelo 19.94 4.1 Rancell Altres 12.64 4.58 Rupert Boup 24.92 12.98 Darb Binton 43.99 9.99 Morton Castells 125.99 B.08 Gideon Burke 353.25 19.99 Henry Rosenblatt 6.49 9.74 Gasparo Mall 20.9 53.08 Nanterne Province Nunavut Alberta Saskatchewan Alberta Alberta Alberta Darius British Columbia British Columbia Alberta Ontario Alberta Saskatchewan Saskatchewa Quebec Quebec Manitoba Yukon Ontario Saskatchewan Saskatchewan Saskatchewan Nova Scotia Quebec Ontario Quebe Manitobs Quebec Alberta Alberta Yukon Manitoba Yukon Yukon Yukon Quebec Quebec Nova Scotia Saskatchewan Ontario Ontario Manitoba Nova Scotia Naya Sentia N 0 Replon Customer segment Product Category Product Sub-Category Nungut Small Business Office Supplies Stare & Organization West Corporate Orice Supplies Scissors, Rulers and Trimmers Prairie corporal Technology Computer Peripherals We Corporate Furniture Office Furnishing West Corporate Furniture Tables West Corporate Techrology Telephones and Communication We Corporate Office Supplies Pers & Art Supplies West Corporate Technology Telephones and Communication West Home Office Technology Telephones and Communication Onteric Corporate Technology Computer Peripherals West Consumer Orice Supplies Pons Art Supplies Prairie Corporate Furniture Office Furnishing mam Prairie Corporate Office Supplies Pers & Art Supplies Quebec Home Olice Orice Supplies Rubber Bands Quebec Home Office Technology Telephones and Communication Prairie Homece Technology Telephones and Communication Muker Consumer Orice Supplies Labas Ontario Corporate Ofice Supplies Paper Prairie Corporate Technology Office Machines Prairie Corporate Office Supplies Paper Prairie Corporate Office Supplies Storage & Organisation Allers Consumer Furniture Bookcase Quebec Consumer Technology Telephanes and Communication Ontario Home Office Office Supplies Storage & Organisation Qurbe Consumer Technology Computer Peripherals Prairie Consumer Tochralogy Telephanes and Communication Quebec Consumer Office Supplies Storage & Organisation Corporate Furniture Office Furnishing West Corporate Orice Supplies Scissors, Rulers and Trimmers Yukor Home Office Oflice Supplies Pens & Art Supplies Prairis Home Office Office Supplies Scissors, Rulers and Trimmers Yukon Corporate Furniture Orice Furnishing Yukar Corporate Office Supplies Paper Vukor Corporate Office Supplies Store & Organization Quebec Home Office Orice Supplies Pons Art Supplies Quebec Home Office Office Supplies Pers & Art Supplies Atlantic Consumer Furniture Office Furnishing Prairie Consumer Omice Supplies Binders and Binder Accessories Ontario Corporate Ofice Supplies Pens & Art Supplies Ontario Corporate Technology Telephones and Communication Prairie Small Business Orice Supplies Appliances Atlantic Home Office Office Supplies Paper Allsti Home Office offunnies Stars & Oupanization Ready + 100% AutoSave OF A A Ao Canadian Sales Data Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments Calibrl (Body) v 11 v AP 2 Wrap Text General Insert v X G 0 0 v Delete v Paste BIU :- Av = = = Merge & Center v Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Analyze Data Sensitivity V M8079 X f British Columbia V w X Y Z Prairie 1 hipping Cos Customer Name 2 35 Rosemarie Orkney 3 2.56 Sandra Braguetti 4 9.99 Lone Reaman 5 5.81 Maurie Domelow 39.3 Cinderella Rascale 7 5.03 Maribel ilire 8 2.25 Kerwin Conten 8.99 Rosorarie Orkney 10 4.2 Horatia Voyce 11 1.99 Sergio Nudds 12 0.7 Milicen Warthing 13 3.92 Beltran Heyball 14 0.7 Sammy Balm forth 15 2.58 Dorelle cancion 16 5.99 Wanda Heathcott 17 8.99 Ode Mallard 12 0.5 Ervin Eccott 19 9.19 Jenn Gainsburst 20. 20 13.99 Kale Giecie 21 9.03 Olsira Ferlass 22 9.45 Stanion Meth 23 54.74 Jeri Dilleston 24 5.03 Llwie Nesterav 25 35 Mari Gossop 26 4,62 Natalie Hanney 27 8.99 Elihu Space 28 6.27 Zsazsa McCarver 29 7.98 Waly Ardraletti 30 1.92 Maddy Pouiden 31 13.99 Addaide Dax 32 3.14 Merrielle Scrimshire 33 5.21 Granville Frickey 34 5.13 Petr Jirreno 35 10.68 Barby Neades 36 0.7 Iscabal Di Angelo 37 4.1 Rancel Altres 38 4.98 Ruper accup 39 12.98 Darbintan 40 9.99 Morton Castells 41 8.08 Gideon Barke 42 19.99 Henry Rosenblatt 43 9.74 Gasparo Vall 44 53.03 Dante Reme Sheet1 + M Province Nunavut Alberta Saskatchewan Alberts Alberta Alberta Baile British Columbia British Columbia Alberta Ontario Alberta Saskatchewan Saskatchewan Quebec Quebec Manitoba Yukon Ontario Saskatchewa Saskatchewan Saskatchewan Nova Scotia Quebec Ontario Quebe Manitoba Quebec Alberts Alberta Yukon Manitoba Yukon Yukon Yukon Quebec Quebec Nova Scotia Saskatchewan Ontario Ontario Manitob Nova Scotia Nova Scotia N Q Region Customer Segment Product Category Product Sub-Category Nunnut Small Business Office Supplies Store & Organization West Corporate Orice Supplies Scissors, Rulers and Trimmers Prairie Corporate Technology Computer Peripherals West Corporate Furniture Office Furnishings West Corporate Furniture Tables West Corporate Technology Telephones and Communication Corporate Office Supplies Pers & At Supplies West Corparate Technology Telephones and Communication West Home Office Technology Telephones and Communication Ontario Corporate Technology Computer Peripherals West Consumer Orice Supplis Pons Art Supplies Prairie Corporate Furniture Office Furnishing Prairie Corporate Office Supplies Pens & Art Supplies Quebec Home Dice Orice Supplies Rubber Bands Quebec Home Office Technology Telephones and Communication Prairie Home Office Technology Telephones and Communication Yukon Consumer Orice Supplies Labels Ontario Corporate Office Supplies Paper sesupp Corporate Techrolo Orice Machines Prairie Corparate Orice Supplies Paper Prairie Corporate Ofice Supplies Storage & Organization Atlantic Consumer Bookcases Quebec Consumer Technology Telephones and Communication Ontario Home Office Office Supplies Storage & Organisation Que Consumer Technology Computer Peripherals Prairie Consumer Technology Telephones and Cammunication Quebec Consulter Ofice Supplies Storage & Organization Corporate Furniture Office Furnishings West Corporate Orice Supplies Scissors, Rulers and Trimmers Yukon Home Office Ofice Supplies Pens & Art Supplies & Prairie Home Office Office Supplies Scissors, Rulers and Trimmers Yukan Corporate Furniture Orice Furnishings Corporate Office Supplies Paper Yukar Corporate Office Supplies Storage & Organization Queber Home Office Orice Supplies PensArt Supplies Quebec Home Office Office Supplies Pens & Art Supplies Atlantis Consumer Furniture Office Furnishings Prairie Consumer Orice Supplies Sinders and Binder Accessories Ontario Corporate Ofice Supplies Pens & Art Supplies Ontario Corporate Technology Telephones and Communication Prairie Small Businex Orice Supplies Appliances Atlantic Home Office Ofice Supplis Paper Allantic Homelice of Sun Store & Danilson R U Product Name Product Container oduct Base Mary ship Date Eldor Base for stable storage shel Large Box 0.8 10/18/18 Kleancut' Farged Office Shears by Small Pack 0.55 2/19/20 Imation 3.5 IBM Disketes 10/Box Small Pack 0.79 7/14/19 Tenes Contemporary Contur Chair Medium Box 0.55 7/15/19 Kl Conference Tables Jumbo Box 0.72 7/14/19 Bell Sorecor JB700 Caller ID Medium Box 0.6 7/15/19 Dixon Ticanderos Core-lock Color Wrap Bee 0.52 10/21/19 CF685 Small Box 0.58 10/22/19 61621 Small Box 0.55 10/31/19 020 Verbatim DVD-R, 1.7GB, Spindle W Srall Pack 049 3/16/19 Newell 340 Wrap Bag 0.56 1/17/17 Advantus Employee of the Month Ce Small Pack 0.44 6/17 1220 Newell 308 Wrap Be 0.6 6/3/17 Super Bands, 12/rack Wrap Bag 0.82 12/20/18 3285 Small Vox 0.59 12/20/18 SC78681 Sir all Box 0.55 4/16/17 Avery 498 Small Box 0.38 1/27/18 Xerox 217 Small Vox 0.37 11/25/20 Canon MP4 10H Printing Calculator Medium Bor 0.38 577/20 Computer Printout Paper with Let Small Box 0.37 5/6,20 Filing, storage Tots and Swivel Cast Small Box 0.6 5/4/20 O'Sullivan Elevations Bookcase, Che lumbo Box oo 0.59 5/11/18 Bell Sorocar Jezon Caller ID Medium Box 0.6 6/9/18 Safco industrial Wire Shelving Large Box 4/30/20 Irratier 3.5", DISKETTE 44765 HGHUSrall Pack 0.54 10/20/19 1270 Small Box 0.55 9/11/19 Edon Simplefile Box Office Medium Box 0.57 9/7/18 Master Caster Door Stop, Large Neor Wrap Bee 042 1/4/20 Serrated Blade ar Curved Handle Hai Wrap Bag 0.84 4/4/20 Dixon Ticonderoga Core Lock Color Wrap Bag 0.41 12/27/18 Acme & Straight Scissors Sirall Pack 0.6 1/6/19 Eden Expressions Viood Desk Ac Small Box 0.56 5/16/17 Xerox 193 Small Vox 0.36 6/16/17 Decoflex Hanging Personal Folder Fi Sir all Box 0.58 5/16/17 Newell 314 Wrap Bag 0.6 5/23/19 Prismacolor Color Pencil Set Wrap Bag 0.44 5/24/19 Nu-Dell Executive Frame Sirall Pach DAB 12/28/18 GEC Standard Therm A Bind Covers Small Box 0.39 12/27/18 Boston 1645 Deluxe Hesvier-Outy Small Pack 0.58 10/26/18 Star TAC ST7762 Sir all Rex 0.57 10/26/18 Hoover Wind Tunnel Plus Canister Small Box 0.57 9/28/17 Xerox 1984 Small Box 0.36 12/28/18 Tervolexkes Cran Jumbo Drum 0.78 12/27018 Furniture Yukon Ready + 100%
