Importent:

1- do this in excel,

2- for part 1 and 2 you may choose any random data from the department, employee ID, names, job titles, salary...ets

3- use the data from part 1 and 2 to solve the remaining parts 3-5.

[1]*On one sheet:

1. a) Create a simple listing of 3 departments relative to any industry (choose any) Ex: department of Human resources , Department of returns , department of customer service

2. b) In a separate column, create a list for:

   Full-Time Part-Time

[2]*On a separate new sheet, create a listing of 20 employees including:

1. a) Employee ID (any random)

2. b) Last Name(any random)

3. c) First Name(any random)

4. d) Department Name Use Data Validation to create a listing of departments from which to select (use the listing

   from the sheet created in step 1)

5. e) Job Title (any random)

6. f) Full-time or Part Time Use Data Validation to create a listing from which to select (use the listing from the sheet

   created in step 1)

7. g) Annual Salary (any random)

-Note: You will eventually be creating an Organization Chart for these employees.

[3]*CREATE A COPY OF THE EMPLOYEE LISTING SHEET (created in step 2)...ON THE NEW SHEET...

1. a) Sort the table alphabetically by department, then by salary highest to lowest

2. b) Apply Data Bar Conditional Formatting to the salary

[4]**CREATE ANOTHER COPY OF THE EMPLOYEE LISTING SHEET FROM STEP 2...ON A NEW SHEET

1. a) Copy the sheet and prepare it to apply Subtotals. Subtotal for the average salary by department.

2. b) Collapse to show only level 2

1. c) Filter the table by the department of your choice

[5]**Using the EMPLOYEE LISTING sheet created in STEP 2, create a Pivot Table on a new worksheet showing:

1. a) the sum of the annual salaries for full-time versus part-time employees by job title

2. b) The report should be set to filter by Department