Page 26 - C_GPT _V4 _class_7
P. 26
To apply filters, follow these steps:
2 Click on the Sort
& Filter button.
Click on the 3
Filter option.
Select the
range of
1 columns to
be filtered.
You will notice that small arrows appear in front of all the column headers.
4 Click on the arrow in front of the header
Marks Obtained in Second Term.
5 Click some of the check Click on the 6
boxes to uncheck them. OK button.
To get the data back, open the filter drop-down list again and check the unchecked entries.
Excel also allows you to use a custom filter. Suppose you want to know the names of the students who
have scored more than 80 marks in the second term.
CodeGPT (Ver. 4.0)-VII
24

