Page 82 - IT-802_class_12
P. 82
3.8.2 Standard Filter
The Standard filter provides advanced options for filtering data by using AND and OR operators. The AND operator
implies that in order to display the data, all the filters must be satisfied. The OR operator implies that at least one filter
needs to be satisfied for displaying the data.
AND Operator
In the previous worksheet, let’s select the male students who scored more than 75 marks. To filter on the given
condition:
1 Select the cells that consist of data.
2 Click on the Data menu and select FilterÆStandard Filter. Standard Filter dialog box opens.
3
To find data for the field (column) Marks with a Value above 75 for Gender as Male:
1 Select Male from the field Gender.
2 In the next line, set AND as the operator.
3 Click on OK. The output will be displayed as:
OR Operator
Let’s apply two conditions to find the names of the female students along with those with at least 75 marks.
To do so, perform the following steps:
1 Select the data.
2 Click on the Data menu and select Filter Æ Standard Filter. The Standard Filter dialog box opens.
80 Touchpad Information Technology-XII

