#### What are Filters

Filter are small button at top of column

It is used to analyze individual items in a data (example count/sum etc)

Earlier we learnt how to Count using Filters

Now,we calculate Sum or Total Using filter

####
**
Assignment
**

Calculate Sum of following using Filters

Q1 FIND THE TOTAL BASIC SALARY OF DELHI EMPLOYEES

View Answer7000

Q2 FIND THE TOTAL BONUS PAID TO GURGAON EMPLOYEES

View Answer15750

Q3 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES

View Answer68700

Q4 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES COVERED UNDER ESI?

View Answer22700

Q5 FIND THE TOTAL NET SALARY OF DELHI EMPLOYEES HAVING BONUS >10000?

View Answer91431

Q6 FIND THE TOTAL PF OF DELHI EMPLOYEES HAVING BASIC >20000?

View Answer10800

#### -ea-

Q7 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES GROSS >20000?

View Answer46000

#### Download Assignment and try

**
How to Use Filters
**

1.Select Table

2.Click

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

(Shortcut Ctrl Shift L )

Learn GST, TDS, Excel (with certification)