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
   77   78   79   80   81   82   83   84   85   86   87