web analytics

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

View Answer


Q2 COUNT THE NUMBER OF NOIDA EMPLOYEES

View Answer


Q3 COUNT THE NUMBER OF EMPLOYEES GETTING BASIC > 20000?

View Answer


Q4 COUNT THE NUMBER OF EMPLOYEES GETTING BONUS < 5000?

View Answer


Q5 COUNT THE NUMBER OF EMPLOYEES PAYING ESI?

View Answer


Q6 COUNT THE NUMBER OF EMPLOYEES WHOSE TDS DEDUCTED?

View Answer


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

View Answer


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

View Answer


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

View Answer


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

View Answer


Q11 COUNT THE NUMBER OF NOIDA EMPLOYEES PAYING ESI?

View Answer


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

View Answer

 

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 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail