On the RentalData worksheet, in cell E$6,$ enter a date formula to determine the length of rental in days. Copy this formula to the range E$7$:E$32.$

Assigned a named range of RentalRates to cells A$37$:B$40.$

In cell G$6,$ use the appropriate lookup and reference function to retrieve the rental rate from the named range RentalRates. The function should look for an exact matching value from column $A$ in the data. Copy the function down the column to cell G$32.$

Assign a $$amed range of Discount to cell B$42$ and a named range of GasCost to cell B$44.$

In cell H$6,$ enter a formula to determine any discount that should be applied. If the payment method was Express Miles or Rewards, the customer should receive the discount showm in $B42.$ If no discount should be applied, the formula should return a zero. Use the named range for cell B$42,$ not the cell address, in this formula. Copy the formula to the range $H7$:$H32.$

In cell J$6,$ enter a formula to determine the cost of gas if the customer chose that option as indicated in column I. If the customer did not choose the option, then the formula should return zero. Use the named range for cell B$44$ in this formula. Copy the formula to the range J$7$:J$32.$

In cell $K6,$ enter a formula to determine the total cost of the rental based on the daily rate, the number of days rented, the cost of gas, and any discount given to the customer. Note that the discount applies only to the car rental, not the cost of gas. Copy the formula to the range K$7$:K$32.$

In cell B$46,$ use the appropriate function to calculate the median length of rental in days.

In cell B$47,$ use the appropriate function to count the number of rentals in the data, using the data in column $A.$