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

Count by Using Filters - Count Formulas

Q1 COUNT THE NUMBER OF DELHI EMPLOYEES

-a-

2

-ea-


Q2 COUNT THE NUMBER OF NOIDA EMPLOYEES

-a-

3

-ea-


Q3 COUNT THE NUMBER OF EMPLOYEES GETTING BASIC > 20000?

-a-

2

-ea-


Q4 COUNT THE NUMBER OF EMPLOYEES GETTING BONUS < 5000?

-a-

3

-ea-


Q5 COUNT THE NUMBER OF EMPLOYEES PAYING ESI?

-a-

3

-ea-


Q6 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED?

-a-

4

-ea-


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

-a-

3

-ea-


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

-a-

1

-ea-


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

-a-

0

-ea-


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

-a-

0

-ea-


Q11 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI?

-a-

2

-ea-


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

-a-

1

-ea-

 

Download File and Try

How to Use Filters

1.Select Table

2.Click

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

(Shortcut Ctrl Shift L )

 

 

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail