The table on the Lookup Functions worksheet shows $25$ recent sales. Each order lists the color of the boards ordered, the number to be shipped with the order, and the distance of the delivery in miles.

Complete the table by using the VLOOKUP and HLOOKUP functions in Excel to calculate the number of days it will take for delivery, the delivery price, and the price of the signs for each order.

$3\mathrm{.}1$

Use the VLOOKUP function in cell F$3$ to determine the number of days it will take to ship order $1.$

Use the distance in cell E$3$ to lookup the appropriate value on the "Delivery Information" reference table $($range K$4$:M$9).$

Use relative and absolute references appropriately.