This is on excel, Note: please specifically show or list how to do all the steps correctly. I am having trouble with the steps
teps to Perform: Step Instructions Points Possible 1 0 N 10 3 18 4 13 5 Start Excel. Download and open the file named Student MOS19_XL_PROJ3_Equipment.xlsx Save the file as Last First MOS19 XL PROJ3 Equipment. 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. 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. Remove the table row 5. Apply the First Column Table Style Option. Insert a Total Row. Count the items and determine the Maximum item cost. 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, Filter the table data by Category to show only the Safety Equipment inventory data, Copy the Safety worksheet and create a new worksheet at the end with the name Order. On the Safety worksheet convert the table to a normal range, Ensure the worksheets are in the following order Equipment, Safety, Order. Save the file Last First MOS19 XL PROJ3 Equipment. x/sx. Exit Excel Submit the file as directed, 15 6 12 7 12 8 8 9 12 10 0 Total Points 100 D E Emergency Equipment Inventory Quantity in Stock Cost Each Type Category Stad ne Total Cost 1.100 60 1,005 7 1 9 10 11 12 5 14 15 16 17 53 40 a 41 20 21 26 27 28 30 25 27 9 36 17 Order Order LOK Order Order Order Order Order Order OK 7,140 2014 4563 3.512 1.490 2235 19 20 21 14 11 9 9 Order Level O Order Order Order Order LOK Level Or Order 693 2226 3.791 264 2.949 2,330 315 13 24 3 26 27 28 29 30 31 19 45 30 Coil Headphones Radio Strap/Holder Retractable Mic Keeper Leather Radio Holder 10 Zipper Boots Leather Fire Boots Rubber Lug Boot Pubber Fire Boots Rubber Bunker Boots Harmat Boot Fire Gloves Proximity Gear Gloves Extrication Gloves Pesce Glove Liners Extrication Coat Extrication Parts Extrication Coveralls Gas Mask Gas Mask Pouch Respirator Coverall with Hood Disaster Safe Bag Chemical Overboot Has Mat Boots Dinero Helmet Structural Fire Helmet Helmet with Eye Shield Megaphone Barrier Tape FirePants Fire Coat Proximity Coat Proty Pants Radio Ovest Harness Roge Gloves Safety Harness Chest me MS ladet MS Parts Breakaway Vedl Mesh Vest Mesh Traffic Vest edive Nylon Vest Handheld Remote Siren Siren Traffic Baton Farben Fares with Stand $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 519 Pants $359 Covers $25 Safety $35 Sauty $30 Safety 5159 Coveralls $13 Safety $S2 Boots $89 Roots $9 Safety $229 Helmet 5179 Helmet $339 Shield 579 Megaphone $12 Tape $649 Parts $989 Coat 51,299 Coat $1,059 Pants S3 Safety $32 Gloves $19 Safety $99 Safety $399 Coat $289 Pants $29 Vent $17 Vest $29 Vest $11 Vest $29 Communication Communication Communication Communication Footwear Footwear Footwear Footwear Footwear Footwear Outerwear Outerwear Extrication Gear Outerwear Erication Gear Erication Gear Extrication Gear Safety Ent Safety Equipment Safety Equipment Outerwear Safety Equipment Footwear Footwear Safety Equipment Outerwear Outerwear Safety Equipment Communication Traffic Outerwear Outerwear Outerwear Outerwear Salty Equipment Outerwear Safety Count Safety En Outerwear Orwear Outerwear Outerwe Outerwear Derwear 2,021 SBS 520 20 Love OK Or Level OK 30 57 10 53 25 8 53 18 19 25 17 11 33 OK Order 2473 620 636 11 16 37 Order 39 40 rder Order 3es 2754 42 43 44 45 46 47 ZE 29 25 67 29 15 25 1398 LE 2581 Or 49 454 51 16 19 27 53 54 Trat Tr Traffic Tratt Traffic O O $19 Batan $105 199 g 514 $15 Tape 511 Vest $119 Safety 26 56 56 Duterwear 2,00 59 60 78 4 Ng Barrier Tape Meltede Nyos Ver Water Re Water Rescue Vem Water Tatar System Wie Helmet Fuler Helmet Water RENG Outer Outerwear 2.062 63 Order DI 58 30 32 559 Het 555 Heimt 513 Helmut 398 Say $18 Saly 2.10 Water Tower Dry Bag Water Reso 66 fx Emergency Equipment C D Emergency Equipment Inventory 4 Quantity in Stock Item Cost Each Type Category Stock Level Total Cost 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 53 Coil Headphones 40 Radio Strap/Holder 3 Retractable Mic Keeper 41 Leather Radio Holder 20 10Zipper Boots 21 Leather Fire spots 26 Rubber Lug Boot 27 Rubber Fire Boots 28 Rubber Bunker Boots 10 Hazmat Boot 25 Fire Gloves 27 Proximity Gear Gloves 9 Extrication Gloves 34 Rescue Glove Liners 17 Extrication Coat 14 Extrication Pants 11 Extrication Coveralls 9 Gas Mask 9 Gas Mask Pouch 13 Respirator 19 Coverall with Hood 45 Disaster Safe Bag 10 Chemical Overboot 10 Haz Mat Boots 57 Disaster Kit 10 Helmet 51 Structural Fire Helmet 25 Helmet with Eye Shield 8 Megaphone 53 Barrier Tape 18 Fire Pants 19 Fire Coat 25 Proximity Coat 17 Proximity Pants 11 Radio Chest Harness 87 Rope Gloves Equipment $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 $359 Coveralls $259 Safety $35 Safety $369 Safety $159 Coveralls $13 Safety $52 Boots $89 Boots $99 Safety $229 Helmet $179 Helmet $339 Shield $79 Megaphone $12 Tape $649 Pants $989 Coat $1.299 Coat $1,059 Pants $35 Safety $32 Gloves 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 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 1,589 1,800 60 1,025 6,400 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 8.475 632 636 11,682 18,791 32475 18003 385 2,784 26 27 - 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Format B TV 33 Merge & Center $ %) Al x fx Emergency Equipment D 10 57 10 29 30 31 32 33 34 35 36 37 38 39 40 Level OK Order Level OK Order Order Level OK Order Order Order Order 890 5,643 2,290 9,129 8475 632 Order Order 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 S8 59 60 61 51 25 8 53 18 19 25 17 11 87 28 29 35 47 89 15 25 89 16 19 27 37 90 26 56 89 17 38 4 18 17 58 31 32 Haz-Mat Boots Disaster Kit Helmet Structural Fire Helmet Helmet with Eye Shield Megaphone Barrier Tape Fire Pants Fire Coat Proximity Coat Proximity Pants Radio Chest Hotness Rope Gloves Safety Harness Chest Harness EMS Jacket EMS Pants Breakaway Vest Mesh Vest Mesh Traffic Vest Reflective Nylon Vest Handheld Remote Siren Siren Traffic Baton Flare Beacon Kit Rares with Stands Traffic Flashlight Night Barrier Tape Reflective Nylon Vest Water Rescue Kit Water Rescue Vest Water Tether System Wildfire Helmet Fub Brim Helmet Firefighting Goggles Water Throw Bag Dry Bag $89 Boots $99 Safety 5229 Helmet $179 Helmet $339 Shield $79 Megaphone $12 Tape $649 Pants $989 Coat $1.299 Coat $1,059 Pants $35 Safety $32 Gloves $199 Safety $99 Safety $399 Coat $289 Pants $29 Vest $17 Vest $29 Vest $11 Vest $289 Siren $189 Siren $19 Baton $305 Light $99 Light 518 Light 515 Tape $11 Vest $119 Safety $99 Safety $59 Safety $S9 Helmet $59 Helmet $49 Helmet $59 Safety S18 Safety Footwear Safety Equipment Outerwear Outerwear Safety Equipment Communication Traffic Outerwear Outerwear Outerwear Outerwear Safety Equipment Outerwear Safety Equipment Safety Equipment Outerwear Outerwear Outerwear Outerwear Outerwear Outerwear Traffic Traffic Traffic Traffic Traffic Traffic Traffic Outerwear Water Rescue Water Rescue Water Rescue Outerwear Outerwear Safety Equipment Water Rescue Water Rescue Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Level OK Order Order Order Order Order 636 11,682 18,791 32.475 18,003 385 2,784 5,572 2.871 13,965 13,583 2,581 255 725 979 4,674 3,591 513 11,285 8.910 468 840 979 2,023 3,762 236 1,062 1.003 2.842 1829 576 62 63 64 65 66 67 68 69 20 Equipment
