Please answer the below questions in details showing the necessary instructions on how to carry out the operation with excel functions, formula, and calculations.

A B C D Shipment Cargo Type Cost of Shipment Semifragile $7.00 2 Durable $2.00 3 Fragile $13.80 4 Fragile $11.10 5 Semifragile $10.00 6 Fragile $17.20 7 Semifragile $11.50 8 Semifragile $6.50 O 9 Semifragile $8.50 10 Durable $2.10 2 11 Fragile $10.90 12 Fragile $12.00 4 13 Durable $7.50 .5 14 Durable $3.40 6 15 Durable $1.30 8 9 10