Excel Assignment 4
Assignment #4 Questions File

Download the Employee List spreadsheet. Use the spreadsheet to:

1. Find employees whose salary is between 50000 and 65000.

2. Find employees who are female and hired before 1/1/85.

3. Compute the average salary for each race group. Show only the summary level view.

4. Create a column chart to show the average salary for each race group.

5. Create a calculated field: Income Group according to the following rules:

If Salary <40000, Low income group If 40000 <= Salary < 60000, Median income group If Salary >= 60000, High income group

Then Find the number of employees in each income group.

6. Find employees who were born in March.

Note: To submit the assignment, capture the result’s screenshot (Ctrl+PrintScrn) of each question and paste it to a Word document, then submit the Word document by email attachment.