In cell H6, 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 shown in B42. If no discount should be applied, the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula. Copy the formula to the range H7:H32. In cell J6, 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 B44 in this formula. Copy the formula to the range J7:J32. 7 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 K7:K32. 8. car rental, not the cost of gas. Copy the formula to the range In cell B46, use the appropriate function to calculate the median length of rental in days. In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A. 10 th TE v fx H6 =IF(OR(F6="Express Miles",F6="Rewards"),$E$12,0) Date Returned/or Amount of S Auto Type 6 Green Collection Auto ld Date Rented Expected Return Days Rented Payment Method Daily Rate Discount Gas Option Cost of Gas Total Cost 988 4/5/17 4/5/17 4/8/17 Credit Card $49.99 S 7Compact/Midsize 8 Compact/Midsiae 275 4/10/17 4/10/17 COD $76.4 S $76.4S $49.9S S84.9S $104.99S $104 9S 277 4/9/17 4/5/17 Express Miles 3.00 9Green Coliection 10 Fulsize/Standard 11 SUV/Minivan 12 SUV/Minivan 13 Fulsian/Standard 14 Green Collection 15 Compact/Midsize 990 4/6/17 Credit Card 350 4/S/17 4/8/17 4/9/17 Credit Card S50 4//17 4. Rewards 3.00 551 4/7/17 4/7/17 4/10/17 Credit Card 352 4/9/17 2. Credit Card S89 4/6/17 4/9/17 Credit Card $49.99$ $76.4 S84 s SaS S84.95S 275 4/11/17 16 Fulsae/Standard 17 Fulsise/Standard 1Fulsiae/Standard 19 SUV/Minivan 4/18/17 4/16/17 4//17 4/11/17 355 4/9/17 Credit Card a56 4/6/17 Credit Card 350 4/5/17 Rewards 3.00 S53 4//17 4/14/17 4/17/17 Express Mies $104.9S 3.00 20 SUV/Minivan 21 Green Collection 22 Green Colection S50 4/11/17 4/9/17 COo $104.9S S88 4/15/17 4/16/17 4/10/17 Credit Card $49.99S $49.9S 4/10/17 Express Miles 3.00 23 Green Collection 24 Fullsian/Standard 25 SUV/Minivan 26 SUN /Minivan 27 Fulisian/Standard 25 Fulisiae/Standard 29 Compact/Midsiae 990 4/7/17 Credit Card 356 4/9/17 4/20/17 Rewards S84.9S $104.9S $104.95 3.00 S51 4/11/17 4/15/17 Express Miles 1.00 S54 4/17 2. Express Miles 3.00 352 4/20/27 4/11/17 Credit Card S84.9S 356 4/11/17 4/17/17 4/14/17 Express Miles 1.00 276 4/11/17 Credt Card 30 Compact/Midsian 21 SUV/Minivan 32 Green Callecion $76.4S S76.4S $10495 277 4/11/17 4/15/17 Aewards 4. 3.00 s54 4/20/17 14/11/17 4/22/17 Coo 990 4/18/17 Express Miles 3.00 33 34 35 36 Rental Rates 37 Green Colliection 38 Compac/Midsise 29 Fulisia/standard 40 SUN/Minivan S45.99 S7549 $30499 41 Diucount for Espress Miles or 42 Rewards 20% 44 Cost to Fil Tan 45 Medan Rental Lengsh 47 Number af Rentals 48 RentalData ClientData Average: $1.22 Count: 27 Sum: $33.00 77%