Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The State of Georgia requires all employees of the University of Georgia to contribute to a retirement fund. The university makes a deduction from every
The State of Georgia requires all employees of the University of Georgia to contribute to a retirement fund. The university makes a deduction from every employee's basic salary. If the employee is full-time staff of the university, the retirement fund deduction is 2% of the employee's salary. If the employee works part-time, the deduction is 1%. Table 2 below shows the first five employees from an Excel spreadsheet you have received from HR, as well as their status and basic salaries. Table 2: Excerpt from Excel file of employees A B D 1 Name Status Basic Salary Retirement Deduction 2 John Smith Full-time $24,812.00 3 Mike Peterson Part-time $6,500.00 4 Paul Markov Full-time $66,100.00 5 Peter Petrov Part-time $7,000.00 6 Ivan Andonov Part-time $8,600.00 Using the information above, complete Table 2 by: Writing a logical Excel statement (IF function) in the last column of the spreadsheet, which computes the retirement deduction for the first employee and can be copied all the way down the list of employees. The logical statement must take into account the employee's status and basic salary. Start by downloading the Data File which contains the information from Table 2 here After solving the question in Excel, you should copy the formula used in your spreadsheet (i.e. copy and paste the "=IF..........)" statement) and paste in into the box below along with the completed Table 2 from your Excel spreadsheet
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