CIS200 – Homework #1 – Simple Formulas & Functions



Name __________________________ Lecture Time _____________

CSE1111 – Homework #3 (10 points)– Boolean Logical Functions

Rates!

[pic]

Analysis!

Problem Description:

You are thinking about renting a car for a week to use on your vacation. To help determine which car to rent, you have called four competing rental agencies and listed their prices for Full-size, Mid-size, and Compact cars. Sheet rates! contains the weekly rental prices for each car type at each rental agency. Column B indicates whether or not the rental company includes vehicle damage insurance in their prices. On sheet analysis! you will complete the necessary analysis to determine which car is best for you. Included on sheet analysis! is the amount you have budgeted for weekly car rental. You have named this cell (C1) budget .

Please note when writing formulas, to receive full credit you must use correct Excel syntax (ie:use * for multiplication, / for division, etc.). Do not use unnecessary $ or functions. Also note, when writing your formulas, use cell references whenever possible.

Please be sure to use the sheet name and an exclamation point in front of the cell reference when referring to cells on different worksheets.

1. (1/2 point) Write a formula in cell analysis!B4, which can be copied across the row and down the column to determine (True/False) if this rental car is affordable (within your budget) for your vacation.

2. (1/2 point) Write a formula in cell analysis!E4, which can be copied down the column to determine (True/False) if the you need to purchase insurance separately for this vehicle rental from Avis. Note that you only have to purchase separate insurance if the company has not included insurance in the rental fee.

3. (1 points) Write a formula in cell analysis!F4, which can be copied down the column, to determine the number of types of cars that are affordable from each company.

4. (1/2 point) Write a formula in cell analysis!G9, to determine (True/False) if all Mid-size cars are within your budget. Use a Boolean function.

5. (1/2 point) Write a formula in cell analysis!G10, to determine (True/False) if there are any companies that you can afford to rent a full-sized car from.

6. (1 points) Write a formula in cell analysis!G11 to determine (True/False) if none of the cars from any rental agency are within your budget.

7. (2 points) Your friend Todd is also interested in renting a car and also has a budget of $400. In addition to budget constraints, Todd also has a few requirements for the agency he rents from. Write a formula in cell analysis!G4, which can be copied down the column, to determine (True/False) if this rental agency meets Todd’s criteria.

• Todd does not want to buy insurance separately. Thus he only rents a car from a company if that company has already included insurance fee in the rental costs.

• Todd prefers either a mid-sized or a full-sized car. So he will only rent from a company that he can afford either a mid-sized or a full-sized car.

8. (1 points) After helping out your friend Todd, your friend Frank was so impressed that he has asked you to determine which rental agencies meet his criteria. Write a formula in cell analysis!H4, which can be copied down the column, to determine (True/False) if this rental agency meets Frank’s criteria.

• Frank wants a mid-size car that costs less than $300 per week

• Alternatively Frank would accept a Compact car that costs less than $200 per week.

9. (1 points) After talking to a travel agent, they told you that if you were to rent the car through them, that they could get you a 20% discount if the cost of the car was at least $350. In cell rates!F3 write a formula, which can be copied down the column and across the row, to determine the discounted cost of the rental.

10. (2 points) After thinking about it for a while, you have decided to rent a full-size vehicle. Much to your dismay you have found out that Avis and Hertz will not be able to provide you with a car at all. Of the two remaining agencies, you would like to write a formula in cell analysis!G12 to determine which one to rent from. You prefer to rent from Budget (as you have had experience from them before), so if the discounted cost from Budget is within your $400 rental budget, the formula should display “Budget.” If you can’t afford Budget’s car, the formula should display “Enterprise” if Enterprise’s discounted cost is affordable. If neither company is affordable, the formula should display “None”.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download