question 4

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 \$ b. The total quantity of airframe fasteners purchased is airframe fasteners. c. The total cost of all orders placed with Manley Valve is \$ \begin{tabular}{|c|c|c|c|c|c|} \hline 3 & Alum Sheeting & Airframe fasteners & 3.75 & 13000 & 48750 \\ \hline 4 & Manley Valve & Hatch Decal & 1.05 & 570 & 598.5 \\ \hline 5 & Fast\‐Tie Aerospace & Shielded Cable/ft. & 1.05 & 23000 & 24150 \\ \hline 6 & Fast\‐Tie Aerospace & Shielded Cable/ft. & 1.05 & 21500 & 22575 \\ \hline 7 & Steelpin Inc. & Shielded Cable/ft. & 1.1 & 17500 & 19250 \\ \hline 8 & Fast \& hyphen;Tie Aerospace & Shielded Cable/ft. & 1.05 & 24500 & 25725 \\ \hline 9 & Manley Valve & Machined Valve & 655.5 & 125 & 81937.5 \\ \hline 10 & Steelpin Inc. & Bolt-nut package & 3.75 & 4250 & 15937.5 \\ \hline 11 & Durrable Products & Pressure Gauge & 80 & 100 & 8000 \\ \hline 12 & Fast \& hyphen;Tie Aerospace & O-Ring & 2.45 & 1300 & 3185 \\ \hline 13 & Fast\‐Tie Aerospace & Shielded Cable/ft. & 1.05 & 22500 & 23625 \\ \hline 14 & Steelpin Inc. & Shielded Cable/ft. & 1 & 18400 & 18400 \\ \hline 15 & Hulkey Fasteners & Electrical Connector & 1.25 & 5600 & 7000 \\ \hline 16 & 5 Manley Valve & Pressure Gauge & 100.5 & 70 & 7035 \\ \hline 17 & 7 Hulkey Fasteners & Hatch Decal & 0.75 & 500 & 375 \\ \hline 18 & 3 Steelpin Inc. & Electrical Connector & 1.65 & 4500 & 7425 \\ \hline 19 & Steelpin Inc. & Bolt-nut package & 3.75 & 4200 & 15750 \\ \hline 20 & Alum Sheeting & Control Panel & 255 & 606 & 154530 \\ \hline 21 & 1 Hulkey Fasteners & Electrical Connector & 1.25 & 5500 & 6875 \\ \hline 22 & 2 Steelpin inc. & Electrical Connector & 1.65 & 4850 & 8002.5 \\ \hline 23 & 3 Steelpin Inc. & Bolt-nut package & 3.75 & 4150 & 15562.5 \\ \hline 24 & 4 Manley Valve & O-Ring & 3.75 & 1400 & 5250 \\ \hline 25 & 5 Hulkey Fasteners & Airframe fasteners & 4.25 & 18500 & 78625 \\ \hline \end{tabular}