EXCEL PRACTICAL QUESTIONS
FILTER AND ADVANCE FILTER
FILTER AND ADVANCE FILTER
WORKSHOP - 1
Create the following data sheet in MS Excel.
Emp. Code
|
Emp. name
|
Dept.
|
Basic Salary
|
E101
|
Smith
|
Admin
|
$ 28,000
|
E102
|
Alex
|
Sales
|
$ 20,000
|
E103
|
David
|
Purchase
|
$ 19,500
|
E104
|
Sam
|
Sales
|
$ 21,000
|
E105
|
Cloudia
|
HR
|
$ 27,000
|
E106
|
Drothi
|
DEO
|
$ 16,500
|
E107
|
Amma
|
Receptionist
|
$ 15,000
|
E108
|
Jack
|
Sales
|
$ 18,000
|
1. Filter the above data and find out all employee's name those are working in Sales department with help of Filter tool in MS-Excel.
2. Find the all employee's details who are working on Sales department and those basic salary are greater than 20,000.
WORKSHOP - 2
Create the following data sheet in MS Excel.
Emp. Code
|
Emp. name
|
Department
|
Basic Salary
|
E101
|
Smith
|
Admin
|
28,000
|
E102
|
Alex
|
Sales
|
20,000
|
E103
|
David
|
Purchase
|
19,500
|
E104
|
Sam
|
Sales
|
21,000
|
E105
|
Cloudia
|
HR
|
27,000
|
E106
|
Drothi
|
DEO
|
16,500
|
E107
|
Amma
|
Receptionist
|
15,000
|
E108
|
Jack
|
Sales
|
18,000
|
1. Copy all the employee records (those are not working in purchase department) by using Advance filter from the above data sheet in different location but within the same worksheet.
PRACTICE QUESTION (SET - 1)
PRACTICE QUESTION (SET - 2)
PRACTICE QUESTION (SET - 3)
PRACTICE QUESTION (SET - 4)
PRACTICE QUESTION (SET - 5)
0 Comments