$3\mathrm{.}3$ Use the VLOOKUP function in cell G$3$ to calculate the delivery price for order $1.$

a$.$ The delivery price can be referenced on the "Delivery Information" lookup table.

b$.$ Use appropriate relative and absolute cell references.

$3\mathrm{.}4$ Copy your formula in cell and paste it down to complete the "Delivery" column of the table.

$(1)$

$3\mathrm{.}5$ Use the HLOOKUP function in cell $H3$ to calculate the product pricing based on the color and quantity of the billboards ordered.

a$.$ Product pricing can be referenced on the "Product Pricing" lookup table $($range P$3$:Q$12).$

b$.$ Use appropriate relative and absolute cell references.

c$.$ Note the third argument