Count by Using Filters

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

Q2 COUNT THE NUMBER OF NOIDA EMPLOYEES

Q3 COUNT THE NUMBER OF EMPLOYEES GETTING BASIC > 20000?

Q4 COUNT THE NUMBER OF EMPLOYEES GETTING BONUS < 5000?

Q5 COUNT THE NUMBER OF EMPLOYEES PAYING ESI?

Q6 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED?

Q7 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED >1000?

Q8 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BASIC >20000?

Q9 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BONUS <5000?

Q10 COUNT THE NUMBER OF DELHI EMPLOYEES GETTING BASIC >20000 AND BONUS <5000?

Q11 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI?

Q12 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI AND GETTING BONUS>2000?

Download File and Try

How to Use Filters

1.Select Table

2.Click

Home --->Sort and Filter--->Filter

(Shortcut Ctrl Shift L )