Complete the following:

$1.$ Open the workbook named Module $2-$ Golf.xlsx and then save the file as GolfOrders$($your last name$).$xlsx$.$

$2.$ Examine the contents of each worksheet, and name the ranges listed in the table below. Use these range names as appropriate in Questions $3$ through $9.$

Range Name Worksheet Cells

ItemPrice Costs A$5$:C$20$

HandlingFee Handling B$2$:G$3$

Disc Discounts A$2$:A$5$

TotOrderVal Discounts B$2$:B$5$

$3.$ In cell C$7$ of the Orders worksheet, write a formula that displays the product description from the Costs sheet for the first item in the order. Copy the formula into cells C$8$:C$11.$

$4.$ 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.$

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

$6.$ 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 C$2,$ C$3,$ and C$4$ to retrieve the answer. For the rownumber argument of the HLOOKUP, use C$3+1$

$7.$ In cell D$16$ of the Orders worksheet, calculate the handling cost. Be certain 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.

$8.$ 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.

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