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.