Express Car Rental
Jason Easton is a member of the support/decision team for the San Diego branch of Express Car Rental. He created a worksheet to keep track of weekly rentals in an attempt to identify trends in choices of rental vehicles, length of rental, and payment method. This spreadsheet is designed only for Jason and his supervisor to try and find weekly trends and possibly use this information when marketing and forecasting the type of cars needed on site. The data for the dates of rental, daily rates, payment method, and gas option have already been entered.
For the purpose of grading the project you are required to perform the following tasks:
Start Excel. Open the downloaded spreadsheet namede02ws03_grader_h1_CarRental.xlsx. Save it ase02ws03_grader_h1_CarRental_LastFirst, replacingLastFirst with your name.
On the RentalData worksheet, in cell E6, enter the appropriate date formula to determine the length of the rental in days.
Copy the formula from E6 to the range E7:E32.
Name the range A37:B40 RentalRates.
In cell G6, use the appropriate lookup and reference function to retrieve the exact rental rate from the named range RentalRates based upon the value in column A. Copy the formula from G6 to the range G7:G32.
Name cell B42 Discount.
Name cell B44 GasCost.
In cell H6 enter a formula that determines the total cost based on the number of days the vehicle was rented and the discount indicated in cell B42. If the payment method was Express Miles or Rewards, the customer should receive the discount. Use the named range for the cell B42, not the cell address, in this formula.
Copy the formula from H6 to the range H7:H32.
In cell J6, enter a formula to determine the total cost with gas if the customer chose that option as indicated in column I. Use the name range for cell B44 in this formula.