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

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

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/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 namede02ws03_grader_h1_CarRental.xlsx. Save it ase02ws03_grader_h1_CarRental_LastFirst, replacingLastFirst 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.


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial