Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Application Project 2 - 50 Points Create a payroll spreadsheet using the following requirements and the example provided: Requirements and Instructions Create a spreadsheet with
Application Project 2 - 50 Points Create a payroll spreadsheet using the following requirements and the example provided: Requirements and Instructions Create a spreadsheet with the following: - 5 first and last names with their Yearly Gross Pay, and Number of Dependents. - Add a column for Evaluation Rate; add the Evaluation rate with 1 being lowest and 3 the highest. - Add the lookup table for dependents \& tax rate Requirements and Instructions Create a spreadsheet with the following: - 5 first and last names with their Yearly Gross Pay, and Number of Dependents. - Add a column for Evaluation Rate; add the Evaluation rate with 1 being lowest and 3 the highest. - Add the lookup table for dependents \& tax rate - Name it TaxPercent (defined name) to use in the Tax \% - Make the data range an Excel Table - Name the table EmployeePay_table - Add a Full Name calculated field to the table (use structured references) - Add formulas for Tax \%, \% Tax \& Deductions, Net Pay, Bonus, Net Pay with Bonus (use structured references) - Add the BONUS formula***: - Use a nested IF function (use structured references) (hint: Mod 7, Section 7-3; Instruction #5 SAM Project) - IF the evaluation rate =3, bonus =1000 - IF the evaluation rate =2, bonus =500 - Otherwise, bonus = 0 - Add an Excel Total Row to the Table and totals as the example - Add an Excel Total Row to the Table and totals as the example Save this file as yourname_AppProj2. Turn it in to the appropriate dropbox in Moodle
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