FINAL ASSIGNMENT MICROSOFT EXCEL PAYROLL (2019) Total Gross Pay Income Tax DATE Job Title Net Pay Receptionist 48,9201 5,381.2 Security Guard 45,415 4,995.65 Director
FINAL ASSIGNMENT MICROSOFT EXCEL PAYROLL (2019) Total Gross Pay Income Tax DATE Job Title Net Pay Receptionist 48,9201 5,381.2 Security Guard 45,415 4,995.65 Director 63,400 6,974 Facility Manager 58,600 6,446 Maintenance Worker 32,786 3,606.46 Janitor 23,475 2,582.25 Parking Cashier 24,004 2,640.44 Operations Worker 38,062 4,186.82 Total 334,662 36,812.82 0 Insert Formula for Today's Date 10 MARKS Calculate Net Pay. Filter & sort the data from highest to lowest salary. Create a Pie chart representing the Job Title & Total Gross Pay.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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