Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for your IF function arguments. Use absolute and relative references when appropriate.

Elon musk is the ceo of tesla motors. musk also serves as chairman of tesla's board. according to corporate governance theory, which of the following is a logical reason why musk should serve on the board? 1. he serves on many other boards, including that of a major client of tesla.2. his is an independent director who is well positioned to monitor the company's management.3. he can easily fire board members that are shirking their duties.4. he can provide the board with valuable inside information about the firm and the industry.

Jennifer purchased a house in a brand new development in the outskirts of town. when her house was built, the nearest fire department was nearly 20 miles away. as her neighborhood developed, the density of the community called for a new fire department 1.5 miles away. what effect will the new fire station have on her homeowners insurance premium? a. a new fire department will be more demanding on local taxes. her annual premium will go up. b. the location of a fire department has no bearing on the value of her house. her annual premium will stay the same. c. the new fire department will reduce the risk of financial loss in her home. her annual premium should decrease. d. with a fire department so close (less than 5 miles), financial risk on jennifer’s home practically disappears. she will not need to pay insurance anymore.

Which ranks these careers that employers are most likely to hire from the least to the greatest?