Excel: Basic Filtering - Practical 1

 

The given data set is extracted from employee data sheet. Prepare the table in Excel and perform the listed filtering operations.

Perform the listed filtering operations on above data set.

1.      Filter all the “Female” employees from the table.

2.      Filter all the “Male” employees from the table.

3.      Extract all the “Single” employees from the table.

4.      Extract all the “Married” employees from the table.

5.      Get all the Employees who are assigned to “Science” department.

6.      Get all the Employees who are assigned to “IT” department.

7.      Filter all the employees who are younger than 30.

8.      Filter all the employees who are older than 40.

9.      Extract all employees who are getting at least 70,000 as salary.

10.  Extract all employees who are getting at most 50,000 as salary.

11.   Extract all employees who are “Married” and assigned to “IT” department.

12.   Extract all employees who are “Female” and “Single”.

13.   Filter all employees who are assigned to “Management” department and younger than 30.

14.   Filter all employees who are assigned to “Finance” department and “Single”.

15.   Get all employees who are younger than 30 and getting salary at least 60,000.

16.   Get all employees who are older than 40 and getting at most 125,000.

17.   Extract all employees who are age between 30 and 40 inclusively.

18.   Extract all employees who are getting a salary in between 60,000 to 90,000

19.   Extract all employees who are getting a salary between 100,000 to 150,000 and assigned to Management department

20.   Extract all employees who are age between 20 to 30 and getting a salary between 80,000 to 120,000.