Assignment
Instructions
Sort by Employee Last Name, then first name
Fill in Status, Building, Hire Date, and Department from Employee Data
In order to do this you will need to Concatenate Last Name, First Name to match Employee Data
• Compute the number of full years each employee has been employed using Datedif()
• Each employee has a current compensation, years employed and performance rating
• Compute the new compensation based on the INCREASE being Years Employed * Performace Increase %
• Based on the new compensation, determine each employee's tax rate using Vlookup and TRUE
• Conditionally Format any New Salary > $100,000
• How many employees are earning more than $100,000
• Considering only those employees earning more than $100,000, what is their combined salary?
• Which Department has the highest Average Salary & what is that amount?
• Which Department has the most employees & how many are there?
Format your assignment according to the give formatting requirements:
• The answer must be using Times New Roman font (size 12), double spaced, and typed, with one-inch margins on all sides.
• The response also includes a cover page containing the student's name, the title of the assignment, the course title, and the date. The cover page is not included in the required page length.
• Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.
Attachment:- Salary-Increases-Student-Data.rar