What are Filters
Filter are small button at top of column
Use of Filter
It is used to analyze individual items in a data (example count/sum etc)
Here we will learn how to Count using Filters
Assignment
Apply Filters on Table
and Count the following
Q1 COUNT THE NUMBER OF DELHI EMPLOYEES
Answer
2
Q2
COUNT THE NUMBER OF NOIDA EMPLOYEES
Answer
3
Q3
COUNT THE NUMBER OF EMPLOYEES GETTING BASIC > 20000?
Answer
2
Q4 COUNT THE NUMBER OF EMPLOYEES GETTING BONUS < 5000?
Answer
3
Q5 COUNT THE NUMBER OF EMPLOYEES PAYING ESI?
Answer
3
Q6 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED?
Answer
4
Q7 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED >1000?
Answer
3
Q8 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BASIC >20000?
Answer
1
Q9 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BONUS <5000?
Answer
0
Q10 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BASIC >20000 AND BONUS <5000?
Answer
0
Q11
COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI?
Answer
2
Q12
COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI AND GETTING BONUS>2000?
Answer
1
Download File and Try
How to Use Filters
1.Select Table
2.Click
Home --->Sort and Filter--->Filter
(Shortcut Ctrl Shift L )
