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

-a-

7000

-ea-

Q2 FIND THE TOTAL BONUS PAID TO GURGAON EMPLOYEES

-a-

15750

-ea-

Q3 FIND THE TOTAL GROSS SALARY OF NOIDA EMPLOYEES

-a-

68700

-ea-

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

-a-

22700

-ea-

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

-a-

91431

-ea-

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

-a-

10800

#### -ea-

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

-a-

46000

-ea-

#### Download Assignment and try

**How to Use Filters**

1.Select Table

2.Click

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

(Shortcut Ctrl Shift L )