can i get help on questions 6-10 please?
Time Dames M N 1 Car Rental Analysis Express Car Rental Het Werk starting // Created by son tanto 1 4 Are G Option Cost of Gas All C Part Method Average tal Cost Tota Cou COM awards DOM Credit Card case N SMAS $2.43 $43.9 $2492 SA Ano Daily Rate our SASSI $76.49 5746 $49.99 $499 $10 $104.99 584 54999 525.41 Godead Candi Y Naber N S N N Date Hettede Payment Atos Danted Expediented Method 4/5/2002 1/2002 3 Credit Card 225 4/9/2023 1/10/2032 5 ca 277 WW2023 4102022 1 Express Miles 90 4/9/2022 W202 1 Credit Card 150 4/3/2002 4/2002 3 Credit Card so 4/5/2002 4/2002 4 Rewards 503 4/3/2003 4/10/2012 1 Credit Card 352 2022 4/2007 2 Credit Card 19 4/2002 2022 3 Credit Card 11/2032 4/11/2022 > Cash 155 4/9/2022 4/10/2017 Credit Card 4/6/2002 w2032 2 DOCard 4/1/2002 1/2002 4 Rewards 551 1/8/2017 w/14/2003 Es Mes 550 4/11/10 4/17/2002 6 W2022 1/15/2002 6 Credit Card 589 A/10/2022 4/10/2020 . Express Miles 990 4/7/2017 1/10/2002 3 Creo and 43/2002 4/30/2002 1 Rewards 558 4/2002 41522 554 4/2/2017 W2022 2 Exis 4/10/2002 4/11/2023 1 Credit Card 156 11/20 19/2022 EM 274 1/7022 4/14/2002 3 Cred card 272 w2033 /25/2002 . Rewards 554 4/10/2017 4/12/2002 2 Chih 4/11/2002 4/1/2002 17 Express Air Type Green Collection Compact/Midsure Compact/M Green Collection 10 standard 1 SUV/Minn 10. SUV/Miran 13 air/Standart 14 Green Collection 15 Compact Me 16 Fulltandard 17 Pullside/Standard tutte/Standard 18 SUV/ Min SUM 21 Green Collection Green Collection con Collection 24 strestandart 25 SUV/ 20 SUV/M AT T/standard 2 Putgestanden 29 Compact/ 1 Compact/Middle SUV/M 12 Green Collection 21 $35.41 13 $10 $ 55. SH SIM SO . Y Y 944 52 $143) $19. Y SU SI SH 34 SA 5 SI 3199 S. 09:31 SH SO 32147 5. $200 1933 N Y Rentals 6 In cell H6, enter a formula to determine any discount that should be applied. If the payme method in column F was Rewards, the customer should receive the discount shown in B42, otherwise the formula should return a zero. Use the named range for cell B42, not the cell address, in this formula Copy the formula through cell range H7:H32. 7 In cell J6, enter a formula to determine the cost of gas. If the value in column I is "Y", then assign the cost of gas in B44, or else the formula should return zero. Use the named range for cell B44 in this formula, not the cell reference. Copy the formula through cell range J7:432 8 In cell N11, use the appropriate function to count the number of rentals in the data, using the data in column A. Counter 9 In cell N6, determine the total number of times the criteria "Rewards" in cell M6 is used. Use absolute referencing so you can copy the formula through cell N9. 10 In cell Q6, enter a formula to determine the average total cost based on the payment method type in cell P6. Use absolute references where necessary to copy the formula through cell 09. 1 YO19_Excel_CH03_Assessme ated On: 12/14/2019 Forint Data Review View Help fx 2 Incert Function 2 A @ AutoSum Recently funcil tagit fert Date & Lookup a Math & More Na Used- Time Rderende functions Manag functionary 16 - > E 4 2 1 8 551 50 352 156 275 27 554 90 4/11/2002 72/2022 /10/2002 4/11/2022 V11/2002 4112022 4/2002 4/11/2002 D 4/5/2002 4/1/2022 4/11/2022 4/17/2002 4/10/2002 5/15/2002 4/12/2002 4/25/2022 Express Miles Express Miles Credit Card Express Miles Credit Card Rewards Cash Express Miles 3 4 12 2. 7 25 SUV/Minivan 26 SUV/Minivan 27 Fullsize/Standard 20 Fulle/Standard 29 Compact/Midsize 30 Compact/Midsize 31 SUV/Minivan 12 Green Collection 33 34 35 36 Rental Rules 37 Green Collection 33 Compact/Midi 20 Folie/Standard 20 SUV/Minivan 41 Discount for press Mietwa 549.99 S. SBL Costa S. sto 4 50 Tieto O
