performance for awarding bonuses is the percentage achieved above the sales target. Based on this metric, a salesperson is placed into one of five bonus bands and awarded bonus points. The award criteria are listed in the "Award" worksheet in the attached excel file, e.g., if a salesperson's percentage (\%) achieved above target sale is in Interval [50\%,80\%), i.e., bigger than or equal to 50%, but strictly less than 80%, then his/her Bonus Point is 15 ; or if it is in Interval [100%,), i.e., bigger than or equal to 100%, then his/her Bonus Point is 40. After all salespeople are placed in a band and awarded points, everyone is awarded a percentage of the bonus pool, based on the percentage of the total points awarded. For example, if there were two salespeople (Bob and Mary). Bob got 20 bonus points and Mary got 30 bonus points. The total is 50 points. Bob gets 20/50 or 40% of the bonus pool and Mary gets 30/50 or 60% of the bonus pool. The bonus pool is $300,000 for this year. The list of salespeople (A17:A21) and \% above target sales values (B17:B21) are enclosed in the "Award" worksheet. The VLOOKUP table has been setup in "Award". Please complete the following requirements first in the "Award" worksheet and then answer the multiple-choice questions based on your completed "Award" worksheet: First, use VLOOKUP function to return the bonus points for each salesperson, i.e., fill in cells C17:C21. Second, use formulas to determine \% of pool for each salesperson, i.e., fill in cells D17:D21. Third, use formulas to determine the bonus amount(\$) for each salesperson, i.e., fill in cells E17:E21. Hint: Please watch the videos first under canvas module. You can also check out the following link for more examples Link L Q: In order to find Tim's bonus point, which formula should be entered in cell C17 in the "Award" worksheet? =VLOOKUP(B17,$B$10:$C$14,2,FALSE)=VLOOKUP(B17,$B$10:$C$14,1,FALSE=VLOOKUP(B17,$B$10:$C$14,1,TRUE)=VLOOKUP(B17,$B$10:$C$14,2,TRUE) Total Bonus points