E16 x f 10/15/2016 0 Ul 1Instructions for Problem 2: 3 Put a function in the Bonus Eligible column that displays "Yes" if the 4 employee is an Account Rep or Manager 5 If they are not eligible then display "No" 7 Put a function in the Bonus column which calculates the employees 8 bonus. The employee will get a bonus if they are eligible (from column H) and it 9 will be the % in 12:14 times salary. If they are not elibible then "N/A" will be 10 displayed. (Hint: this must be done using nested if functions since there are 4 possible outcomes). 11 When you do this use a reference to the values in 12:14 so that if they are changed 12 the values in the Bonus column will update. 13 14 In the Raise colum put a function which will calculate the employees raise. If they are a 15 Manager or Account Rep they get a 5% raise. If they are any other job the get a 4% raise 16) Figure out which 96 they receive then multiply that number by their Salary to 17 calcualte their raise. 18 20 19 21 23 24 25 26 27 28 29 30