please answer all questions

Step Instructions Points Possible 1 0 2. 10 3 18 4 13 5 15 6 Start Excel. Download and open the file named Student_MOS19_XL_PRO_3_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.xlsx. Exit Excel. Submit the file as directed. 12 7 12 8 8 9 12 0 10 Total Points 100 E Coy Formal $% Merge Center A BTU G47 o xfx =M7*CA7 O F H Emergency Equipment 1 1 - 4 M 5 53 40 1 4 10 21 26 27 28 10 25 15 1.300 60 1,025 6,400 7,140 2,836 4.565 33612 1.490 7 8 3 10 11 12 13 14 15 36 17 18 19 20 21 22 23 24 25 26 27 28 239 10 31 32 33 34 35 36 37 3 19 40 H 17 14 11 9 9 13 19 45 10 10 57 10 51 25 Gol Head hones Radio Strap/Holder Retractable MicKeeper Leather Radio Holder 10 Zipper Boots Leather Posts Rubber Bot Fire Boots Rubber Bunker Boots Hama Boot Gloves Proximity Gear Gloves Extriction Gloves Rescue Glove Liners Deration Coat Extrication Pants Extrication Covers Gas Mas Gas Mask Pouch Respirator Coverall with Hood Der Safe Bag Chemical Overboot Har Mat Boots Disaster Hemnet Structural Fire Helmet Helmet with Eye Shield Megaphone Bwrier Tape FirePants Fire Coat Proximity Coat Proximity Pants Radio Chest Hamers Hope loves Safety Harness Chest Maraw EMS Jacket ENSP Breakway Vest Meest Mehre Vest Reflective Nylon Vest Handheld Remote Siren Siren Traffic Baton Freecon Kit with Sands Traffic light Net Barrier Tape Water Rescue Water Rescue Vest Wallether wildtreet Full Helmet Firetroces Water Throw Bag Orytas 53 18 19 25 17 11 87 28 29 35 47 19 15 25 510 do 545 Radio $20 Radio $25 Radio $320 B 5140 Boots $109 Boots $169 Boots $129 Boots $149 Boots $89 Gloves 5124 Gloves $72 $39 Gloves 5223 Cout 519 Pants $359 Coveralls $259 Safety $35 Safety $369Safety 5159 Coveralls $13 Safety 552 Boots $89 Boots $99 Safety $229 Helmet $179 Helmet 5339 Shield $29 Megaphone 512 Tape 5649 Pants 5989 Cou $1.299 Coat $1,059 Pants 535 Safety $32 Gloves $199 Safety 593 Safety $399 Coat $289 Pants $29 Vest $17 Vest $29 Vest $11 Vest $289 Siren $189 Siren 59 9 Slought $9 Light $18 UM $15 Tape 511 Vest $119 Safety 599 Sety $50 Safety $59 Helmet $59 Helmet 549 Helmet $59 Safety 518 Safety Commation Comitation Comownication Communication Footwear Foster Footer Foot Footwear Foot Outwe Outerwear Extrication Gear Outerwe Extrication Gear Extrication Gear Dutcabine Safety Equipment Safety Equement Safety Equipment Outerwear Safety Equipment Footwear Footwe Safety Equipment Outerwe Duterwear Safety Equipment Communication Tratti Outerwear Outerwear Outerwear Outerwear Safety Fouiment Outerwear Safety Equipment Safety Equipment Outerwear Outerwe Outerwe Outerwear Outerwear Outerwear Tratli Trac Traffic Tradic Trafic Trafic Trafic Outerwear Water Rescue Water Rescue Water Rescue Outerwear Outerwear Safety foment Water Rescue Water Rescue Ded Order Le OK Order Order Order Order Order Order Leveo Order Order Live OK Order Order Order Order Level OK Level OK Order Order Order Level Ok Level OK Order Level OK Order Order Lewik Order Order Order Order Order Order Onder Order Order Order Order Order Order Order Order Order Onge Order Order Order Order Order order Order Order Level OK Order Order Order Order Deder 2,348 69) 1,326 3,791 7,646 3,949 2,331 315 4,797 3,021 585 520 890 5.641 2,290 9,137 8,475 632 636 15.482 18,791 42 43 44 35 46 47 40 10 50 51 52 $3 H 55 27 37 90 26 56 89 17 18,001 385 2,784 5,572 2.871 11,965 13.583 2.581 255 725 979 4,624 3,591 513 11,265 8,910 465 840 979 2,023 1,762 236 1,062 1.001 2.542 1.329 576 32,475 57 56 39 60 51 52 1 4 18 17 sa 31 12 N 10 3 18 4 6 13 15 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 Safely worksheet, and create a new worksheet at the end with the name Order. On the Safety worksheet convert the table to a normal range. 6 12 12 8 8 9 12 G47 Xfx247*C47 A H D Emergency Equipment Inventory 1 - 5 $ 7 53 40 5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 23 29 30 31 32 3 34 35 36 37 35 39 40 41 20 21 26 27 28 10 25 27 9 34 17 14 11 9 9 13 19 Coil Headphones Radio Strap/Holder Retractable Mic keep Leather Radio Holder 10 Zipper Boots tescher Fire Boots Rubber lug Boot Rubber Fire Boots Rubber Bunker Boots Hamabot Fire Gloves Proximity Gear Gloves Extrication Gloves Rescue Glovers Extrication Court brication Pants trication Covers Gas Mask Gas Mask Pouch Respirator Coverall with Hood Disaster Safe Bag Chemical Overboot Has Mat Boots Disaster Kit Helmet Structural Fire Helmet Helmet with Eye Shield Megaphone Barrier Tape FirePants Fire Coat Proximity Com Proximity Pants Radio Chest Harnesi Rope Gloves Safety Harness Oestress TMS Jacket en Pants Breakaway Vest Met Vest Mesh ratives Reflective Nylon Vet Handheld Remote Siren Siren Tractaton Flanellacon Kit nes with Stands Trac Flashlight Night Barrier Tape Wit Resuelt Water Rescue Vest Water Tether System Wildfire Full Brimet 10 10 57 10 51 25 $30 Radio $45 Radio $20 Radio $25 Radio $320 Boots $340 Boots $105 Boots $169 Boots $129 Boots $149 Boots $89 Gloves $124 Gloves 577 Gloves $39 Gloves $223 Coat $189 Pants $359 Coveralls $259 Safety $35 Safety $369/safety $159 Cover $13 Safety $52 Boots $89 Boots 309 Sety $229 Helmet $179 Helmet $339 Shield $79 Megaphone $12 Tape $649 Pants $989 Coat $1,299 Coat $1,059 Pants Safety $32 Gloves $199 Safety $99 Safety $399 Coat $289 Pants $29 Vest 517 Vest $20 Vest $11 Ves $289 Siren $189 Siren 519 | | | $305 Light $99 Light $10 Light $15 Tape Si Vest $119 Safety 599 Say 559 y 559 Homes 559 Helmet $49 Helmet 559 Safety Si Safety 8 Communication Communication Communication Communication Footwear Footwear Footwear Footwear rostwear Footwear Outerwear Outerwear Extrication Gear Outerwear Erication Ger Extrication Gear Extrication Gear Safety Bopment Safety Equipment Safety Equipment Outerwear Safety Equipment Footwear Footwear Safety Equipment Outerwear Outerwear Safety Equipment Communication Trac Outerwear Outerwear Outerwear Outerwe Safety Equipment Outerwow Safety Equiment Safety figment Outerwear Outerwear Outerwear Outerwear Outerwe Outerwear Tratt Traffic Teatre Trafic Traffic tratti Trate Outerwear Water Rescue Water Rescue Water Rescue Outerwear Outerwear Safety Equipment Water Rescue Wat Rescue 1,589 1.800 60 1,095 6,400 7,140 2.834 4.563 3.632 1.490 2,225 3,348 691 1,326 3,791 2,646 3,949 2,331 315 4,797 3,021 585 520 890 5,603 2.290 9,129 8.475 32 636 11,682 18,791 32.475 18,003 385 Order Order Led 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 Live OK Order Order Level OK Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Dider Order Order Order Level OK Order Order Order Order Order 18 19 25 17 11 57 28 29 35 47 89 2.754 64 147 50 51 54 SS 56 57 58 59 60 SAN & BABE 5,572 2.871 13,965 13.583 2.581 255 725 979 4.624 3,591 513 11,255 8,910 468 340 979 2.023 3,752 236 1,062 1,003 2,342 1,829 578 26 56 69 17 OSOBO Water Throw Dry Bag 31 32 Step Instructions Points Possible 1 0 2. 10 3 18 4 13 5 15 6 Start Excel. Download and open the file named Student_MOS19_XL_PRO_3_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.xlsx. Exit Excel. Submit the file as directed. 12 7 12 8 8 9 12 0 10 Total Points 100 E Coy Formal $% Merge Center A BTU G47 o xfx =M7*CA7 O F H Emergency Equipment 1 1 - 4 M 5 53 40 1 4 10 21 26 27 28 10 25 15 1.300 60 1,025 6,400 7,140 2,836 4.565 33612 1.490 7 8 3 10 11 12 13 14 15 36 17 18 19 20 21 22 23 24 25 26 27 28 239 10 31 32 33 34 35 36 37 3 19 40 H 17 14 11 9 9 13 19 45 10 10 57 10 51 25 Gol Head hones Radio Strap/Holder Retractable MicKeeper Leather Radio Holder 10 Zipper Boots Leather Posts Rubber Bot Fire Boots Rubber Bunker Boots Hama Boot Gloves Proximity Gear Gloves Extriction Gloves Rescue Glove Liners Deration Coat Extrication Pants Extrication Covers Gas Mas Gas Mask Pouch Respirator Coverall with Hood Der Safe Bag Chemical Overboot Har Mat Boots Disaster Hemnet Structural Fire Helmet Helmet with Eye Shield Megaphone Bwrier Tape FirePants Fire Coat Proximity Coat Proximity Pants Radio Chest Hamers Hope loves Safety Harness Chest Maraw EMS Jacket ENSP Breakway Vest Meest Mehre Vest Reflective Nylon Vest Handheld Remote Siren Siren Traffic Baton Freecon Kit with Sands Traffic light Net Barrier Tape Water Rescue Water Rescue Vest Wallether wildtreet Full Helmet Firetroces Water Throw Bag Orytas 53 18 19 25 17 11 87 28 29 35 47 19 15 25 510 do 545 Radio $20 Radio $25 Radio $320 B 5140 Boots $109 Boots $169 Boots $129 Boots $149 Boots $89 Gloves 5124 Gloves $72 $39 Gloves 5223 Cout 519 Pants $359 Coveralls $259 Safety $35 Safety $369Safety 5159 Coveralls $13 Safety 552 Boots $89 Boots $99 Safety $229 Helmet $179 Helmet 5339 Shield $29 Megaphone 512 Tape 5649 Pants 5989 Cou $1.299 Coat $1,059 Pants 535 Safety $32 Gloves $199 Safety 593 Safety $399 Coat $289 Pants $29 Vest $17 Vest $29 Vest $11 Vest $289 Siren $189 Siren 59 9 Slought $9 Light $18 UM $15 Tape 511 Vest $119 Safety 599 Sety $50 Safety $59 Helmet $59 Helmet 549 Helmet $59 Safety 518 Safety Commation Comitation Comownication Communication Footwear Foster Footer Foot Footwear Foot Outwe Outerwear Extrication Gear Outerwe Extrication Gear Extrication Gear Dutcabine Safety Equipment Safety Equement Safety Equipment Outerwear Safety Equipment Footwear Footwe Safety Equipment Outerwe Duterwear Safety Equipment Communication Tratti Outerwear Outerwear Outerwear Outerwear Safety Fouiment Outerwear Safety Equipment Safety Equipment Outerwear Outerwe Outerwe Outerwear Outerwear Outerwear Tratli Trac Traffic Tradic Trafic Trafic Trafic Outerwear Water Rescue Water Rescue Water Rescue Outerwear Outerwear Safety foment Water Rescue Water Rescue Ded Order Le OK Order Order Order Order Order Order Leveo Order Order Live OK Order Order Order Order Level OK Level OK Order Order Order Level Ok Level OK Order Level OK Order Order Lewik Order Order Order Order Order Order Onder Order Order Order Order Order Order Order Order Order Onge Order Order Order Order Order order Order Order Level OK Order Order Order Order Deder 2,348 69) 1,326 3,791 7,646 3,949 2,331 315 4,797 3,021 585 520 890 5.641 2,290 9,137 8,475 632 636 15.482 18,791 42 43 44 35 46 47 40 10 50 51 52 $3 H 55 27 37 90 26 56 89 17 18,001 385 2,784 5,572 2.871 11,965 13.583 2.581 255 725 979 4,624 3,591 513 11,265 8,910 465 840 979 2,023 1,762 236 1,062 1.001 2.542 1.329 576 32,475 57 56 39 60 51 52 1 4 18 17 sa 31 12 N 10 3 18 4 6 13 15 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 Safely worksheet, and create a new worksheet at the end with the name Order. On the Safety worksheet convert the table to a normal range. 6 12 12 8 8 9 12 G47 Xfx247*C47 A H D Emergency Equipment Inventory 1 - 5 $ 7 53 40 5 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 23 29 30 31 32 3 34 35 36 37 35 39 40 41 20 21 26 27 28 10 25 27 9 34 17 14 11 9 9 13 19 Coil Headphones Radio Strap/Holder Retractable Mic keep Leather Radio Holder 10 Zipper Boots tescher Fire Boots Rubber lug Boot Rubber Fire Boots Rubber Bunker Boots Hamabot Fire Gloves Proximity Gear Gloves Extrication Gloves Rescue Glovers Extrication Court brication Pants trication Covers Gas Mask Gas Mask Pouch Respirator Coverall with Hood Disaster Safe Bag Chemical Overboot Has Mat Boots Disaster Kit Helmet Structural Fire Helmet Helmet with Eye Shield Megaphone Barrier Tape FirePants Fire Coat Proximity Com Proximity Pants Radio Chest Harnesi Rope Gloves Safety Harness Oestress TMS Jacket en Pants Breakaway Vest Met Vest Mesh ratives Reflective Nylon Vet Handheld Remote Siren Siren Tractaton Flanellacon Kit nes with Stands Trac Flashlight Night Barrier Tape Wit Resuelt Water Rescue Vest Water Tether System Wildfire Full Brimet 10 10 57 10 51 25 $30 Radio $45 Radio $20 Radio $25 Radio $320 Boots $340 Boots $105 Boots $169 Boots $129 Boots $149 Boots $89 Gloves $124 Gloves 577 Gloves $39 Gloves $223 Coat $189 Pants $359 Coveralls $259 Safety $35 Safety $369/safety $159 Cover $13 Safety $52 Boots $89 Boots 309 Sety $229 Helmet $179 Helmet $339 Shield $79 Megaphone $12 Tape $649 Pants $989 Coat $1,299 Coat $1,059 Pants Safety $32 Gloves $199 Safety $99 Safety $399 Coat $289 Pants $29 Vest 517 Vest $20 Vest $11 Ves $289 Siren $189 Siren 519 | | | $305 Light $99 Light $10 Light $15 Tape Si Vest $119 Safety 599 Say 559 y 559 Homes 559 Helmet $49 Helmet 559 Safety Si Safety 8 Communication Communication Communication Communication Footwear Footwear Footwear Footwear rostwear Footwear Outerwear Outerwear Extrication Gear Outerwear Erication Ger Extrication Gear Extrication Gear Safety Bopment Safety Equipment Safety Equipment Outerwear Safety Equipment Footwear Footwear Safety Equipment Outerwear Outerwear Safety Equipment Communication Trac Outerwear Outerwear Outerwear Outerwe Safety Equipment Outerwow Safety Equiment Safety figment Outerwear Outerwear Outerwear Outerwear Outerwe Outerwear Tratt Traffic Teatre Trafic Traffic tratti Trate Outerwear Water Rescue Water Rescue Water Rescue Outerwear Outerwear Safety Equipment Water Rescue Wat Rescue 1,589 1.800 60 1,095 6,400 7,140 2.834 4.563 3.632 1.490 2,225 3,348 691 1,326 3,791 2,646 3,949 2,331 315 4,797 3,021 585 520 890 5,603 2.290 9,129 8.475 32 636 11,682 18,791 32.475 18,003 385 Order Order Led 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 Live OK Order Order Level OK Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Order Dider Order Order Order Level OK Order Order Order Order Order 18 19 25 17 11 57 28 29 35 47 89 2.754 64 147 50 51 54 SS 56 57 58 59 60 SAN & BABE 5,572 2.871 13,965 13.583 2.581 255 725 979 4.624 3,591 513 11,255 8,910 468 340 979 2.023 3,752 236 1,062 1,003 2,342 1,829 578 26 56 69 17 OSOBO Water Throw Dry Bag 31 32