In excel please answer questioms 2 through 9.

N 10 On the Equipment worksheet find and remove the duplicate record in the Item column. Copy the Equipment worksheet, and create a new worksheet at the end with the name Safety. 3 18 On the Safety worksheet, format the range A4:G64 as an Excel table. Verify the table has headers and apply the Teal, Table Style Medium 18. 4 Remove the table row 5. Apply the First Column Table Style Option. 13 5 Insert a Total Row. Count the items and determine the Maximum item cost. 15 6 12 Use the filter arrows in the header row of the table to sort the Item column in ascending order, and then sort the Stock Level column by font color so that all items that need to be ordered appear at the top of the list. Do not create a multi-level sort. 7 12 Filter the table data by Category to show only the Safety Equipment inventory data. 8 8 Copy the Safety worksheet, and create a new worksheet at the end with the name Order. 9 On the Safety worksheet convert the table to a normal range. 12 Emergency Equipment Inventory Quantity in Stock Item Cost Each Type Category Stock Level Total Cost 53 40 3 41 20 21 26 27 28 10 25 27 9 34 17 14 11 9 9 13 19 45 10 10 57 10 51 25 Coil Headphones Radio Strap/Holder Retractable Mic Keeper Leather Radio Holder 10 Zipper Boots Leather Fire Boots Rubber Log Boot Rubber Fire Boots Rubber Bunker Boots Hazmat Boot Fire Gloves Proximity Gear Gloves Extrication Gloves Rescue Glove Liners Extrication Coat Extrication Pants Extrication Coveralls Gas Mask Gas Mask Pouch Respirator Coverall with Hood Disaster Safe Bag Chemical Overboot Hax-Mat Boots Disaster Kit Helmet Structural Fire Helmet Helmet with Eye Shield Megaphone Barrier Tape Fire Pants Hire Cou Proximity Coat Proximity Pants Radio Chest Harness Rope Gloves Safety Homes $30 Radio $45 Radio $20 Radio $25 Radio $320 Boots $340 Boots $109 Boots $169 Boots $129 Boots $149 Boots $89 Gloves $124 Gloves $77 Gloves $39 Gloves $223 Coat $189 Pants $339 Coveralls $259 Safety $35 Safety 5369 Safety $159 Coveralls $13 Safety $52 Boots 589 Boots 599 Safety 5229 Helmet $179 Helmet $339 Shield 579 Megaphone 512 Tape $619 Pants $989 Coat $1.299 Cout 51.059 Pants $35 Safety 532 Cloves $199 Safety 599 Safety $399 Coat 5289 Pants $29 V 517 Vest 129 Vest $11 Vest 5289 Siren 5189 Suren $19 Bato 500 Light 599 Lighs 518 Light S15 Tape 511 Veu Communication Communication Communication Communication Footwear Footwear Footwear Footwear Footwear Footwear Outerwear Outerwear Extrication Gear Outerwear Extrication Gear Extrication Gear Extrication Gear Safety Equipment Safety Equipment Safety Equipment Outerwear Safety Equipment Footwear Footwear Safety Equipment Outerwear Outerwear Safety Equipment Communication Traffic Outerwear Outerwear Outerwear Outerwear Safety Equipment Outerwear Safety Equipment Safety Equipe Outerwear Outerwear Outerwear Outerwear Outerwear Outerwear Traffic Traffic Tratto Trade Trafic Tratti Trafie Outerwa Order Order Level OK Order Order Order Order Order Order Level OK Order Order Level OK Order Order Order Order Level OK Level OK Order Order Order Level OK Level OK Order Level OK Order Order Level OK Order Order Order Order Order Order Order Onder Order Order Order Order Order Order Order Order Order Orale Onder Onder Order Order 1589.47 1,7996 59.97 1,024.59 6,399.8 7,140 2,834 4.563 3,612 1.490 2.225 3,348 693 1,326 3.791 2.646 3.949 2,331 315 4,797 3.021 585 520 890 5.643 2.290 9.129 475 632 636 11.682 18.791 32,475 18.003 385 2.784 5.572 2.871 13.965 13.583 2.381 255 725 9-79 4.624 3,891 513 11.285 8910 SON 840 979 53 18 19 25 17 11 87 28 29 35 47 89 89 16 19 27 37 90 EMS Jacket EMS Pants Breakowy Ver Mesh Vest Mesh Traffic Vest Reflective Nylon V Hanheld Remote Siren Stren Trafollason Pare Beacon Kit Harts with Stands Trac Flashlight Night Be Tape ilette Nylon Vest 26 56 89 Order 40 3 41 20 21 26 22 28 10 25 27 9 34 17 14 11 9 9 13 19 45 10 10 57 10 51 25 8 50 18 19 25 17 COM Radio Strap/Holder Retractable Mic Keeper Leather Radio Holder 10 Zipper Boots Leather Fire Boots Rubber Log Boot Rubber Fire Boots Rubber Banker Boots Hazmat Boot Fire Gloves Proximity Gear Gloves Extrication Gloves Rescue Glove Liners Extrication Cout Patrication Pants Extrication Coveralls Gas Mask Gas Mask Pouch Respirator Coverall with Hood Disaster Safe Bag Chemical Overboot Haz Mat Boots Disaster Kit Helmet Structural Fire Helmet Heimet with Eye Shield Megaphone Barrier Tipe Fire Pants Here Coat Proximity Cout Proximity Pants Radio Chest Harness Rope Glover Safety Harnes Chest Harness EMS Jacket EMS Pants Breakaway Vest Mesh Vest Mesh Traffic Vest effective Nylon Ves Handheld Remote Sim Siren Tradic B Fan Heace is Flats with Stands Tralle Hashi Night Barriere Reflective Nylon Vest Water Rewe Ki Wine Race Visit Water Teber Sym Wildfire Helmet TE 1.799,6 59.97 1,024.59 6,3998 7,140 2,834 4,563 3.612 1,490 2.225 3,348 693 1.326 3.791 2,646 3.949 2,331 315 4,797 3,021 585 520 890 5.643 2.290 ber Communication Communication Communication Footwear Footwear Footwear Footwear Footwear Footwear Outerwear Outerwear Extrication Gear Outerwear Extrication Gear Extrication Gear Extrication Gear Safety Equipment Safety Equipment Safety Equipment Outerwear Safety Equipment Footwear Footwear Safety Equipment Outerwear Outerwear Safety Equipment Communication Trafic Outerwear Outerwear Outerwear Outerwear Safety Equipment Outerwear Safety Equipment Safety Equipement Outerwear Outerwear Orwear Outerwear Outerwear Outerwear Traffic Traffic Trade Traffic Trafie Trat $45 Radio 520 Radio $25 Radio $320 Boots 3340 Boots $109 Boots $169 Boots $129 Boots S149 Boots $89 Gloves $124 Gloves 577 Gloves $39 Gloves $223 Coat $189 Pants $359 Coveralls $259 Safety $35 Safety $369 Safety $139 Coveralls $13 Safety $S2 Boots 589 Boots 599 Safety $229 Helmet $179 Helmet 5339 Shield 579 Megaphone $12 Tape $649 Pants $989 Coat $1.299 Cow $1.059 Pants $35 Safety $32 Gloves $199 Safety 599 Safety $399 Coat $289. Pats $29 Vest 517 Vest 529 Vest $11 Vest 5289 Siren 5189 Siren $19 Baton S05 Light 9 Lig Sis Ligh S15 Tape SI Vest 3119 Safety w Safety 559 Safety 559 Helmet 559 Heleet 540 Helmet 559 Safety 518 Safety 9,129 Order Level OK Order Order Order Order Order Order Level OK Order Order Level OK Order Order Order Order Level OK Level OK Order Order Order Level OK Level OK Order Level OK Order Order Level OK Order Order Order Order Order Order Order Order Onder Order Order Order Order Order Order Order Order Order Order Order Order Order Ceder Order Order Level OK Order Order Order Order 8.475 632 6:36 11.682 18,791 32,475 18.00 385 2,754 5.572 2.871 13.995 13.583 87 28 29 35 15 25 89 255 725 4,624 3.591 513 11.25 8.910 468 16 19 22 37 90 26 56 89 12 31 4 13 17 88 31 979 Orwear Water Rescue Water Rescue Water Rescue Outerwear Outerus Safety Equipment Water Rescue Water Recu 3.12 236 1.162 1.003 2.542 129 576 Hifting Corales Water Throw Ba Dry Hall Order