Page 290 - Trackpad IT-402_Class-IX
P. 290
To use AutoFilter, follow the given steps:
Step 1: Select the column you want to filter.
Step 2: Select Data→ Filter→ AutoFilter option.
Step 3: When you click on the AutoFilter option, a combo box will appear in the selected column header.
Step 4: Click the drop-down arrow and choose the value to filter the column. In the below image English is chosen.
In the below image, English is filtered. Based on the marks, all the other columns are also filtered.
Standard Filter
In the Standard Filter dialog box, you can also define
ranges that contain the values in particular data fields.
You can use the standard filter to connect the conditions
with either a logical AND or a logical OR operator.
To use Standard Filter, follow the given steps:
Step 1: Select the range of cells to be filtered.
Step 2: Click on Data → Filter → Standard Filter
option. The given window will appear:
Step 3: Fill in the data field names on which you want
to base your filter by selecting them in the drop-down
menu.
Here again, you can use up to 3 criteria with Boolean
operators (And, OR) and other conditions such as (=, <,
>, <=, =>)
290 Trackpad Information Technology-IX

