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.

Sara is a manager at a restaurant with employees from different cultural backgrounds. which action of sara could employees perceive as an act of favoritism?

5. profit maximization and shutting down in the short run suppose that the market for polos is a competitive market. the following graph shows the daily cost curves of a firm operating in this market. 0 2 4 6 8 10 12 14 16 18 20 50 45 40 35 30 25 20 15 10 5 0 price (dollars per polo) quantity (thousands of polos) mc atc avc for each price in the following table, calculate the firm's optimal quantity of units to produce, and determine the profit or loss if it produces at that quantity, using the data from the previous graph to identify its total variable cost. assume that if the firm is indifferent between producing and shutting down, it will produce. (hint: you can select the purple points [diamond symbols] on the previous graph to see precise information on average variable cost.) price quantity total revenue fixed cost variable cost profit (dollars per polo) (polos) (dollars) (dollars) (dollars) (dollars) 12.50 135,000 27.50 135,000 45.00 135,000 if the firm shuts down, it must incur its fixed costs (fc) in the short run. in this case, the firm's fixed cost is $135,000 per day. in other words, if it shuts down, the firm would suffer losses of $135,000 per day until its fixed costs end (such as the expiration of a building lease). this firm's shutdown price—that is, the price below which it is optimal for the firm to shut down—is per polo.

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?