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 Q9.
Share fx *2 A IRO hecking - Go M R Total Cost 0% S R Currency Wolfe_Excel_Ch03_Assessment_CarRental - Excel Breann Wolfe File Home Insert Page Layout Formulas Data Review View Help QuickBooks Tell me what you want to do e Define Name - - Trace Precedents F Show Formulas Calculate Now Fx Use in Formula - Trace Dependents V Error Checking Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Watch Calculation Function Calculate Sheet - Used - Trig Functions Remove Arrows - me Reference Manager Create from Selection Evaluate Formula Window Options Function Library Defined Names Formula Auditing Calculation Q6 : fic I F G H I J K L Average Date Returned/or Payment Amount of Gas Cost of Total Analysis Payment Analysis Total 5 Date Rented Expected Return #Days Rented Method Daily Rate Discount Option Gas Cost Criteria Method Critieria Cost 6 4/5/2022 4/8/2022 3 Credit Card $49.99 0% N $0.00 $149.97 Rewards Rewards 7 4/5/2022 4/10/2022 5 Cash $76.49 0% N $0.00 $382.45 Express Miles Express Miles 4/9/2022 4/10/2022 1 Express Miles $76.49 N. $0.00 $76.49 Credit Card 12 Credit Card 4/5/2022 4/6/2022 1 Credit Card $49.99 0% N $0.00 $49.99 Cash Cash 4/5/2022 4/8/2022 3 Credit Card $84.99 0% $75.00 $329.97 4/5/2022 4/9/2022 Rewards $104.99 20% $75.00 $410.97 Number of Rentals 27 4/7/2022 4/10/2022 Credit Card $104.99 $0.00 $314.97 13 4/7/2022 4/9/2022 2 Credit Card $84.99 0% $75.00 $244.98 4/6/2022 4/9/2022 3 Credit Card $49.99 0% N $0.00 $149.97 4/11/2022 4/18/2022 Cash $76.49 0% N $0.00 $535.43 4/9/2022 4/16/2022 Credit Card $84.99 0% $75.00 $669.93 17 4/6/2022 4/8/2022 2 Credit Card $84.99 0% Y $75.00 $244.98 4/9/2022 4/13/2022 4 Rewards $84.99 $75.00 $346.97 19 4/8/2022 4/14/2022 Express Miles $104.99 0% $75.00 $704.94 4/11/2022 4/17/2022 Cash $104.99 0% $75.00 $704.94 21 4/9/2022 4/15/2022 6 Credit Card $49.99 0% N $0.00 $299.94 22 4/10/2022 4/16/2022 Express Miles $49.99 N $0.00 $299.94 4/7/2022 4/10/2022 3 Credit Card $49.99 0% N $0.00 $149.97 24 4/9/2022 4/10/2022 1 Rewards $84.99 20% N $0.00 $67.99 25 4/11/2022 4/15/2022 Express Miles $104.99 0% $75.00 $494.96 RentalData ClientData Enter @ J - 0% N Y 1 1 20% 6 0% 23 - + 100% Type here to search 11:27 PM 9/20/2019 R Currency Wolfe_Excel_Ch03_Assessment_CarRental - Excel Breann Wolfe S File Share fx Home Insert Page Layout Formulas Data Review View Help QuickBooks Tell me what you want to do e Define Name - - Trace Precedents F Show Formulas Fx Use in Formula - Trace Dependents V Error Checking AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name - Used - Time Reference Trig Functions Manager Create from Selection Remove Arrows - Evaluate Formula Function Library Defined Names Formula Auditing *2 A IRO Calculate Now hecking - Go Insert Function Watch Window Calculation Calculate Sheet Options Calculation 06 M N O P Q R 26 2 1 27 28 0% 0% 0% 4/7/2022 4/10/2022 4/11/2022 4/11/2022 4/11/2022 4/10/2022 4/11/2022 4/9/2022 4/11/2022 4/17/2022 4/14/2022 4/15/2022 4/12/2022 4/18/2022 F Express Miles Credit Card Express Miles Credit Card Rewards Cash Express Miles $104.99 $84.99 $84.99 $76.49 $76.49 $104.99 $49.99 6 3 4 2 7 Y Y Y N N 0% K $284.98 $159.99 $584.94 $229.47 $244.77 $284.98 $349.93 $75.00 $75.00 $75.00 $0.00 $0.00 $75.00 $0.00 30 20% 31 0% 32 0% N RentalData ClientData Enter @ J - - + 100% Type here to search 11:28 PM 9/20/2019
