Question

Lesson 1 HW-Lookups(2) -Word eview View EndNote ACROBAT AaBbCcD AaBbccDc AaBbC AaBbct AaB AaBbCc AaBbocD Heading 2 5-12-田·||Normal]1No Spac-Heading 1 Title Subtitle Subtle Em. Paragraph Styles 2. You are thinking of advertising Microsoft products on a popular TV music program. You pay one price for the first group of ads, but as you buy more ads, the price per ad decreases as shown in the following table: Ad Number Price per ad $12,000 $11,000 6-10 11-20 21 or Higher $10,000 $9,000 For example, if you buy 8 ads, you pay $12,000 per ad for the first 5 ads and $11,000 for each of the next 3 ads. If you buy 14 ads, you pay $12,000 for each of the first 5 ads, $11,000 for each of the next 5 ads, and $10,000 for each of the last 4 ads. Write a formula that yields the total cost of purchasing any number of ads. Hint: You probably need at least three columns in your table range, and your formula might involve two lookup functions 3. The annual rate your bank charges you to borrow money for 1, 5, 10, or 30 years is shown in the following table: Duration of Loan Annual loan rate

Answer 1