?

6. Format the data from A1:K179 on CustSales worksheet as a Table. Name this table Orders. Apply a table style of your choice, not default. 7. Format table columns for Unit Price through Net Cost with comma style, and remove all decimal places from Quantity (column G) data since there are only whole items ordered. 8. Complete a multi-level sort of the table. First sort level is by Category (A to Z), then by Sales Rep (A to Z), then by Net Cost (largest to smallest). This is one sort. SAVE! Page 2 of 4 9. Create a pivot table on a new worksheet that shows the three shippers as row headings and the count of orders they have shipped. Rename Row Label "Shippers" and rename the column with number of shipments "Count of Shipments". Apply a style of your choice, not default, to the pivot table from the Pivot Table Styles gallery. Rename the worksheet as Shippers.. SAVE! 10. Create another pivot table on a new worksheet. Use your own judgement to select and present data that would be meaningful and useful for your company. Format and rename worksheet. 11. On the Documentation sheet, in B7, describe why you created the pivot table you developed in step 10 and what information it presents. 12. Go back to your Orders table and add a Total row, in row 180, using the SUBTOTAL function to calculate the Average Net Cost. Change the default label appropriately, don't leave it as Total. Order Date Sales Rep Shipper 1/3/2019 Buchanan United Package 3/6/2019 Buchanan Speedy Express 3/5/2019 Buchanan Speedy Express 10/3/2019 Duchasan Speedy Express 7/21/2019 Buchanan Speedy Express 4/2/2019 Buchanan Federal Shipping 3/22/2019 Buchanan Federal Shipping 2/25/2019 Buchanan Speedy Express 9/28/2019 Buchanan United Package 3/5/2019 Buchanan Speedy Express 11/21/2019 Buchanan Federal Shipping 10/3/2019 Buchanan Speedy Express 7/21/2019 Buchanan Speedy Express 2/8/2019 Buchanan United Package 3/6/2019 Buchanas Speedy Express 9/28/2019 Buchanan United Package 2/8/2019 Buchanan United Package 2/25/2019 Buchanan Speedy Express 20 9/29/2019 Buchanan Federal Shipping Federal Shipping United Packag 17 18 19 21 federal Shipping Speedy Express Spendy Express United Package United Package United Package 4 5 6 7 B 9 10 11 12 13 14 16 16 23 265 26 27 28 4/2/2019 Buchanen 10/20/2019 Buchanan 9/29/2019 Buchanan 10/1/2019 Buchanan /27/2019 Buchanan 10/20/2019 Buchanan 4/26/2019 Davis 6/1/2019 Da CustSales Product Name Cte de Baye Chai Chang Chartreuse verte Lakkalk Category Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Beverages Condiments Condiments Condiments Condiments Original Frankfurter grne Sole Grains/Cereah Tunnbrd Grains/Cereals Custaf's Knckebrd Guaran Fantstica Chartreuse verte Chang Garand Fantstica Guaran Fontnk Gula Malacca Chef Anton's Cajun Seasoning Vege spread Grains/Cereals Favo Angelo Grains/Cereals Ravioli Angelo Mest/Poultry Perth Pasties Nice Mumon Meat/Poultry Meat/Poury Perth Pasties Meat/Poultry Tourtire Meat/Poultry Produce Produce Beverages Beverages Tourtire Manjup Dried Apples Tofu Cte de Maye Ipoh Coffee Unit Price Quantity 210.8 18 19 18 18 4.5 18 19 4.5 4.5 19.45 22 43.9 13 19 21 19.5 195 32.8 39 328 7.45 7.45 51 23.25 263.5 46 40 40 21 20 10 35 SubTotal a 5 15 6 50 12 6 15 50 15 15 10 25 15 10 30 6 48 30 60 00 Freight Discount Net Cost Discount% Freight Feet Highest 0.0% Highest $ Lowest 0.0% Lowest $ Q 1 Order Date Sales Rep 2 1/3/2019 Buchanan Nm. Shipper United Package 3/6/2019 Buchanan Speedy Express 3/5/2019 Buchanan Speedy Express 4 5 10/3/2019 Buchanan Speedy Express 6 3 A1 7 8 9 10 16 17 18 19 20 888588388588959445 30 Beverages 11 13 14 15 Beverages 7/21/2019 Buchanan Speedy Express 4/2/2019 Buchanan Federal Shipping Beverages 3/22/2019 Buchanan Federal Shipping Beverages 2/25/2019 Buchanan Speedy Express Beverages 9/28/2019 Buchanan United Package 3/5/2019 Buchanan Speedy Express 12 11/29/2019 Buchanan Federal Shipping 10/3/2019 Buchanan Speedy Express 7/21/2019 Buchanan Speedy Express 2/8/2019 Buchanan United Package 3/6/2019 Buchanan Speedy Express 9/28/2019 Buchanan United Package 2/8/2019 Buchanan United Package 2/25/2019 Buchanan Speedy Express 9/29/2019 Buchanan Federal Shipping 4/2/2019 Buchanan Federal Shipping 22 10/20/2019 Buchanan United Package 23 9/29/2019 Buchanan Federal Shipping 24 10/3/2019 Buchanan Speedy Express 25 6/27/2019 Buchanan Speedy Express 26 10/20/2019 Buchanan United Package 27 4/26/2019 Davis 21 28 6/1/2019 Davis 29 5/1/2019 Davis 5/14/2019 Davis 5/1/2019 Davis 32 12/23/2019 Davis 9/20/2019 Davis 9/13/2019 Davis 11/1/2019 Davis 36 1/31/2019 Davis 37 5/21/2019 Davis 8/2/2019 Davis 1/21/2019 Davis 3/24/2019 Davis 5/1/2019 Davis 1/8/2019 Davis 2/4/2019 Davis 2/28/2019 Davis 5/17/2019 Davis 1/17/2019 Davis 3/22/2019 Davis 31 33 40 41 42 B 46 47 C fix CustSales D Category Beverages Beverages Beverages Beverages Beverages Condiments Condiments United Package United Package Speedy Express United Package Speedy Express United Package Beverages United Package Beverages Beverages United Package Beverages United Package Beverages Federal Shipping Beverages United Package Beverages Speedy Express Beverages United Package Beverages United Package Speedy Express Beverages Beverages Federal Shipping Beverages Speedy Express United Package United Package Beverages Beverages Beverages Federal Shipping Beverages United Package Beverages Product Name Cte de Blaye Chai Chang E Chartreuse verte Lakkalikri Guaran Fantstica Chartreuse verte Chang Guaran Fantstica Guaran Fantstica Gula Malacca Chef Anton's Cajun Seasoning egie-spread Condiments Condiments Original Frankfurter grne So Grains/Cereals Tunnbrd Grains/Cereals Gustaf's Knckebrd Grains/Cereals Ravioli Angelo Grains/Cereals Ravioli Angelo Meat/Poultry Perth Pasties Meat/Poultry Alice Mutton Meat/Poultry Perth Pasties Meat/Poultry Tourtire Meat/Poultry Tourtire Produce Produce Beverages Beverages Beverages Beverages Manjimup Dried Apples Tofu Cte de Blaye Ipoh Coffee Lakkalikri Ipoh Coffee Chang Chartreuse verte Chai Lakkalikri Chai Steeleye Stout Steeleye Stout Steeleye Stout Rhnbru Klosterbier Outback Lager Outback Lager Chartreuse verte Chang Guaran Fantstica Chartreuse verte Rhnbru Klosterbier Outback Lager Unit Prici Quantity 210.8 15 15 15 18 5 18 18 19 18 4.5 19 4.5 4.5 19.45 22 43.9 13 9 555556 21 19.5 19.5 32.8 39 32.8 7.45 7.45 53 23.25 263.5 46 18 46 19 14.4 14.4 18 18 14.4 18 18 7.75 12 15 14.4 19 4.5 G 18 7.75 15 8888888888888.855588 21 20 SubTotal 35 12 15 50 15 25 30 48 30 60 30 50 54 45 35 35 24 20 25 20 20 H 40 10 10 Freight 50 51 52 53 46 1/17/2019 Davis 47 3/22/2019 Davis 48 11/17/2019 Davis 49 3/15/2019 Davis 2/5/2019 Davis 4/15/2019 Davis 11/2/2019 Davis 8/2/2019 Davis 54 55 56 57 58 59 60 61 62 63 64 A1 65 66 67 68 69 70 71 72 K 38888588 90 File 93 LO Home 11/9/2019 Davis 2/14/2019 Davis 73 74 6/1/2019 Davis 75 11/24/2019 Davis 76 10/16/2019 Davis 77 1/25/2019 Davis 78 11/17/2019 Davis. 79 4/26/2019 Davis 7/5/2019 Davis 4/24/2019 Davis 80 81 82 5/21/2019 Davis 83 84 85 12/8/2019 Davis 1/8/2019 Davis 1/25/2019 Davis 86 6/4/2019 Davis 87 12/8/2019 Davis 11/9/2019 Davis 89 4/26/2019 Davis 5/14/2019 Davis 191 4/15/2019 Davis 92 10/18/2019 Denton 15/2019 Denton 2/28/2019 Davis 11/2/2019 Davis 5/21/2019 Davis 10/16/2019 Davis) 1/26/2019 Davis 7/5/2019 Davis 12/8/2019 Davis 1/31/2019 Davis 3/31/2019 Davis 2/14/2019 Davis 9/20/2019 Davis 3/25/2019 Davis 2/8/2019 Davis 7/5/2019 Davis 9/11/2019 Davis 9/13/2019 Davis 2/28/2019 Davis 6/20/2019 Davis seossa... Insert Page Layout fx Speedy Express United Package United Package Formulas D Speedy Express Federal Shipping Beverages Rhnbru Klosterbier Outback Lager United Package Beverages Northwoods Cranberry Sauce Federal Shipping Condiments Condiments Original Frankfurter grne Soll Speedy Express Aniseed Syrup Condiments Speedy Express Speedy Express Condiments Grandma's Boysenberry Spread Condiments Original Frankfurter grne Soe Condiments Speedy Express Original Frankfurter grne Soe Grandma's Boysenberry Spread Federal Shipping Condiments Original Frankfurter grne Soe Federal Shipping Condiments - United Package Grains/Cereals Wimmers gute Semmelkndel Speedy Express Grains/Cereals Gnocchi di nonna Alice, United Package United Package Federal Shipping Grains/Cereals Ravioli Angelo United Package Grains/Cereals Filo Mix Data CustSales Federal Shipping Grains/Cereals Filo Mix Federal Shipping Meat/Poultry Thringer Rostbratwurst Federal Shipping Meat/Poultry Pt chinois Federal Shipping Meat/Poultry Thringer Rostbratwurst United Package Meat/Poultry Speedy Express Meat/Poultry E Review Grains/Cereals Wimmers gute Semmelkndel Grains/Cereals Tunnbrod Perth Pasties Pt chinois Meat/Poultry Perth Pasties Meat/Poultry Perth Pasties Meat/Poultry Perth Pasties United Package Meat/Poultry Pt chinois United Package Meat/Poultry Tourtire Federal Shipping Meat/Poultry Tourtire United Package Meat/Poultry Tourtire United Package Meat/Poultry Tourtire United Package Meat/Poultry Pt chinois Federal Shipping Meat/Poultry Tourtire Manjimup Dried Apples Federal Shipping Produce United Package Produce Manjimup Dried Apples United Package Produce Manjimup Dried Apples Rssle Sauerkraut Produce Produce Speedy Express United Package Federal Shipping Produce Federal Shipping Produce Federal Shipping Produce Speedy Express Produce Federal Shipping Produce Federal Shipping Produce United Package Produce United Package Produce Produce Beverages Federal Shipping Beverages Speedy Express United Package Cte de Blaye Lakkalikoori View Rssle Sauerkraut Rssle Sauerkraut Rssle Sauerkraut Manjimup Dried Apples Uncle Bob's Organic Dried Pear Tofu Tofu Longlife Tofu Uncle Bob's Organic Dried Pear Rossle Sauerkraut F 7.75 15 40 13 8 25 13 13 20 13 33.25 38 19.5 33.25 7.2 7782 99 19.2 123 79 26.2 24 32.8 32.8 32.8 24 7.45 7.45 7.45 7.45 24 7.45 53 42.4 53 45.6 45.6 45.6 36.4 53 30 5096500 23.25 18.6 8 30 45.6 Help 263.5 18 6 10 3 99222222298258 222999222222299 RE 40 40 50 16 30 20 6 30 20 15 40 21 60 8 36 30 20 18 12 12 35 24 15 Acrobat 15 4 7 28 25 20 20 20 20 20 10 15 16 H 9 16 4 2 15 21 A1 96 97 98 B 93 2/15/2019 Denton 94 3/26/2019 Denton 95 5/16/2019 Denton 2/12/2019 Denton 7/4/2019 Denton 1/17/2019 Denton 6/15/2019 Denton 1/25/2019 Denton 1/17/2019 Denton 102 3/20/2019 Denton 103 3/20/2019 Denton 104 2/12/2019 Denton 105 2/22/2019 Denton 106 12/19/2019 Denton 107 5/29/2019 Denton 7/4/2019 Denton 3/20/2019 Denton 5/10/2019 Denton 108 99 100 101 109 110 111 File 128 129 130 131 132 133 Home Insert Page Layout fx 112 113 114 5/27/2019 Kaplan 117 115 12/5/2019 Kaplan 116 4/18/2019 Kaplan 11/6/2019 Kaplan 118 4/17/2019 Kaplan 119 9/14/2019 Kaplan 120 4/25/2019 Kaplan 121 9/7/2019 Kaplan 122 2/20/2019 Kaplan 123 11/28/2019 Kaplan 124 1/18/2019 Kaplan 125 5/23/2019 Kaplan 126 4/12/2019 Kaplan 127 4/30/2019 Kaplan 9/22/2019 Kaplan 3/7/2019 Kaplan 4/17/2019 Kaplan 2/8/2019 Kaplan 4/16/2019 Kaplan 8/29/2019 Kaplan 11/1/2019 Kaplan 5/8/2019 Kaplan 3/31/2019 Kaplan 134 135 6/3/2019 Kaplan 9/21/2019 Kaplan 4/18/2019 Kaplan 136 137 9/7/2019 Kaplan 138 1/18/2019 Kaplan 139 6/12/2019 Kaplan 140 4/25/2019 Kaplan LAS Channin C D Federal Shipping Beverages United Package United Package Beverages Beverages Speedy Express United Package Federal Shipping Beverages Beverages Beverages CustSales Formulas Federal Shipping Beverages Federal Shipping Beverages Federal Shipping Beverages. United Package Beverages United Package Condiments - Speedy Express United Package Speedy Express Federal Shipping United Package United Package Federal Shipping United Package Beverages Federal Shipping Beverages Speedy Express United Package Beverages Beverages Beverages Federal Shipping Beverages United Package Beverages Federal Shipping Beverages Federal Shipping Beverages Speedy Express Beverages Federal Shipping Beverages United Package Beverages Speedy Express Beverages United Package Speedy Express Beverages United Package Beverages Speedy Express Beverages Speedy Express Beverages Federal Shipping Beverages United Package Beverages Federal Shipping Beverages Speedy Express Beverages United Package Beverages Federal Shipping Beverages United Package Beverages United Package Beverages Speedy Express Beverages United Package Beverages Speedy Express Condiments Speedy Express Condiments Federal Shipping Condiments 17414 Data Lakkalikri Chai Outback Lager Chang Rhnbru Klosterbier. Sasquatch Ale Outback Lager Guaran Fantstica Guaran Fantstica Guaran Fantstica Northwoods Cranberry Sauce Northwoods Cranberry Sauce Review Condiments Condiments Condiments Condiments Aniseed Syrup Gula Malacca Sirop d'rable Grains/Cereals Wimmers gute Semmelkndel Meat/Poultry Thringer Rostbratwurst Meat/Poultry Tourtire Ipoh Coffee Steeleye Stout Lakkalikri Lakkalikri Chai Lakkalikri Outback Lager Steeleye Stout Chang Chartreuse verte Steeleye Stout Steeleye Stout Steeleve Stout Rhnbru Klosterbier Steeleye Stout Guaran Fantstica Ipoh Coffee Sasquatch Ale Chang Outback Lager Outback Lager Rhnbru Klosterbier Chartreuse verte Lakkalikri Guaran Fantstica Rhnbru Klosterbier Guaran Fantstica Northwoods Cranberry Sauce Chef Anton's Cajun Seasoning Vegie-spread Call. View Help Acrobat F | 18 18 15 19 5 155 35 5 7.75 11.2 4.5 3.6 45 40 40 10 19.45 28.5 33.25 123.79 7.45 46 14.4 18 18 18 18 15 18 19 18 18 18 18 7.75 18 3.6 46 11.2 15.2 12 15 7.75 18. 14.4 4.5 6.2 4.5 40 22 43.9 G 21 20 14 10 20 10 7 20 15 10 30 20 49 16 4 30 24 20 36 100 60 50 50 44 50 40 30 30 30 25 21 42 18 80 6 20 10 12 9 12 5 6 14 4 3 30 50 20 A1 A B 137 138 9/7/2019 Kaplan 1/18/2019 Kaplan 139 6/12/2019 Kaplan) 140 4/25/2019 Kaplan 6/3/2019 Kaplan 9/27/2019 Kaplan 141 142 143 148 2/27/2019 Kaplan 144 9/12/2019 Kaplan 145 9/12/2019 Kaplan 146 2/20/2019 Kaplan 147 9/27/2019 Kaplan 2/20/2019 Kaplan 2/20/2019 Kaplan 6/21/2019 Kaplan 151 1/15/2019 Kaplan 152 10/10/2019 Kaplan 153 2/20/2019 Kaplan 154 5/8/2019 Kaplan 10/2/2019 Kaplan 149 150 155 156 157 158 File 180 181 182 183 Home 2/1/2019 Kaplan 5/3/2019 Kaplan 159 160 3/1/2019 Kaplan 161 4/18/2019 Kaplan 162 9/27/2019 Kaplan 163 2/27/2019 Kaplan 164 8/30/2019 Kaplan 165 5/28/2019 Kaplan 166 4/18/2019 Kaplan 167 9/13/2019 Kaplan 168 2/20/2019 Kaplan 169 5/31/2019 Kaplan 170 6/12/2019 Kaplan 171 4/17/2019 Kaplan 172 11/6/2019 Kaplan 173 4/30/2019 Kaplan 174 4/18/2019 Kaplan 175 5/28/2019 Kaplan 176 4/12/2019 Kaplan. 177 4/25/2019 Kaplan 178 9/7/2019 Kaplan 179 6/3/2019 Kaplan 184 LOC 4/17/2019 Kaplan 3/7/2019 Kaplan Insert Page Layout PA United Package Speedy Express Speedy Express Speedy Express Speedy Express United Package Federal Shipping United Package Speedy Express United Package United Package Federal Shipping United Package Speedy Express United Package United Package Speedy Express Formulas United Package Speedy Express Condiments Speedy Express Federal Shipping Condiments United Package Condiments Speedy Express Condiments United Package Condiments United Package Condiments Condiments CustSales Beverages Condiments Condiments Condiments Data Review View Guaran Fantstical Northwoods Cranberry Sauce Chef Anton's Cajun Seasoning Vegie-spread Original Frankfurter grne So Chef Anton's Gumbo Mix Aniseed Syrup Vegie-spread Gula Malacca iginal Frankfurter grne Soe Original Frankfurter grne Soe Grains/Cereals Wimmers gute Semmelkndel Grains/Cereals Tunnbrd Grains/Cereals Tunnbrd Grains/Cereals Gnocchi di nonna Alice Grains/Cereals Gnocchi di nonna Alice Grains/Cereals Singaporean Hokkien Fried Mec Grains/Cereals Singaporean Hokkien Fried Mee Grains/Cereals Gustaf's Knckebrd Grains/Cereals Wimmers gute Semmelkndel Grains/Cereals Gustaf's Knckebrd Grains/Cereals Tunnbrd Grains/Cereals Filo Mix Grains/Cereals Filo Mix Grains/Cereals Filo Mix Speedy Express Meat/Poultry Thringer Rostbratwurst United Package Meat/Poultry Thringer Rostbratwurst Federal Shipping Meat/Poultry Thringer Rostbratwurst United Package Meat/Poultry Pt chinois United Package Meat/Poultry Perth Pasties United Package Meat/Poultry Alice Mutton Speedy Express Meat/Poultry Perth Pasties Speedy Express Meat/Poultry Tourtire United Package Meat/Poultry Tourtire Federal Shipping Meat/Poultry Pat chinois Federal Shipping Produce Speedy Express United Package United Package Speedy Express Produce Produce Produce Produce Federal Shipping Produce Produce Produce United Package United Package Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Uncle Bob's Organic Dried Pear Manjimup Dried Apples Manjimup Dried Apples Tofu Rssle Sauerkraut F 4.5 40 22 43.9 13 17 10 35.1 15.5 10.4 10.4 33.25 9 9 30.4 30.4 14 14 21 33.25 16.8 9 7 7 7 99 123.79 99 24 32.8 31.2 26.2 7.45 7.45 19.2 30 30 30 30 42.4 53 23.25 45.6 Help G 3 30 50 20 28 20 30 8 16 10 10 48 70 70 20 20 42 30 20 8 12 18. 20 8 6 15 10 10 35 20 15 15 20 10 Acrobat 2 90 60 45 40 18 10 21 H