CAN YOU PLEASE SHOW THE STEP BY STEP ON EXCEL.. ( so I know where to click) thank you!

Step Instructions Point Value 1 0 Start Excel. Download and open the file named Student_MOS19_XL_PROJ3_Equipment.xlsx. Save the file as Last_First_MOS19_XL_PROJ3_Equipment. 2 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 Assignment Instructions X 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 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. Copy the Safety worksheet, and create a new worksheet at the end with the name Order. 8 8 9 12 10 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.xlsx. Exit Excel. Submit the file as directed 0 Formulas Data Review View Home Insert Draw Page Layout Connections Properties Get External Refresh Data All Edit Links 1112 fx Tell me y Clear * Reapply Advanced Stocks Geography 2 Sort Filter Text to BF Columns D H Emergency Equipment 1 2 3 Inventory 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 53 Coll Headphones 40 Radio Strap/Holder 3 Retractable Mic Keeper Leather Radio Holder 20 10 Zipper Boots 21 Leather Fire Boots 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 Shidd 8 Megaphone 53 Barrier Tape 18 Fire Pants 19 Fire Coat 25 Proximity Coat Ertainment $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 552 Boots $89 Boots $99 Safety $229 Helmet $179 Helmet $339 Shield $79 Megaphone $12 Tape $649 Pants $989 Coat $1,299 Coat 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 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 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 32,475 we Connections Properties 4. Flas Y Clear Reapply Advanced Get External Data Refresh All Stocks Geography Filter 21 Sort Edit Links Text to Columns Rem 1112 fx A H 53 18 19 25 17 34 35 36 37 38 39 40 41 42 43 44 45 46 47 87 28 29 35 47 89 15 25 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 Hares 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 Oryti 49 50 51 52 53 56 55 S6 57 58 59 60 61 D $79 Megaphone $12 Tape $649 Pants $989 Coat $1,299 Coat $1,059 Pants $35 Safety $32 Gloves $199 Safety 599 Safety $399 Coat $289 Pants $29 Vest $17 Vest $29 Vest $11 Vest $289 Siren $189 Siren $19 Baton $305 Light 599 Light 518 Light $15 Tape $11 Vest $119 Safety $99 Safety $59 Safety $59 Helmet $59 Helmet $49 Helmet 559 Safety $18 Safety E 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 F Level UK Order Order 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 G 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 16 19 27 37 90 26 56 89 17 4 18 17 58 1,003 63 64 65 66 2,842 1,829 576