Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the following steps on the Employee Analysis worksheet: 7. In the Employee Analysis data range, determine the number of full- and part-time employees
Complete the following steps on the Employee Analysis worksheet: 7. In the Employee Analysis data range, determine the number of full- and part-time employees in B3:B4. Determine the Total salary for full- and part-time employees in C3:C4. Determine the average salary for full- and part-time employees in D3:D4. Use functions. 8. In the Analysis of Full Time Employees data range, determine the number of full-time employees for each pay grade in B9:B12. Determine the total salary of full-time employees in each pay grade in C9:C12. Determine the average salary of full-time employees in each pay grade in D9:D12. Use functions. 9. In the Analysis of Part Time Employees data range, determine the number of full-time employees for each pay grade in B17:B20. Determine the total salary of full-time employees in each pay grade in C17:C20. Determine the average salary of full-time employees in each pay grade in D17:D20. Use functions. 10. In the Comp Days data range, determine the number of comp days for full-time employees in G4:G8. Determine the number of comp days for part-time employees in H4:H8. Use functions. 11. In the Employee Bonuses data range, determine the number of full-time employees in each pay grade in G14:G17 and total amount of bonuses paid to full-time employees in each pay grade in H14:H17. Use functions. 12. In the Employees and Salaries per Location data range, determine the number of full-time employees at each MB Accounting Services location in G23:G26 and the total salaries paid to full-time employees in H23:H26. Determine the number of part-time employees at each MB Accounting Services location in 123:126 and the total salaries paid to part-time employees in J23:J26. Use Functions.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started