1 Bonus Paid A Week of October 19 Shift Supervisor Sales on Duty Afternoon Janice $ 1.212 Evening Sunny $ 1.256 Afternon Alissa $ 986 Evening Quynh $ 972 Aftemoon Alissa $ 994 Evening Janice $ 1.387 Afternoon Sunny $ 1.047 Evening Quynh $ 1,108 Afternoon Alissa $ 1.389 Evening Seo-yeon $ 1.289 Afternoon Sunny $ 1.347 Evening Seo-yeon $ 1,15 Afternoon Alissa $ 1.876 Evening Janice $ 1.877 2 Day 3 Sun 4 Sun 5 Mon 6 Mon 7 Tue 8 Tue 9 Wed 10 Wed 11 Thu 12 Thu 13 Fri 14 Fri 15 Sat 16 Sat 17 MAA Display the Supervisor Awards worksheet. Supervisors earn a bonus based on the Sales during their shift. In cell E3, enter an IFS function to compute a bonus based on the following: Sales over $1,200 earn a bonus of $75, Sales over $1,100 earn a bonus of $50, Sales over $1,000 earn a bonus of $25, and if conditions are not met, leave the cell blank. Copy the formula down through cell E16. Eleven bonuses display as the result