PearlJam819
19.03.2021 •
Business
Car Inventory
You have been tasked with creating an Excel workbook that will allow sales persons the ability to search existing inventory by VIN. They must also be able to define any combination of search criteria that returns a list of results and summary data pertaining to that result set. They have also asked that you create a separate sheet to help them calculate how large of loan they can afford and an amortization schedule for the loan.
Populate Calculated Fields
You need to calculate the number of days each vehicle has been on the lot and if there are any special notes that need to be added to each vehicle. Any vehicle that has been on the lot for more than 200 days is eligible for a special employee bonus if they are able to sell that vehicle. Any vehicle that has been on the lot between 125 and 200 days will earn the seller one raffle ticket in the end of the month $1000 bonus.
a. Open exam2_data and save as Exam2_LastFirst.
b. On the Inventory worksheet, insert a function in H7:H206 to calculate the number of days each vehicle has been on the lot using 1/1/2018 as today’s date.
c. Insert a function in I7:I206 that will display "Bonus Eligible" for cars that have been on the lot more than 200 days, "Raffle Eligible" for cars that have been on the lot between 125 and 200 days, and nothing for the remaining vehicles.
Solved
Show answers
More tips
- F Food and Cooking How to Determine Healthy, Nutritious Food for Yourself?...
- S Style and Beauty How to Get Rid of a Bruise: Tips and Tricks...
- F Food and Cooking Лечо: вкусное и простое блюдо для любой кухни...
- H Health and Medicine Relieving Swelling in Legs: Causes and Ways to Alleviate the Symptom...
Answers on questions: Business
- B Business Jared has a monthly gross income of $2,250 and a monthly debt load of $200. How can his debt-to-income ratio be classified? Excellent—10 percent or less Ideal—between 10 and...
- B Business How to write an article about problems facing your school...
- B Business An inherently dangerous product that violates liability law is one that either has or has been assembled poorly. A. been safely used B. been correctly manufactured C. been...
- B Business You are entering sales targets achieved by six marketing executives in a spreadsheet. Which function will help you find where each executive’s score stands with respect to...
- B Business One of the reasons that companies might merge is to diversify their product lines. True False...
- B Business The price elasticities of supply and demand affect...
- B Business in july 2009, hungary successfully issued 1 billion euros in bonds. the transaction was managed by citigroup....
- B Business The Blossom Company is a multidivisional company. Its managers have full responsibility for profits and complete autonomy to accept or reject transfers from other divisions....
- M Mathematics Write the absolute value equation if it has the following solutions hint: your equation should be written as |x-b|=c here b and c are some numbers two solutions x= 2.5,x=-3.5...
- E English Goodnight enjoy my point...
Ответ:
Never,
$1million or $1billion is given to me then too I'll never dance.