Excel Assignment 4

profileAysad415
EmployeeList3.xls

Sheet1

ABC Company Employee File
EmpID Last Name First Name Sex Race Birthdate Hire Date Salary Dept
326 Costo Bianca Female Hispanic 6/12/70 12/4/92 $28,000 E
327 Hernandez Sylvia Female Hispanic 4/1/58 5/4/83 $65,000 A
328 An Bok Male Asian American 12/15/68 7/12/87 $52,000 A
330 Cornell Ryan Male Non-Hispanic White 10/12/42 9/27/88 $47,500 C
332 Chandra Lavina Female Asian American 11/11/57 10/15/89 $62,500 E
333 Shah Neha Female Asian American 1/31/62 6/4/85 $56,000 B
335 Thomas Desma Female African American 6/18/72 8/14/92 $24,000 D
336 Collins Ryan Male African American 10/31/68 8/1/86 $68,000 D
337 Huerta Carlos Male Hispanic 3/3/55 5/22/88 $55,000 B
339 Waxman Peter Male Non-Hispanic White 4/5/70 4/7/05 $75,000 C
340 West Paul Male Non-Hispanic White 8/20/82 9/30/09 $65,000 D
342 Green Ann Female African American 7/1/70 4/26/90 $45,000 B
343 Sylla Shella Female African American 2/3/66 10/25/83 $85,000 C
344 Lugones Omar Male Hispanic 9/28/71 5/17/91 $29,900 E
345 Harris Derrick Male African American 5/1/50 7/12/88 $48,600 D
346 Fernandez Alex Male Hispanic 12/1/75 7/12/92 $18,900 A
347 Patterson Tom Male Non-Hispanic White 8/22/41 7/8/86 $58,500 C
348 Kinzer Jessica Female Non-Hispanic White 5/31/62 3/12/84 $68,500 D
349 Solis Jennifer Female Non-Hispanic White 2/2/60 11/3/91 $38,500 B
350 Adler Liz Female Non-Hispanic White 5/22/73 9/25/82 $85,000 D
354 Surana Pamit Male Asian American 10/1/47 1/15/80 $52,300 B
356 Baldwin Matt Male Non-Hispanic White 4/3/67 4/17/90 $32,000 A
357 Tiano Mike Male Hispanic 9/15/85 12/20/10 $65,000 B
358 Krein Darren Male Non-Hispanic White 4/18/41 4/20/89 $45,500 C
359 Tibbott Diane Female Non-Hispanic White 3/1/80 1/30/10 $45,000 C
&A
Page &P

Sheet2