× Didn't find what you were looking for? Ask a question

Top Posters
Since Sunday
15
14
E
7
i
5
j
5
4
a
4
m
4
p
4
e
4
s
4
1
4
 123...5 New Topic

# YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3

wrote...
Posts: 529
Rep:
2 years ago
 YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Hi can you explain to me how to do each of the steps in excel YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3Project 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.Steps to Perform:Step   Instructions   Points Possible1   Start Excel. Open the file named e02ch03_grader_as_CarRental.x lsx. Save the file with the name e02ch03_grader_as_CarRental_L astFirst, replacing LastFirst with your last and first name.   02   On the RentalData worksheet, in cell E6, enter a date formula to determine the length of rental in days. Copy this formula to the range E7:E32.   123   Assigned a named range of RentalRates to cells A37:B40.    54   In cell G6, use the appropriate lookup and reference function to retrieve the rental rate from the named range RentalRates. The function should look for an exact matching value from column A in the data. Copy the function down the column to cell G32.   125   Assign a named range of Discount to cell B42 and a named range of GasCost to cell B44.   56   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.   157   In cell J6, enter a formula to determine the cost of gas if the customer chose that option as indicated in column I. 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.   128   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.    109   In cell B46, use the appropriate function to calculate the median length of rental in days.   1010   In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A.   1011   On the ClientData worksheet, use Flash Fill to separate the client names in column A to the FirstName and LastName columns respectively. Mac users will need to use the Text to Columns feature. Select the range A2:A26. On the Data tab, click Text to Columns. Select Space as the Delimiter and =$B$2 as the Destination.Adjust column width of columns B and C if necessary.   512   Insert the File Name in the left footer section of all worksheets in the workbook.   413   Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.   0Total Points   100See the word document instructions look more clear there Attached file You must login or register to gain access to this attachment. Read 1982 times 57 Replies

### Related Topics

Replies
wrote...
Educator
2 years ago Edited: 2 years ago, bio_man
 Here you go Need anything else, just ask Attached file CarRental_LastFirst.xlsx .xlsx (9.59 KB) You must login or register to gain access to this attachment.
wrote...
2 years ago
 hi can you explain me how to do each step? thank you for your help
wrote...
Educator
2 years ago
 No problem, see the attachment Attached file Explained.docx (1268.38 KB) You must login or register to gain access to this attachment.
wrote...
2 years ago
 Quote from: bio_man (2 years ago) No problem, see the attachment some steps are not in the version that you provided to me. my excel file is similar to yours but is not the sameone, it looks like mine has more steps, and also different steps
wrote...
Educator
2 years ago
 Quote from: Catracho (2 years ago) Quote from: bio_man (2 years ago) No problem, see the attachment some steps are not in the version that you provided to me. my excel file is similar to yours but is not the sameone, it looks like mine has more steps, and also different steps That's because your original upload was defected and I had to use a default version. Could you re-upload your original so that I have a better sense of the numbers?
wrote...
2 years ago
 Hi yes i am ataching it again Attached file(s) october 28.docx (32.43 KB) october 28 2.xlsx (14.53 KB) You must login or register to gain access to these attachments.
wrote...
Educator
2 years ago
 Hi CatrachoI've provided most of the steps in this documents, please check Attached file october 28.docx (1314.46 KB) You must login or register to gain access to this attachment.
wrote...
2 years ago
 I am struggling with this same one !!! thank you
wrote...
2 years ago
 Thank you!
wrote...
2 years ago
 thank you so much
wrote...
2 years ago
 this helps!
wrote...
2 years ago
 thank you for offering this!!
wrote...
2 years ago
 Thank you! i needed this
 123...5 New Topic
Explore
118 People Browsing
214 Signed Up Today
Gallery
1028
128
215
Latest Blogs