Convert the accompanying database to an Excel table to find

Last updated: 6/27/2023

Convert the accompanying database to an Excel table to find a The total cost of all orders b The total quantity of airframe fasteners purchased c The total cost of all orders placed with Manley Valve Click the icon to view the database a The total cost of all orders is 652 440 5 b The total quantity of airframe fasteners purchased is airframe fasteners 1 2 Hulkey Fasteners 3 Alum Sheeting 4 Manley Valve 5 Fast hyphen Tie Aerospace 6 Fast hyphen Tie Aerospace 7 Steelpin Inc 8 Fast hyphen Tie Aerospace 9 Manley Valve 10 Steelpin Inc 11 Durrable Products 12 Fast hyphen Tie Aerospace 13 Fast hyphen Tie Aerospace 14 Steelpin Inc Supplier 15 Hulkey Fasteners 16 Manley Valve 17 Hulkey Fasteners 18 Steelpin Inc 19 Steelpin Inc 20 Alum Sheeting 21 Hulkey Fasteners B Item Description Airframe fasteners Airframe fasteners Hatch Decal Shielded Cable ft Shielded Cable ft Shielded Cable ft Shielded Cable ft Machined Valve Bolt nut package Pressure Gauge O Ring Shielded Cable ft Shielded Cable ft Electrical Connector Pressure Gauge Hatch Decal Electrical Connector Bolt nut package Control Panel Electrical Ca Item Cost 4 25 3 75 1 05 1 05 1 05 1 1 1 05 655 5 3 75 90 2 45 1 05 1 1 25 100 5 0 75 1 65 3 75 255 D E Quantity Cost per order 82875 45000 588 24150 24675 19250 24675 81937 5 15937 5 19500 12000 560 23000 23500 17500 23500 125 4250 100 1300 22500 18200 5600 80 600 4500 4200 506 9000 3185 23625 18200 7000 8040 450 7425 15750 129030