need keystrokes and which menu options to click

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. betal Free Discount O 0.00 1 Order Date Sales RepShipper Product Nam 1/1/2019 Buchsan United Pack B everages Code 3/6/2019 Buch Speedy Exp Beverages 3/5/2017 Buchanan Soedypress Beverages 10/2019 Ducha Speedy Beverages Chartreure 8 7/21/2019 Buchanan Speedy Express Lokala 2019 Bachar Gura Fantastica W22/2019 Buchanan Federal Shingever Chartreuse verte 2/7/2019 Ducha Speedy Express 9/23/2019 Buchanan United Pack Beverages Gara Fantastica 3/52019 ruchanan Speedy Express devem so ka 11/7/2019 Buchanan Federal Shipping Conds Mala 19 d es condimts Canin W21/2010 channedy Come Wie spread 2/2019 Surat Conti n ue W/2019 buchandr a Tunod 2/2019 Butanas Para Car s 2/8/2019 Buchanan Parkeri n g 2/25/2019 Buchanan Speedy Care Ravio l a 9/29/2010 Bucha federal shipping Mow y Purth Parties 2/2019 Burhan federal hoping Matery Nice Munron 10/22 United Pacha M eu Perth Pas 201019 Buchanan Federa s Mest Poltry Tour 10/11/2017 thaman Speedyrore Meat/Poultry Tourer 6/27/2019 Buchanan Senty Express Produce Mar r ied Apples 10/20/2019 Buchanan wted Package Product 4/26/2019 Davis United Pack Beverages Ce de 6/1/2018 Tid Package Bus CustSales al - A1 SubTotal Freight 88 19.45 8 AN 1 Order Date Sales Rep Shipper Category Product Name Unit Price Quantity 2 1/3/2019 Buchanan United Package Beverages Cte de Blaye 210.8 3 3/6/2019 Buchanan Speedy Express Beverages Chai 4 3 /5/2019 Buchanan Speedy Express Beverages Chang 5 10/3/2019 Buchanan Speedy Express Beverages 6 7/21/2019 Buchanan Speedy Express Beverages Lakkalikri 2 4 /2/2019 Buchanan Federal Shipping Beverages Guaran Fantstica 8 3/22/2019 Buchanan Federal Shipping Beverages Chartreuse verte 9 2/25/2019 Buchanan Speedy Express Beverages Chang 19 10 9/28/2019 Buchanan United Package Beverages Guaran Fantstica 113 /5/2019 Buchanan Speedy Express Beverages Guaran Fantstica 12 11/29/2019 Buchanan Federal Shipping Condiments Gula Malacca 13 10/3/2019 Buchanan Speedy Express Condiments Chef Anton's Cajun Seasoning 22 14 7/21/2019 Buchanan Speedy Express Condiments Vegie-spread 439 15 2 /8/2019 Buchanan United Package Condiments Original Frankfurter grne Soe 13 16 3/6/2019 Buchanan Speedy Express Grains/Cereals Tunnbrd 9 179/28/2019 Buchanan United Package Grains/Cereals Gustaf's Knckebrd 21 182 /8/2019 Buchanan United Package Grains/Cereals Ravioli Angelo 19.5 19 2/25/2019 Buchanan Speedy Express Grains/Cereals Ravioli Angelo 20 9/29/2019 Buchanan Federal Shipping Meat/Poultry Perth Pasties 214 /2/2019 Buchanan Federal Shipping Meat/Poultry Alice Mutton 22 10/20/2019 Buchanan United Package Meat/Poultry Perth Pasties 23 9/29/2019 Buchanan Federal Shipping Meat/Poultry Tourtire 24 10/3/2019 Buchanan Speedy Express Meat/Poultry Tourtiere 25 6/27/2019 Buchanan Speedy Express Produce M anjimup Dried Apples 26 10/20/2019 Buchanan United Package Produce T ofu 27 4/26/2019 Davis United Package Beverages Cte de Blaye 28 6/1/2019 Davis United Package Beverages Ipoh Coffee 295/1/2019 Davis Speedy Express Beverages Lakkalikri 30 5/14/2019 Davis United Package Beverages Ipoh Coffee 31 5/1/2019 Davis Speedy Express Beverages Chang 32 12/23/2019 Davis United Package Beverages Chartreuse verte 33 9/20/2019 Davis United Package Beverages chal 34 9/13/2019 Davis United Package Beverages Lakkalikri 35 11/1/2019 Davis United Package Beverages 36 1/31/2019 Davis Federal Shipping Beverages Steeleye Stout 37 5/21/2019 Davis United Package Beverages Steeleye Stout 38 8/2/2019 Davis Speedy Express Beverages Steeleye Stout 39 1/21/2019 Davis United Package Beverages Rhnbru Klosterbier 40 3/24/2019 Davis United Package Beverages Outback Lager 415/1/2019 Davis Speedy Express Beverages Outback Lager 1/8/2019 Davis Federal Shipping Beverages Chartreuse verte 432/4/2019 Davis Speedy Express Beverages Chang H 44 2/28/2019 Davis i United Package ted Package Raverapes Beverages Guaran Fantstica 45 5/17/2019 Davis United Package Beverages Beverages Chartreuse verte 46 1/17/2019 Davis Federal Shipping Beverages Rhonbru Klosterbier 473/22/2019 Davis United Package Beverages Outback Lager CustSales 8 8 8 8 8 8 8 BUCH 8 Chai 8 BUBB 8 8 8 S 7.75 15 Formulas Data Review View Help File Home Insert Page Layout Acrobat A1 8 5 16 192 262 D 45 1/17/2019 Davis Federal Shipping Beverages Rhnbrau Klosterbier 47 3/22/2019 Davis United Package Beverages Outback Lager 48 11/17/2019 Davis Federal Shipping Condiments Northwoods Cranberry Sauce 49 3/18/2019 Davis Speedy Express Condiments Original Frankfurter grne Sole 50 2/5/2019 Davis Speedy Express Condiments Aniseed Syrup 51 4/15/2019 Davis Speedy Express Condiments Grandma's Baysenberry Spread 2 11/2/2019 Davis Speedy Express Condiments Original Frankfurter grne Soe 53 8/2/2019 Davis Speedy Express Condiments Original Frankfurter prune Soe 54 11/9/2019 Davis Federal Shipping Condiments Grandma's Boysenberry Spread 20 55 2/14/2019 Davis Federal Shipping Condiments Original Frankfurter grne Soe 13 56 2/28/2019 Davis United Package Grains/Cereals Wimmers gute Semmelrodel 33.25 57 11/2/2019 Davis Speedy Express Grains/Cereals Gnocchi di nonna Alice 58 5/21/2019 Davis United Package Grains/Cereals Ravioli Angelo 19.5 59 10/16/2019 Davis United Package Grains/Cereals Wimmers gute Semmelkndel 33.25 50 1/26/2019 Davis Federal Shipping Grains/Cereals Tunnbrod 61 7/5/2019 Davis United Package Grains/Cereals Filo Mix 52 12/8/2019 Davis Federal Shipping Grains/Cereals Filo Mix 63 1/31/2019 Davis Federal Shipping Meat/Poultry Thoringer Rostbratwurst 99 643/31/2019 Davis Federal Shipping Meat/Poultry Pat chinois 65 2/14/2019 Davis Federal Shipping Meat/Poultry Thringer Rostbratwurst 123.79 08 9/20/2019 Davis United Package Meat/Poultry Perth Pasties 67 3/25/2019 Davis Speedy Express Meat/Poultry Pte chinois Speedy Express Meat/Poultry Perth Pasties 32.8 69 7/5/2019 Davis United Package Meat/Poultry Perth Pasties 70 9/11/2019 Davis United Package Meat/Poultry Perth Pasties 71 9/13/2019 Davis United Package Meat/Poultry Pat chinois 72 2/28/2019 Davis United Package Meat/Poultry Tourtiere 73 6/20/2019 Davis Federal Shipping Meat/Poultry Tourtire 7.45 74 6/1/2019 Davis United Packape Meat/Poultry Tourtire 7.45 75 11/24/2019 Davis United Package Meat/Poultry Tourtiere 75 10/16/2019 Davis United Package Meat/Poultry Pat chinois 77 1/25/2019 Davis Federal Shipping Meat/Poultry Tourtire 78 11/17/2019 Davis Federal Shipping Produce Manjimup Dried Apples 79 4/26/2019 Davis United Package Produce Manjimup Dried Apples 424 90 7/5/2019 Davis United Package Produce Manjimup Dried Apples 81 4/24/2019 Davis Speedy Express Produce 82 5/21/2019 Davis United Package Produce Rossle Sauerkraut 83 12/8/2019 Davis Federal Shipping Produce Rossle Sauerkraut 841/8/2019 Davis Federal Shipping Produce Rssle Sauerkraut 1/25/2019 Davis Federal Shipping Produce Manjimup Dried Apples 6/4/2019 Davis Speedy Express Produce Uncle Bob's Organic Dried Pear 30 87 12/8/2019 Davis Federal Shipping Produce Tofu 88 11/9/2019 Davis Federal Shipping Produce Tofu 89 4/26/2019 Davis United Package Produce Longlife Tofu 905/14/2019 Davis United Package Produce Uncle Bob's Organic Dried Pear 91 4/15/2019 Davis Speedy Express Produce Rossle Sauerkraut 92 10/18/2019 Denton United Package Beverages everages Cite de Blaye 93 2/15/2019 Denton Federal Shipping Beverages CustSales 24 ot%88BAUBES 88 7.45 Lakkalikoori B File Home insert Page Layout Formulas Data Review View Help Acrobat f A1 40 lo 19.45 28.5 33 25 123.79 7.45 14.4 AB 93 2/15/2019 Denton Federal Shipping Beverages Lakkalikri 94 3/26/2019 Denton United Package Beverages Chai 95 5/16/2019 Denton United Package Beverages Outback Lager 96 2/12/2019 Denton Speedy Express Beverages Chang 97 7/4/2019 Denton United Package Beverages Rhnbru Klosterbier 98 1/17/2019 Denton Federal Shipping Beverages Sasquatch Ale 99 6/15/2019 Denton Federal Shipping Beverages Outback Lager 100 1/25/2019 Denton Federal Shipping Beverages Guaran Fantstica 101 1/17/2019 Denton Federal Shipping Beverages Guaran Fantstica 102 3/20/2019 Denton United Package Beverages Guarana Fantstica 103 3/20/2019 Denton United Package Condiments Northwoods Cranberry Sauce 104 2/12/2019 Denton Speedy Express Condiments Northwoods Cranberry Sauce 106 2/22/2019 Denton United Package Condiments Aniseed Syrup 106 12/19/2019 Denton Speedy Express Condiments Gula Malacca 107 5/29/2019 Denton Federal Shipping Condiments Sirop d'rable 108 7/4/2019 Denton United Package Grains/Cereals Wimmers gute Semmelknodel 1093/20/2019 Denton United Package Meat/Poultry Thringer Rostbratwurst 110 5/10/2019 Denton Federal Shipping Meat/Poultry Tourtire 111 6/8/2019 Kaplan United Package Beverages Ipoh Coffee 112 9/21/2019 Kaplan Federal Shipping Beverages Steeleye Stout 113 4/18/2019 Kaplan Speedy Express Beverages Lakkalikri 114 5/27/2019 Kaplan United Package Beverages Lakkalikri 115 12/5/2019 Kaplan Federal Shipping Beverages Chai 116 4/18/2019 Kaplan United Package Beverages Lakkalikri 117 11/6/2019 Kaplan Federal Shipping Beverages Outback Lager 118 4/17/2019 Kaplan Federal Shipping Beverages Steeleye Stout 119 9/14/2019 Kaplan Speedy Express Beverages Chang 120 4/25/2019 Kaplan Federal Shipping Beverages Chartreuse verte 121 9/7/2019 Kaplan United Package Beverages Steeleye Stout 122 2/20/2019 Kaplan Speedy Express Beverages Steeleye Stout 123 11/28/2019 Kaplan United Package Beverages Steeleye Stout 124 1/18/2019 Kaplan Speedy Express Beverages Rhonbru Klosterbier 125 5/23/2019 Kaplan United Package Beverages Steeleye Stout 126 4/12/2019 Kaplan Speedy Express Beverages Guarani Fantstica 127 4/30/2019 Kaplan Speedy Express Beverages Ipoh Coffee 128 9/22/2019 Kaplan Federal Shipping Beverages Sasquatch Ale 129 3/7/2019 Kaplan United Package Beverages Chang 130 4/17/2019 Kaplan Federal Shipping Beverages Outback Lager 1312/8/2019 Kaplan Speedy Express Beverages Outback Lager 132 4/16/2019 Kaplan United Package Beverages Rhnbrau Klosterbier 133 8/29/2019 Kaplan Federal Shipping Beverages Chartreuse verte 134 11/1/2019 Kaplan United Package Beverages Lakkalikri 135 5/8/2019 Kaplan United Package Beverages Guaran Fantstica 136 3/31/2019 Kaplan Speedy Express Beverages Rhonbru Klosterbier 1379/7/2019 Kaplan United Package Beverages Guaran Fantstica 138 1/18/2019 Kaplan Speedy Express Condiments Northwoods Cranberry Sauce 139 6/12/2019 Kaplan Speedy Express Condiments Chef Anton's Cajun Seasoning 140 4/25/2019 Kaplan Federal Shipping Condiments Vegie-spread CustSales ... 18 18 7.75 18 3.6 46 11.2 15.2 7.75 18 14.4 4.5 45 40 439 File Insert Page Layout Home Formulas Data View Review Help Acrobat Al- 22 8 8 8 8 8 10 8 15.5 104 104 33.25 9 9 04 30.4 14 14 21 33.25 3 1379/7/2019 Kaplan 139 1/18/2019 Kaplan 139 6/12/2019 Kaplan 140 4/25/2019 Kaplan 141 6/3/2019 Kaplan 142 9/27/2019 Kaplan 143 2/27/2019 Kaplan 144 9/12/2019 Kaplan 145 9/12/2019 Kaplan 146 2/20/2019 Kaplan 1479/27/2019 Kaplan 140 2/20/2019 Kaplan 149 2/20/2019 Kaplan 150 6/21/2019 Kaplan 151 1/15/2019 Kaplan 152 10/10/2019 Kaplan 1532/20/2019 Kaplan 1545/8/2019 Kaplan 155 10/2/2019 Kaplan 156 4/17/2019 Kaplan 1575/7/2019 Kaplan 2/1/2019 Kaplan 5/3/2019 Kaplan 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 1664/18/2019 Kaplan 167 9/18/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 United Package Beverages Guarana Fantastica Speedy Express Condiments Northwoods Cranberry Sauce Speedy Express Condiments Chef Anton's Cajun Seasoning Federal Shipping Condiments Vegle-spread United Package Condiments Original Frankfurter grne Soe Speedy Express Condiments Chef Anton's Gumbo Mix United Package Condiments Aniseed Syrup United Package Condiments Vegle-spread United Package Condiments Gula Malacca Speedy Express Condiments Original Frankfurter grne Soe Speedy Express Condiments Original Frankfurter grone Soe Speedy Express Grains/Cereals Wimmers rute Semmelkndel Speedy Express Grains/Cereals Tunnbrd United Package Grains/Cereals Tunnbrod Federal Shipping Grains/Cereals Gnocchi di nonna Alice United Package Grains/Cereals Gnocchi di nonna Alice Speedy Express Grains/Cereals Singaporean Hokkien Fried Met United Package Grains/Cereals Singaporean Hokkien Fried Met United Package Grains/Cereals Gustaf's knackebrod Federal Shipping Grains/Cereals Wimmers gute Semmelknodel United Package Grains/Cereals Gustaf's Knckebrd Speedy Express Grains/Cereals Tunnbrd United Package Grains/Cereals Filo Mix United Package Grains/Cereals Filo Mix Speedy Express 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 Uncle Bob's Organic Dried Pear Speedy Express Produce United Package Produce Uncle Bob's Organic Dried Pear United Package Produce Uncle Bob's Organic Dried Pear Speedy Express Produce Manjimup Dried Apples Federal Shipping Produce Manjimup Dried Apples United Package Produce Tofu United Package Produce Rssle Sauerkraut 123.79 8 BUBUBB 8 32.8 192 30 30 8 8 8 8 30 23:25 45.6 CustSales