Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help with all of these X V fx =IF(OR(F6=Express Miles,F6=Rewards),$E$12,0) Date Returned/or Expected Return Amount of punt Gas Option Autold Date Rented Daily Rate

image text in transcribed
image text in transcribed
need help with all of these
X V fx =IF(OR(F6="Express Miles",F6="Rewards"),$E$12,0) Date Returned/or Expected Return Amount of punt Gas Option Autold Date Rented Daily Rate Cost of Gas Total Cost 27 4/9/17 4/5/17 4/10/17 4/10/27 4/5/17 42 4/5/27 4/10/27 4/9/17 4/9/17 SNO 41 4/7/17 4/1/17 Oays Rented Payment Method Credit Card COD Express Miles Credit Card Credit Card Rewards Credit Card Credit Card Credit Card COD Credit Card Credit Card 27 4/11/27 4/26/17 4/8/17 4/13/2) 5 Auto Type 6 Green Collection 7 Compact/Midia Compact Midsize s Green Collection 10 Fullm/Standard 11 SUV/Minivan 12 SUV/Minivan 13 Fullsize/Standard 34 Green Collection Is Compact/Midsize 36 Pus/Standard 17 Fullsize/Standard 18 F /Standard 19 SUN Minivan 20 Sun M an 21 Green Collection 22 Green Collection 23 Green Collection 24 Standard SUV/ M van 26 SUV/Minivan Full Standard F /Standard Compact M e Compact M e SUN/M van GreenCoin $104 SI 5499 41 4/10/17 4/7/27 4/27/27 4/25/27 4/16/17 4/10/17 COD Credit Card Express Miles Credit Card $49.90 SA 4/25/27 $1045 $104, 4/1/17 4/10/17 Express Miles Express Me Credit Card Express Miles Credit Card Rewards COD 525.4 4/21/17 4/11/17 4/10/17 4/14/27 4/25/27 4/12/17 $104 $49 54 36 Rental Rates 37 Green C on 3 Compact/Midae 39 Pistandard 40 SUV/Minivas $26.49 584 SOL Discount for Express Milles or 45 Median Rental length 47 Number of Rentals RentalData Client Data + Average: $1.22 Count: 27 Sum: $33.00 - 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 L. 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. 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 K7:K32 9 In cell B46, use the appropriate function to calculate the median length of rental in days. 10 In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing In An Internet Of Things Environment

Authors: Robert R. Moeller

1st Edition

1119461669, 978-1119461661

More Books

Students also viewed these Accounting questions