In cell D$7$ of the Orders worksheet, calculate the total value of the item $($price multiplied by quantity$).$ Copy the formula into cells D$8$:D$11.$

In cell D$14$ of the Orders worksheet, calculate the total cost of the order.

In cell D$15$ of the Orders worksheet, calculate the total shipping charge for this order based on three variables: the ship$-$to region, the total weight, and the method of shipping.

a$.$ HINT: This will require a HLOOKUP and cells $C2,C3,$ and $C4$ to retrieve the answer. For the rownumber argument of the HLOOKUP, use $C3+1$

In cell D$16$ of the Orders worksheet, calculate the handling cost. Be certa$$n to account for the maximum handling charge. Handling fees are based on the total order value excluding shipping and discounts.

a$.$ HINT: The HLOOKUP will need to have the fourth argument be True for the approximate match.

In cell D$17$ of the Orders worksheet, calculate the discount. Be certain to write the formula so that the discount is deducted from the total amount when all values are added $($should be a negative number$).$ Discounts are based on the total order value excluding shipping and handling fees.

In cell D$19$ of the Orders worksheet, calculate the grand total for the order.