Excel 2 Assignment - Excel 2 Assignment You are the new...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel 2 – Assignment You are the new manager at Bearkat Marketing Group. The CEO for the company frequently asks you to look up and summarize information about the company. To fulfill these requests more efficiently and accurately, you decide to set up an Excel worksheet that contains the names, job position, date hired, salary, and gender of each employee in the company. The following data is known about the employees: First Name Last Name City Stat e Department \ Rank Salar y Start Date Gend er Beth Palermo DENTON TX Sales \Rookie 27000 10/26/199 4 F David Downs JACKSON MS Management \Assist ant 36000 9/14/1992 M Jim Weaver TYLER TX Sales \Associate 50000 4/12/1988 M Alice Downs BIRMINGHA M AL Sales \Associate 53000 3/16/1989 F Alfred Hill COLUMBUS OH Management \Assist ant 32000 2/2/1991 M Earl Weeks MONROE LA Sales \Rookie 28000 2/4/1994 M Katherin e Ball HOUSTON TX Management \Assist ant 35000 6/12/1992 F Suzy Carnes CONROE TX Sales \Associate 52000 7/26/1990 F John Ball WILLIS TX Sales \Associate 51000 9/3/1989 M Cheryl Young MONTGOME RY TX Management \Head 60000 8/28/1987 F 1) Your assistant has extracted a text file from the human resource system, but unfortunately does
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Excel 2 Assignment - Excel 2 Assignment You are the new...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online