LINK TO DO IT ON AND ONCE DONE EXPLAIN AND WTITE ANSERS SEPARATE ALSO

https://docs.google.com/spreadsheets/d/1iGQDcaxi30kSet__exVrDm8tgYbXAbDO/edit?usp=sharing&ouid=111463028831011062492&rtpof=true&sd=true

-In cell N14, enter a function to calculate how many employees have a Gross Monthly Salary greater than 5,800. [a] Format as comma style, 0 decimal

-In cell O17: Use the VLOOKUP function to return the Deduction Rate 1 from the appropriate table at the top of the worksheet. Multiply this Deduction Rate 1 by the Gross Monthly Salary to calculate the Monthly Deduction. Copy the function down to the other cells in the column.

In cell O14 use the appropriate function to answer: How many employees have a Monthly Deduction greater than 4000? Format answer as comma style, 0 decimal.

In cell P17: Calculate the Net Monthly Salary by subtracting the Monthly Deduction from the Gross Monthly Salary. Copy the formula to all cells in the column.

In cell P14: use the appropriate function to answer: How many employees have a Net Monthly Salary greater than 5000?

- In cell Q17: Use the VLOOKUP function to return Bonus Rate 4 from the appropriate table at the top of the worksheet. Multiply this Bonus Rate 4 by the Gross Monthly Salary to calculate the Rating Bonus. Copy the function down to the other cells in the column.

In cell Q14 use the appropriate function to answer: How many employees have a Rating Bonus less than 220? Format answer as comma style, 0 decimal.

- In cell R17: Use the VLOOKUP function to return Education Bonus 3 from the appropriate table at the top of the worksheet. Copy the function down to the other cells in the column.

In cell R14 use the appropriate function to answer: How many employees have an Education Bonus greater than 800? Format answer as comma style, 0 decimal.

- In cell S17: Use the VLOOKUP function to return Department Bonus 3 from the appropriate table at the top of the worksheet. Copy the function down to the other cells in the column.

In cell S14 use the appropriate function to answer: What is the total for all employees? Format answer as comma style, 0 decimal.

- In cell T17 use the IF function to enter 50 if EDUCATION is 2 or lower otherwise enter 300. Copy the function to the other cells in the column.

In cell T14 use the appropriate function to calculate the total for all employees. Format as comma style 0 decimal

- In U17 use NESTED IF functions to enter:

the value in AF2, if the PROVINCE is ON,

the value in AF3, if the PROVINCE is BC,

the value in AF4, if the PROVINCE is AB,

the value in AF5, if the PROVINCE is MB,

otherwise the value in AF6.

Copy the nested functions to the rest of the cells in the column.

In U14, use the appropriate function to count how many values are less than 700. Format answer as comma style, 0 decimal.

- In V14 use the AVERAGEIFS function to calculate the average Gross Monthly Salary for employees from Toronto with Rating of 5 or less and Education of 3 or less who are in Department D. Format answer as comma style, 0 decimal.

- In W14 use the SUMIFS function to calculate the total Gross Monthly Salary for Female employees from Mississauga with a Rating of less than 7 who are not bilingual. Format answer as comma style, 0 decimal.

- In cell X14 use the COUNTIFS function to determine how many Female employees have a Rating of more than 4 and an Education of 2 and are from Department D.

- In cell Y14 use the MATCH Function to answer: What is the Row # (in the range of Gross Monthly Salary data) that 7428 can be found?

In cell Z14 use the INDEX Function only to answer: What is the Title of the employee with a Gross Monthly Salary of 7428?

- In cell AA14 use the SUBTOTAL Function only to calculate the minimum Gross Monthly Salary for all employees (Format as comma style, 0 decimal)

Filter the data to show employees with Education of 4 or 5 from Toronto or Scarborough or Oshawa who are not bilingual.

The Subtotal value in AA14 should update to show the result for the filtered data.

Enter (type) this new Subtotal value into cell AB14 (the value should remain when the filters are cleared).

What is the new Subtotal value? (Format as comma style, 0 decimal)

Clear the filters.