1. The file Hr.xisx gives employee ID codes, salaries, and years of experience. Write a formula that takes a given ID code and yields the employee's salary. Write another formula that takes a given ID code and yields the employee's years of experience. 2. The file Assign.xIsx gives the assignment of workers to four groups. The suitability of each worker for each group (on a scale from 0 to 10) is also given. Write a formula that gives the suitability of each worker for the group to which the worker is assigned. 3. You are thinking of advertising Microsoft products on a sports telecast. As you buy more ads, the price of each ad decrease as shown in the following table. No. of ads Price of ads 1-5 $12000 6-10 $11000 11-20 $10000 More than 20 $9000 For examples, if you buy 8 ads, you pay $11000 per ad, But if you buy 14 ads you will pay $10000 per ad, write the formula that yields the total cost of purchasing any number of ads. 1. 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. No. of ads Price of ads 1-5 $12000 6-10 $11000 11-20 $10000 20 or higher $9000 For example, if you buy 8, ads you pay $12000 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 will probably need at least three columns in your table range and your formula might involve two lookup functions. 5. The annual rate the 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 1 year 5% 5 years 7% 10 years 9% 30 years 10% If you borrow money from the bank for any duration from through 30 years that's not listed in the table, your rate is found by interpolating between the rates given in the table. For example, let say you borrow money for 15 years. Because 15 years is one quarter of the way between 10 years and 30 years, the annual loan rate would be calculated as follows