Steps to Perform:

Step	Instructions	Points Possible
1	Start Excel.	0
2	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.	10
3	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.	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	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.	12
7	Filter the table data by Category to show only the Safety Equipment inventory data.	12
8	Copy the Safety worksheet, and create a new worksheet at the end with the name Order.	8
9	On the Safety worksheet convert the table to a normal range.	12

please give clear steps

B E F G Emergency Equipment Inventory 2 3 4 Quantity in Stock Item Cost Each Type Category Stock Level Total Cost 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 53 40 3 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 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 Coil Headphones Radio Strap/Holder Retractable Mic keeper Leather Radio Holder 10 Zipper Boots Leather Fire Boots Rubber Lug 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 Haz-Mat Boots Disaster Kit Helmet Structural Fire Helmet Helmet with Eye Shield Megaphone Barrier Tape FirePants Fire Coat Proximity Coat Proximity Pants Radio Chest Harness 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 Flares with Stands Traffic Flashlight Night Barrier Tape Reflective Nylon Vest Water Rescue Kit Water Rescue Vest Water Tether System Wildfire Helmet Full-Brim Helmet Firefighting Goggles Water Throw Bag Dry Bag $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 $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 $18 Light $15 Tape $11 Vest $119 Safety $99 Safety $59 Safety $59 Helmet $59 Helmet $49 Helmet $59 Safety $18 Safety 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 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 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 Orde Order Order Order Order 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 1,589 1800 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 32,475 18,003 385 2,784 5,572 2,871 13,965 13,583 2,581 255 725 979 4,624 3,591 513 11,285 8,910 468 840 979 2,023 3,762 236 1,062 1,003 2,842 1,829 576 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67