please solve formulas :)

1 1 3 When shipping products two major costs are incurred: the cost of insuring the item and the actual freight cost. Insurance is dependent on the value of the shipment. Quickstove has an agreement with shippers for a foed rate that is determined by destination state and service level (regular, express or overnite) Task # Points Task Description Use the VLOOKUP function in cell G1 to determine the insurance cost. Use the value in cell E11 to fookup the appropriate cost on the Insurance Cost reference table (range K11:18). Make sure to use relative and absolute references appropriately 3 Copy your formula in cell G11 and paste it down to complete the insurance Cost column of the table. Use the HLOOKUP function in cell H11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced 6 on the "Freight Cost lookup table range ES:NB) Be sure to use appropriate relative and absolute cell references: Hint: You will need to use a function within the HLOOKUP function to determine the appropriate row. Copy your formula in collit and paste it down to complete the "Freight Cost" column Calculate the Invoice "Shipping Total incl 111 Copy your formed in coll 111 and paste it down to complete the shipping Total" column 2 3 3 4 3 5 2 6 1 F G M N A 8 D 1 2 When shipping products two major costs are incurred; the cost of 3 Insuring the item and the actual freight cost. Insurance is dependent 4 on the value of the shipment 5 Quickstove has an agreement with shippers for a fixed rate that is 6 determined by destination state and service level regular express or Regular 7 overnite) Express 8 Overnite 9 S $ $ AZ WA 5.00 S 6.00 S 7.00 S 8:40 5 11.60 5 13.70 S Freight Cost NV UT CA MT OR CO HI 5.00 S 3.00 S 5.00 S 6.00 $ 6.00 S 5.00 S 8.00 7.60 $ 4.70 S 7.60 S 8.40 S 8.40 S 7.60 S 13.50 1160 S 7.80 S 11.60 S 13.70 5 13.70 $ 11,60 $ 17.10 10 OrderID Ship To Productid Product Name Value Shipping Insurance Class Cost Freight Cost Shipping Total Insurance Cost 11 12 13 14 15 16 AZ WA NV UT Uus MI OR 1003 1004 1007 1011 1027 1041 1042 1050 1058 1050 1060 1062 1073 1074 1088 1094 1100 Shipment Insurance Value Cost - $ 0.50 10 S 1.00 30$ 2.00 50 S 2.50 5 100 5 3.00 s 200 S 4.00 S 000 $ 5.00 233555565358833 ======= 100 QuickStove 100 QuickStow 100 Quickstove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stowe Can 102 Replacement Fuel Cell 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells $68.80 Express S 86.00 Express $ 120,39 Regular $ 120,39 Express $ 17.55 Overnite S 4.00 Overnite $69.98 Overite 5274.12 Overite $ 274.32 Express $15.68 Regular S69.98 Overite S60.80 Regular $34.99 Overnite 519.60 Overnite S4,00 Overite $ 8.00 Express 53.00 Express WA 24 WA F G H A A OR 6.5 SSE255 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 1120 1255 1262 1265 1267 1268 1364 1417 1629 1635 1661 1666 1677 1686 1701 1708 1712 1718 1720 1725 1733 1746 1748 1776 1797 1814 1834 1835 1839 OR UT WA CA MT AZ UT CA AZ OR WA CA CO AZ AZ OR UT WA CA CO NV MT WA AZ CA CA D 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 108 QuickStove Fuel Disk 101 QuickStove Can 101 QuickStove Can 101 QuickStove Can 108 QuickStove Fuel Disk 101 QuickStove Con 101 QuickStove Can 101 QuickStove Can 110 Firebox Bundle 110 Firebox Bundle 101 QuickStove Can 101 QuickStove Con 114 Cube Stove + 2 Fuel Disks 114 Cube Stove + 2 Fuel Disks 113 Firebox Stove w/ Fuel 113 Firebox Stove w/ Fuel 114 Cube Stove + 2 Fuel Disks E $ 38,00 Express $34.99 Overnite $ 102.87 Regular $ 34.99 Express $ 102.87 Overnite $34.99 Regular $ 398.89 Regular $ 37.85 Overnite $ 10.00 Express $ 69.98 Express $ 47.50 Regular $ 19.60 Express $ 31.54 Express $19.95 Overnite $19.95 Overnite $19.95 Overnite $ 47.31 Express $39.90 Overnite $ 78.20 Overnite $ 78.20 Express $ 175.50 Regular $ 87.75 Express $ 78.20 Overnite $ 78.20 Overnite $ 49.90 Express $ 24.95 Regular $49.95 Overnite $ 49.95 Overnite $ 49.90 Express $582ESSSS