#### 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 )