Please give formula/steps for- Question 2

In cell O16 use the SUMIF function to determine the Total Units Produced by employees aged 40 or younger? Format answer as comma style, 0 decimal.

Question 3

In P16 use the AVERAGEIF function to calculate the average Gross Monthly Salary for employees from Department D. Format answer as comma style, 0 decimal.

Question 4 Points

In Q20 use the DAYS function along with the Date Hired and the date in cell B13 to calculate the days since the employee was hired. Divide the result by 365 to calculate the Years the employee has been hired (Years of Service). Copy the function down to the rest of the cells in the column.

In Q16 use the appropriate function to calculate how many employees were hired for more than 11 years.

Question 5 Points

In R20 use the YEAR function to extract the Year from the Date Certified. Copy the function down to the rest of the cells in the column.

In R16 use the appropriate function to calculate how many employees were certified after 2015.

Question 6 Points

In S20 use the MONTH function to extract the Month from the Hire Date. Copy the function down to the rest of the cells in the column.

In S16 use the appropriate function to calculate how many employees were hired in the month of April.