1. What is the total Gross Monthly Salary for all employees?|Format answer as comma style, lo|| decimal. 2. What is the total monthly deduction for all employees?|Format the answer as comma style, lo decimal ? 3.What is the total net monthly salary for all employees 7 Format the answer as comma style of decimal 4. What is the total rating bonus for all employees?|Format the answer as comma style, 10 decimal? 5. What is the total education bonus for all employees?|Format the answer as comma style of decimal? 6.What is the total department bonus for all employees ? Format the answer as comma style, joj decimal? 8.Use Nested if to complete the following: If the City is North York, enter 100, if the city is Scarborough, enter|150, if the City is Markham, enter 125, otherwise enter 75. What is the total of all the City bonuses for all employees? Format the answer as comma style Ol decimal ? 9. Use AVERAGEIFS to calculate the average Gross Monthly Salary for male employees with a rating of 9 and an Education of 5 who are bilingual. Format as comma style. O decimal. 10. Use the SUMFS function to calculate the total Gross Monthly Salary for female employees with a Rating of 8 and an Education of 3 who are from Department D. Format as comma style. o decimal. 11 Use the COUNTIFS function to calculate the number of female, bilingual employees who have a gross monthly salary of more than 5000 12 Use the SUMIFS function to calculate the total Gross Monthly Salary for employees who have an Education of 3 or more and a English (India M O & = K Gross Monthly Deduction Salary Rate P N Rating Bonus Rate Education $ $ $ $ $ $0.00 5,000 7,500 9,000 11,000 15,000 20,000 20.096 25.0% 30.0% 35.0% 37.5% 42.5% 47.5% 1 2 3 4 5 6 7 1 2 3 4 5 0.50% 0.75% 1.00% 1.50% 2.00% 2.50% 3.00% 3.50% 4.50% 5.0096 9 10 TOTALS