On the Schedules worksheet, in cell F3, enter a COUNTIFS function to count the number of Afternoon shifts each Scooper is scheduled to work. Defined names exist for SCOOPER and SHIFT and the order is SCOOPER, cell E3, SHIFT, and "Afternoon "Copy the formula down to cell F15 /28/2021 1 G019_XL_CHO_GRADER_8G_AS-Sales a ictions Exc Instructions In the range 13:115, enter an AND function to determine which Scoopers are scheduled for 3-5 Afternoon shifts In cell 3, enter a COUNTIFS function to calculate the number of Monday shifts each Scooper is scheduled to work. Edit the formula in cell J3 by adding a second COUNTIFS function to calculate the number of Tuesday shifts each Scooper is scheduled to work. Copy the formula down through cell J15. Defined names exist for the range SCOOPER and DAY In cell K3, enter an IF function with a nested AND function to determine which Scoopers are scheduled for 3-5 shifts, including a Monday or Tuesday. The function should return the world Eligible if true and leave the cell blank if false. Copy the formula down through cell K15. Three Scoopers are eligible Display the Service Awards worksheet. Scoopers earn a cash award when the number of Comment Cards from customers with a positive comment is over 20 per month. In cell C3, enter an IFS function to compute the cash award based on the following: Comments over 30 earn a bonus of $75, Comments over 25 earn a bonus of $50. Comments over 20 eam a bonus of $25, and if conditions are not met, leave the cell blank. Copy the formula down through cell C15. Nine awards display as the result. K15 G M 7 Sun A B D Schedule-Week of May 21-28 2 Day Shih Scooper 3 Sun Evening Drake 4 Sun Evening Frankie 5 Sun Afternoon Chuck 8 Sun Evening Chuck Evening Steve 8 Sun Evening Olive Sun Evening Nate 10 Sun Afternoon Jack 11. Sun Alemon Joe 52 Sun Evening Joe 13 Mon Afternoon Rachel 14 Mon Evening Rachel 5 Mon Afternoon Drake 16 Mon Evening Drake 17 Mon Ahemoon Chuck 1B Mon Evening Chuck 19 Mon Afemoon Steve 20 Mon Evening Olive 21 Mon Alemon Nate 22 Mon Evening Jack 23 Tue Afternoon Joe 24 Tue Ahernoon Drake 75 T F Scenario Summary Projected income E Scoopers-Afternoon Shin Scooper Number of Shifts Aaron Chuck Drake Frankie Jack Joe Kenny Mike Moses Nate Olive Rachel Steve Afternoon Shit Scoopers of the Week Server 3-5 Shifts MORT Eligible Aaron Chuck Drake Frankie Jack Joe Kenny Me Moses Nate Olive Rachel Steve Sales Trend Out Sales Schedules Service Ande E F G H A 25 Tue 26 Tue 27 Tue 28 Toe 29 Tue 30 Tue 31 Tue 32 Tue 33 Tue 34 Tue 35 Wed 30 Wed 37 Wed 38 Wed 39 Wed 40 Wed 41 Wed 42 Wed 13 Wed 44 Wed 45 Wed 45 Wed 47 Wed Ma Thu 4 | B D Evening Drake Evening Frankie Afternoon Moses Afternoon Alishia Afternoon Kenny Afternoon Frankie Evening Frankie Evening Kenny Afternoon Chuck Evening Chuck Afternoon Aisha Evening Alisha Afternoon Rachel Afternoon Drake Afternoon Kenny Afternoon Mike Evening Kenny Evening Kenny Evening Mike Evening Rachel Evening Frankie Evening Moses Evening Moses Evening Mike Afternoon Kenny Scenario Summary Projected Income Sales Trend Chart Sales Schedules Service Awatch :: Type here to search 100 TBF E G H 49 Thi 50 Th 51 Thu 52 Th 53 Th 54 Thi 35 Thu 5 Thu 57 Thu THI 59 Fri 60 Fn 61 Fri 62 Fri 63 Fri 64 Fri 65 Fri 36 Fri 67 Fri 88 Fri 69 Fri 70 Fri 71 Fri 72 Fri 73 Fri B D Aftemoon Kenny Evening Kenny Afternoon Kenny Evening Kenny Afternoon Rachel Evening Rachel Evening Drake Evening Alishia Afternoon Drake Evening Frankie Afternoon Drake Evening Kenny Afternoon Kenny Evening Kenny Afternoon Mike Evening Mike Afternoon Mike Evening Mike Afternoon Aaron Evening Aaron Afternoon Jack Evening Jack Afternoon Alishia Evening Alishia Evening Drake Scenario Summary Projected Income Sales Trend Chart Sales Schedules Service Awards D E G 66 Fn 67 Fn 68 Fri 69 Fri 70 Fri 71 Fri 72 Fn 73 Fri 74 Fri 75 Fri 76 Sat 77 Sat 78 Sat 79 Sat BO Sat 81 Sat 82 Sat 83 Sat 84 Sat 85 Sat B6 Sat 87 Sat 88 Sat 89 Sat 90 B Evening Aftemoon Evening Afternoon Evening Afternoon Evening Evening Afternoon Evening Afternoon Evening Evening Afternoon Afternoon Evening Afternoon Evening Afternoon Evening Afternoon Evening Evening Evening Mike Aaron Aaron Jack Jack Alishia Alishia Drake Rachel Moses Alishia Alishia Moses Drake Jack Jack Mike Mike Kenny Kenny Rachel Rachel Frankie Moses On the Schedules worksheet, in cell F3, enter a COUNTIFS function to count the number of Afternoon shifts each Scooper is scheduled to work. Defined names exist for SCOOPER and SHIFT and the order is SCOOPER, cell E3, SHIFT, and "Afternoon "Copy the formula down to cell F15 /28/2021 1 G019_XL_CHO_GRADER_8G_AS-Sales a ictions Exc Instructions In the range 13:115, enter an AND function to determine which Scoopers are scheduled for 3-5 Afternoon shifts In cell 3, enter a COUNTIFS function to calculate the number of Monday shifts each Scooper is scheduled to work. Edit the formula in cell J3 by adding a second COUNTIFS function to calculate the number of Tuesday shifts each Scooper is scheduled to work. Copy the formula down through cell J15. Defined names exist for the range SCOOPER and DAY In cell K3, enter an IF function with a nested AND function to determine which Scoopers are scheduled for 3-5 shifts, including a Monday or Tuesday. The function should return the world Eligible if true and leave the cell blank if false. Copy the formula down through cell K15. Three Scoopers are eligible Display the Service Awards worksheet. Scoopers earn a cash award when the number of Comment Cards from customers with a positive comment is over 20 per month. In cell C3, enter an IFS function to compute the cash award based on the following: Comments over 30 earn a bonus of $75, Comments over 25 earn a bonus of $50. Comments over 20 eam a bonus of $25, and if conditions are not met, leave the cell blank. Copy the formula down through cell C15. Nine awards display as the result. K15 G M 7 Sun A B D Schedule-Week of May 21-28 2 Day Shih Scooper 3 Sun Evening Drake 4 Sun Evening Frankie 5 Sun Afternoon Chuck 8 Sun Evening Chuck Evening Steve 8 Sun Evening Olive Sun Evening Nate 10 Sun Afternoon Jack 11. Sun Alemon Joe 52 Sun Evening Joe 13 Mon Afternoon Rachel 14 Mon Evening Rachel 5 Mon Afternoon Drake 16 Mon Evening Drake 17 Mon Ahemoon Chuck 1B Mon Evening Chuck 19 Mon Afemoon Steve 20 Mon Evening Olive 21 Mon Alemon Nate 22 Mon Evening Jack 23 Tue Afternoon Joe 24 Tue Ahernoon Drake 75 T F Scenario Summary Projected income E Scoopers-Afternoon Shin Scooper Number of Shifts Aaron Chuck Drake Frankie Jack Joe Kenny Mike Moses Nate Olive Rachel Steve Afternoon Shit Scoopers of the Week Server 3-5 Shifts MORT Eligible Aaron Chuck Drake Frankie Jack Joe Kenny Me Moses Nate Olive Rachel Steve Sales Trend Out Sales Schedules Service Ande E F G H A 25 Tue 26 Tue 27 Tue 28 Toe 29 Tue 30 Tue 31 Tue 32 Tue 33 Tue 34 Tue 35 Wed 30 Wed 37 Wed 38 Wed 39 Wed 40 Wed 41 Wed 42 Wed 13 Wed 44 Wed 45 Wed 45 Wed 47 Wed Ma Thu 4 | B D Evening Drake Evening Frankie Afternoon Moses Afternoon Alishia Afternoon Kenny Afternoon Frankie Evening Frankie Evening Kenny Afternoon Chuck Evening Chuck Afternoon Aisha Evening Alisha Afternoon Rachel Afternoon Drake Afternoon Kenny Afternoon Mike Evening Kenny Evening Kenny Evening Mike Evening Rachel Evening Frankie Evening Moses Evening Moses Evening Mike Afternoon Kenny Scenario Summary Projected Income Sales Trend Chart Sales Schedules Service Awatch :: Type here to search 100 TBF E G H 49 Thi 50 Th 51 Thu 52 Th 53 Th 54 Thi 35 Thu 5 Thu 57 Thu THI 59 Fri 60 Fn 61 Fri 62 Fri 63 Fri 64 Fri 65 Fri 36 Fri 67 Fri 88 Fri 69 Fri 70 Fri 71 Fri 72 Fri 73 Fri B D Aftemoon Kenny Evening Kenny Afternoon Kenny Evening Kenny Afternoon Rachel Evening Rachel Evening Drake Evening Alishia Afternoon Drake Evening Frankie Afternoon Drake Evening Kenny Afternoon Kenny Evening Kenny Afternoon Mike Evening Mike Afternoon Mike Evening Mike Afternoon Aaron Evening Aaron Afternoon Jack Evening Jack Afternoon Alishia Evening Alishia Evening Drake Scenario Summary Projected Income Sales Trend Chart Sales Schedules Service Awards D E G 66 Fn 67 Fn 68 Fri 69 Fri 70 Fri 71 Fri 72 Fn 73 Fri 74 Fri 75 Fri 76 Sat 77 Sat 78 Sat 79 Sat BO Sat 81 Sat 82 Sat 83 Sat 84 Sat 85 Sat B6 Sat 87 Sat 88 Sat 89 Sat 90 B Evening Aftemoon Evening Afternoon Evening Afternoon Evening Evening Afternoon Evening Afternoon Evening Evening Afternoon Afternoon Evening Afternoon Evening Afternoon Evening Afternoon Evening Evening Evening Mike Aaron Aaron Jack Jack Alishia Alishia Drake Rachel Moses Alishia Alishia Moses Drake Jack Jack Mike Mike Kenny Kenny Rachel Rachel Frankie Moses