In cell T20 use the IF function to enter YES if the Education is 3 or less, otherwise enter NO. Copy the function to the

[answerhappygod]

In cell T20 use the IF function toenter YES if the Education is 3 orless, otherwise enter NO. Copy the function to theother cells in the column.
In cell T16 use the appropriatefunction to calculate how many employees have YES.
In U20 use NESTED IF functions toenter:
Copy the nested functions to the rest of the cells in thecolumn.
In U16, use the appropriate function tocalculate the total for allemployees. Format answer as commastyle, 0 decimal.
In V20 use the VLOOKUP function toenter a bonus value based on the UnitsProduced and the appropriate VLOOKUP table at the topof the worksheet. Copy the function down to the rest of thecells in the column.
In V16 use the appropriate functionto calculate the total of the bonusamounts that are higher than1000. Format the answer as commastyle, 0 decimal.
In Z16 use the AVERAGEIFS function tocalculate the average Gross Monthly Salary for employees fromDepartment D with Educationof 2 or less andRating of 5 or less. Formatanswer as comma style, 0 decimal.
Click on the AdvancedFilters worksheet tab. Use AdvancedFilters only to answer the question. Filterthe list in place. Keep the results or nomarks will be awarded.
How many employees have a First Namethat starts with G or O orW and Units Produced of less than2,100 and are from ON? Enterthe answer here and in AB16 inthe Functions worksheet.
On the PIVOT sheet create a pivot table atcell W4 to answer the followingquestions:
What are the Total Units Produced by persons with a Ratingof 5 or 6 in the Cityof Oshawa or Ottawa. Format commastyle, 0 decimal.
Home A 13 14 15 17 K21 18 19 20 21 22 13 23 24 25 26 27 28 29 30 31 32 33 34 35 1 36 37 38 39 40 42 43 44 45 46 47 48 - 49 50 2.8 51 52 53 Paste Insert Draw Page Layout J 4 B FB V + X 23-Jun-07 5 13-Mar-14 3 22-Jan-06 6 21-Sep-12 3 2 4 2 19-Aug-05 27-Jun-15 07-Feb-17 21-Nov-11 25-Jun-07 30-No-07 03-Now-15 00-May-18 12-Apr-12 12-4-13 20-Now-15 30-8-07 20-May-17 23-May-07 19-May-19 05-May-06 01-Jul-06 19-Apr-10 07-Oct-18 24-Mar-13 25-Dec-15 25-Dec-12 20-Oct-14 21-Jan-17 02-Dec-16 11-Aug-09 29-O-15 DATE CERTIFIED RATING EDUCATION G 2 4 6 1 1 2 6 21-Oct-10 09-Now-06 3 6 5 6 6 3 5 G 2 3 6 6 3 1 Arial 3 B 2 5 5 STARTUP I U v fx 3 L 2 3 1 5 2 3 1 5 4 4 5 5 5 1 4 4 3 4 5 2 4 4 2 2 5 4 1 3 2 4 2 M AGE 48 20 28 50 56 24 28 41 62 58 60 BT 48 TE 35 40 63 57 53 40 28 30 33 26 50 60 46 60 39 27 51 61 57 51 62 FUNCTIONS ✓ 11 V Formulas ✓ N A A A Answers MARRIED? NO NO NO NO NO NO YES YES YES YES YES YES YES www YES NO YES NO YES NO YES NO Data 0 428,752 UNITS PRODUCED 1.519 1,861 1.689 1,399 1.587 1,135 1.372 1,379 1,704 1.081 1,842 1.238 1,5865 1.133 1,785 1.342 1,070 1.295 1,799 1.830 1,353 1,362 1,387 1,2009 1,778 1.571 1.362 ND YES ILS YES NO YES NO NO YES YES NO YES YES YES ADVANCED FILTER 1,3022 1.410 1,617 1.368 1,547 1.812 1,105 Review P 1,503 GROSS MONTHLY SALARY 9.69 8,694 9,500 2,789 6,041 5,479 9,199 3,354 3,382 7,782 9,442 4,58 7,600 3,199 se 8,365 2,297 9.375 2,570 9.289 3,702 3,603 2,731 9.678 2,841 M 1,834 3.404 www 3,9024 4,807 4,700 AKT 4,182 9,53 9130 3,50 3942 7,900 PIVOT View € * Q 234 14.61 8.85 15.35 9.03 16.69 7.56 4.78 10.96 14.84 14.30 4.56 3.83 6.34 8.51 5.90 13.73 4.82 14.29 2.93 16.65 14.24 12.15 12.21 5.43 YEARS OF YEAR CERTIFIED MONTH OF HIRE SERVICE 9.54 2.70 9.29 7.81 5.51 A 5.08 13.45 5.95 12.38 15.59 2007 2014 2008 2012 ab v 2005 2015 2017 2011 2007 2007 2018 2018 2016 * 2013 2016 2007 2017 2017 201 2006 2008 2010 2009 2016 2013 2018 2012 2014 2017 2018 2009 Tell me 2015 2010 2008 Owner 403 V General + $%9 S 6 3 9 1 5 6 4 2 3 10 5 3 7 2 4 3 2 5 11 11 B 7 5 10 3 T 12 B 2 409 9 6 T YES NO IF FUNCTION NO NO YES NO NO NO NO NO NO YES NO NO NO NO NO YES NO NO YES NO YES NO NO YES NO ←000 YES NO NO YES YES 186 L 14 THE ✓ E Conditional Format Formatting as Table NESTED IF V VLOOKUP Cell Styles W Insert v Dx Delete v Format v X ΣΥΡ MV Y Share 70 Sort & Find & Filter Select 2 5,467 Comments MA - M Analyze Data 350,953