Create and name two additional worksheets based on the data provided.

The second worksheet will need to contain columns with the current salary, new salary, and percentage of increase.

The third worksheet should contain the new salary subtotals (using the subtotal function) by department only (Engineering, Human Resources, Management, and Marketing) regardless of the employee.

Using these

Data and 2 extra worksheets, VLOOKUP, IF, SUBTOTAL and sort functionality, Formatting and referencing data from another worksheet.

Salary is in the third table

Current Salary

$ 123,000.00

$ 43,500.00

$ 34,500.00

$ 42,500.00

$ 56,700.00

$ 45,600.00

$ 63,000.00

$ 75,700.00

$ 66,500.00

$ 41,000.00

$ 56,400.00

$ 53,300.00

$ 32,000.00

$ 23,000.00

$ 75,000.00

$ 42,300.00

$ 46,540.00

$ 65,000.00

$ 56,700.00

$ 49,600.00

$ 33,000.00

$ 59,800.00

$ 66,300.00

$ 51,000.00

$ 64,300.00

$ 32,000.00

$ 85,000.00

$ 46,000.00

$ 38,000.00

$ 43,000.00

you can just write the formulas

ID First Name Name Department Hire Date Birth Date Gender Clearance Score Total Salary 21908/2070 Female 1499 5/27/70 Male 589 11/15/99 Mao 1099 Frederich Bednarczyk Engineering 1009 Tim 2122 Yuan 2042 Hillary Cushner 2451 Francine Detweiler 851 Melinda English 032 Hillary Flintsteel 2896 Samuel Gates Performance Scores 2% Security Engineer 25 42.500 4/64 Male 826/94 5/6/61 Female TS Securiy Engie /1095 4/29/70 Female 63.000 10/193 2/14/56 Female 21908/2258 Female 2897 4/1074 Male 20 Engineering 20 66.500 26 41.000 26 56,400 18 3.300 Security Engineer 763 Male 690 4/29167 Male 355 Barbara GrabowskiManagement 01392 4/10/65 Female 11/5/01 16212/2258 Female 516/93 7/13/70 Male Management 614 Artie 1119 Sharad sour Engineering 3210 Carmen Ortega-Molina Engineering Security Engineer/1699 3/28/52 Female S 3043 Joseph Paterno 23 75.000 Security Engineer 22 42.300 Security Engie 10/1300 24/69 Malo 25 46.540 22 65.000 20 56.700 Engineering Security Engineer 012/1265 Female 826/95 23 59,800 20 66.300 24 51,000 17 64.300 Engineering Human Resources Manager Security Engineer 3/10/66 Female S Stonesifer Engineering Vaidyanathan Human Resources Worker Vaidyanathan Marketing Security Engineer 2/1/022/145 Male 2044 Suntra Vaidyanathan Marketing 26 85.000 26 6.000 2/1/02 10/10/61 Female Horn Management 2/3/58 Male 2678 Koshi Yamao Engineering Security Engineer11/1695124/63 Female 2/72 Male ID First Name Name Department Hire Date Birth Date Gender Clearance Score Total Salary 21908/2070 Female 1499 5/27/70 Male 589 11/15/99 Mao 1099 Frederich Bednarczyk Engineering 1009 Tim 2122 Yuan 2042 Hillary Cushner 2451 Francine Detweiler 851 Melinda English 032 Hillary Flintsteel 2896 Samuel Gates Performance Scores 2% Security Engineer 25 42.500 4/64 Male 826/94 5/6/61 Female TS Securiy Engie /1095 4/29/70 Female 63.000 10/193 2/14/56 Female 21908/2258 Female 2897 4/1074 Male 20 Engineering 20 66.500 26 41.000 26 56,400 18 3.300 Security Engineer 763 Male 690 4/29167 Male 355 Barbara GrabowskiManagement 01392 4/10/65 Female 11/5/01 16212/2258 Female 516/93 7/13/70 Male Management 614 Artie 1119 Sharad sour Engineering 3210 Carmen Ortega-Molina Engineering Security Engineer/1699 3/28/52 Female S 3043 Joseph Paterno 23 75.000 Security Engineer 22 42.300 Security Engie 10/1300 24/69 Malo 25 46.540 22 65.000 20 56.700 Engineering Security Engineer 012/1265 Female 826/95 23 59,800 20 66.300 24 51,000 17 64.300 Engineering Human Resources Manager Security Engineer 3/10/66 Female S Stonesifer Engineering Vaidyanathan Human Resources Worker Vaidyanathan Marketing Security Engineer 2/1/022/145 Male 2044 Suntra Vaidyanathan Marketing 26 85.000 26 6.000 2/1/02 10/10/61 Female Horn Management 2/3/58 Male 2678 Koshi Yamao Engineering Security Engineer11/1695124/63 Female 2/72 Male