a. Open the Order Form Workbook

b. Name the range A4:D7 Catalog

c. Use the Vlookup function to return the appropriate values in the code cell, weight cell, and price per unit cell. (HINT: Your formula should use an absolute value/reference)

d. Insert a formula that calculates total cost per items ordered.

e. Insert a formula that calculates the sub total for the order before taxes and shipping.

f. Insert a formula that calculates the tax on the order.

g. Use an if function to determine the shipping cost charged to the order. A44:B45 contain the information for creating the formula.

h. Insert a formula that totals the entire order.

i. Save your workbook.