Your Office - Excel Workshop 3: Homework Project 1 Express Car Rental

Express Car Rental

Project Description: 
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.

Instructions: 
For the purpose of grading the project you are required to perform the following tasks: 
Step    Instructions    Points Possible
1    Start Excel. Open the downloaded spreadsheet named e02ws03_grader_h1_CarRental.xlsx. Save it as e02ws03_grader_h1_CarRental_LastFirst, replacing LastFirst with your name.    0
2    On the RentalData worksheet, in cell E6, enter the appropriate date formula to determine the length of the rental in days.    10
3    Copy the formula from E6 to the range E7:E32.    2
4    Name the range A37:B40 RentalRates.    10
5    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.    12
6    Name cell B42 Discount.    10
7    Name cell B44 GasCost.    10
8    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.    10
9    Copy the formula from H6 to the range H7:H32.    2
10    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.    10
11    Copy the formula in J6 to the range J7:J32.    2
12    In cell B46, use the appropriate function to calculate the Median length of rentals in days.    11
13    In cell B47, use the appropriate function to count the number of rentals in the data.    11
14    Save the e02ws03_grader_h1_CarRental_LastFirst.xlsx file and exit Excel. Submit the file as directed.    0
    Total Points    100