Title: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Catracho on Oct 24, 2019 Hi can you explain to me how to do each of the steps in excel
YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 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. Steps to Perform: Step Instructions Points Possible 1 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. 0 2 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. 12 3 Assigned a named range of RentalRates to cells A37:B40. 5 4 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. 12 5 Assign a named range of Discount to cell B42 and a named range of GasCost to cell B44. 5 6 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. 15 7 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. 12 8 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. 10 9 In cell B46, use the appropriate function to calculate the median length of rental in days. 10 10 In cell B47, use the appropriate function to count the number of rentals in the data, using the data in column A. 10 11 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. 5 12 Insert the File Name in the left footer section of all worksheets in the workbook. 4 13 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points 100 See the word document instructions look more clear there Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: bio_man on Oct 25, 2019 Here you go :)
Need anything else, just ask Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Catracho on Oct 26, 2019 hi can you explain me how to do each step? thank you for your help
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: bio_man on Oct 26, 2019 No problem, see the attachment
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Catracho on Oct 28, 2019 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 Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: bio_man on Oct 28, 2019 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? Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Catracho on Oct 28, 2019 Hi yes i am ataching it again
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: bio_man on Oct 28, 2019 Hi Catracho (https://biology-forums.com/index.php?action=profile;u=825455)
I've provided most of the steps in this documents, please check Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: azzilynn08 on Jan 18, 2020 I am struggling with this same one !!! thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: nchavez1 on Jan 26, 2020 Thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: jcamps50 on Jan 26, 2020 thank you so much
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: camps55 on Jan 26, 2020 this helps!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: daniellebanks on Feb 11, 2020 thank you for offering this!!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: stephg470 on Feb 23, 2020 Thank you! i needed this
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Natalia Joy on Feb 25, 2020 Thanks so much, it really helped!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Dejuan Oram on Feb 26, 2020 Im struggling with the same things this was helpful
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Gamalliel Yonatan on Feb 29, 2020 Thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: BigJohn on Feb 29, 2020 Thankss
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Prodtm919 on Mar 1, 2020 Thank you for this!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: kajacks on Mar 1, 2020 Thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Expert Mentor on Mar 1, 2020 We can use max function do it (probably)
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Malcolm Anderson on Mar 3, 2020 No
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Ekta Patel on Apr 30, 2020 thank u
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: clarissaxlei on May 27, 2020 Thanks
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Max F on Jul 5, 2020 Thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: popeyes on Jul 11, 2020 Thanks so much!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Geoffrey Kang on Sep 1, 2020 Thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: ChefD14 on Sep 8, 2020 Thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Dougy Smoove on Sep 9, 2020 Great
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Andrew Garrett on Sep 21, 2020 Thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: emmas16 on Sep 27, 2020 thanks!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: swaggmaster2222 on Sep 27, 2020 Thank you very much
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: CrackerJacks on Sep 29, 2020 thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Jessica Lauren on Oct 4, 2020 Thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Heathermb08 on Nov 15, 2020 Thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Danielle Dillard on Nov 23, 2020 thank you soo much
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Kiara Evans on Nov 23, 2020 THANK YOU
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Juan Garcia-Moros on Feb 2, 2021 thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Asiap98 on Feb 4, 2021 Thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Sabrina Rasulova on Feb 9, 2021 Thank you for your help!!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: cookiedoo on Mar 21, 2021 thank you so much !!!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Ur Shezi on Apr 7, 2021 It was great
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: nby5578 on Apr 16, 2021 thank you for the help
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: qrwoods on Jul 3, 2021 Thank you, this really helped!!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: Robert Kiragu on Jul 10, 2021 thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: berge boo on Jul 15, 2021 Thank you! i needed this, this helps!
employee tracking software (https://www.worktime.com/employee-time-tracking-software) Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: alreynolds on Sep 7, 2021 thank you!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: hillarymichira on Sep 9, 2021 hello , this is a very great platform, happy to be one of the members
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: eunsolocho on Sep 16, 2021 thank you
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: rozich.madison1 on Sep 17, 2021 Thank You so much!
Title: Re: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: cheekymarsh on Sep 24, 2021 thanks!
Title: BFSF: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: stevepro004 on Jul 5, 2023 Thx
Title: BFSF: YO16_XL_CH03_GRADER_PS2_AS - Car Rental 1.3 Post by: MUKEKU MBINDA K on Sep 8, 2023 Thank you
|