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.

Transcribed Image Text:

Database Supplier Hulkey Fasteners Alum Sheeting Manley Valve Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Fast-Tie Aerospace Manley Valve Steelpin Inc. Durrable Products Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Hulkey Fasteners Manley Valve Hulkey Fasteners Steelpin Inc. Steelpin Inc. Alum Sheeting Hulkey Fasteners Steelpin Inc. Steelpin Inc. Manley Valve Hulkey Fasteners 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 Connector Electrical Connector Bolt-nut package O-Ring Airframe fasteners Item Cost $4.25 $3.75 $1.10 $1.05 $1.05 $1.10 $1.05 $655.50 $3.75 $80.00 $2.45 $1.05 Quantity Cost per order 19,500 $82,875.00 12,000 $45,000.00 570 $627.00 23,000 22,500 17,500 22,500 $0.75 $1.65 $3.75 $255.00 $1.25 $1.65 $3.75 $2.85 $4.25 125 4,250 100 1,300 22,500 18,400 5,600 $1.00 $1.25 $100.50 70 700 4,500 4,200 706 5,500 4,850 4,150 1400 18,500 $24,150.00 $23,625.00 $19,250.00 $23,625.00 $81,937.50 $15,937.50 $8,000.00 $3,185.00 $23,625.00 $18,400.00 $7,000.00 $7,035.00 $525.00 $7,425.00 $15,750.00 $180,030.00 $6,875.00 $8,002.50 $15,562.50 $3,990.00 $78,625.00 Database Supplier Hulkey Fasteners Alum Sheeting Manley Valve Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Fast-Tie Aerospace Manley Valve Steelpin Inc. Durrable Products Fast-Tie Aerospace Fast-Tie Aerospace Steelpin Inc. Hulkey Fasteners Manley Valve Hulkey Fasteners Steelpin Inc. Steelpin Inc. Alum Sheeting Hulkey Fasteners Steelpin Inc. Steelpin Inc. Manley Valve Hulkey Fasteners 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 Connector Electrical Connector Bolt-nut package O-Ring Airframe fasteners Item Cost $4.25 $3.75 $1.10 $1.05 $1.05 $1.10 $1.05 $655.50 $3.75 $80.00 $2.45 $1.05 Quantity Cost per order 19,500 $82,875.00 12,000 $45,000.00 570 $627.00 23,000 22,500 17,500 22,500 $0.75 $1.65 $3.75 $255.00 $1.25 $1.65 $3.75 $2.85 $4.25 125 4,250 100 1,300 22,500 18,400 5,600 $1.00 $1.25 $100.50 70 700 4,500 4,200 706 5,500 4,850 4,150 1400 18,500 $24,150.00 $23,625.00 $19,250.00 $23,625.00 $81,937.50 $15,937.50 $8,000.00 $3,185.00 $23,625.00 $18,400.00 $7,000.00 $7,035.00 $525.00 $7,425.00 $15,750.00 $180,030.00 $6,875.00 $8,002.50 $15,562.50 $3,990.00 $78,625.00

Answer rating: 100% (QA)

Converting a database into excel table supplier item description item cost quantity cost per order h... View the full answer