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 )