1.Fill out Department And Location by using either VLookup or XLookup formula and the reference sheet tab. Remember to lock your formulas where necessary before copying.

2.Using either VLookup or XLookup formula, PROVIDE a formula to fill in any High Cost Differential in Column F.

3.Calculate Total Salary in Column G.

4.Sort the data by Location, then by Department, and then by Last Name.

W Homewo.. Week 12 S Part |_E.work (1) S Part |_E.work (2) 2 X + + Free trial WPS Office [ Financia.rypted) S MGS 41..a Gong . Albright.. Ch01 (1) 2 Formulas Data Review View Special features Unsynchronized Share =Menu Home Insert Page Layout X Cut T Calibri 12 A A Percentage Format as Table Merge and Wrap 3 % 000 8 08 Conditional Cell Style AutoSum AutoFilter Sort Fill Format Rov Paste L Copy Format Col Center Text Formatting Painter F7 @ fx J K M N O A B C D E F G H High Cost First Name Differential Total Salary Tax Withheld Net Pay Last Name Department Location Salary Tax break Norton Audrey Weeks Ariel Nolan Sophia Melendez ly Wang Isaiah Boyer Genevieve Pittman Juliana Taylor Oliver Pope Ella Mercado Hazel Ayers Lucia Hanson William Perez James Myers Nolan 16 Wheeler Preston 17 Lynn Miranda 18 Sullivan Kai 19 Branch Harley 20 Rich zabella 21 Strickland Peter Hansen Timothy 23 Kelley Kyle 24 Weber Jose 25 Rowe Marco 26 Rogers EI 27 Lucas Jonathan 28 Blevins Arabella 29 Finley Alexis 30 Krueger Izabella 31 Simpson Cesar 32 Barber Maximus 33 Delarosa Yaretzi 34 FOX Weston 35 Knapp Athena 36 Woodard Regina 37 Sawyer Lia Employees Reference Sheet + 100% . Local backup onWPS Office [ Financia.rypted) W Homewo.. Week 12 S MGS 41..a Gong . Albright.. Ch01 (1) 2 S Part |_E.work (1) S Part |_E.work (2) 2 X + Free trial =Menu Home Insert Page Layout Formulas Data Review View Special features Unsynchronized Share % Cut T Calibri 12 A A General Format as Table Paste L Copy Format BIU BEZA Merge and Wrap % 000 8 Conditional Cell Style AutoSum AutoFilter Sort Fill Format Row Painter Center Text Formatting Col B14 @ fx New York A B C D E F G H K M N O Departments Minimum Maximum AVERAGE 0 Marketing $ 50.000 $ 95.000 $ 72,500 0.25 HR 65,000 $ 105,000 85,000 JODAWN 0.5 Legal 80,000 $ 140,000 110,000 0.75 IT 70,000 130,000 $ 100,000 Locations Differential 0 Atlanta 0% 0.25 Charlotte 0% 0.5 San Francisco 7.5% 0.75 New York 6% Taxes 20% Tax break 0 0 15000 500 20000 2000 K Employees Reference Sheet + Local backup on 100%