Page 83 - IT-802_class_12
P. 83

3   Apply the criteria for Gender = Female OR Marks > 75 as shown below.



















                                                               OR
                 In the above screenshot, Field (column) name: Gender has been selected, whose Value, i.e., criteria, has been set
                 as Female, and further Operator OR has been applied, to also find and display data for the field (column) Marks
                 with Value above 75.

             4   Click on OK. The output will be as shown below:






















            AND-OR Operators
            Let’s find the female students whose names begin with the letter S and the male students whose names begin with the
            letter G, respectively.

            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.

             3   Apply the criteria for Gender that meets the Value (=) Female.
            In the next line,
             4   Apply the operator AND and against that, specify the field as Name of the Student with the condition as Begins

                 with and set the Value as S.
            In the next line,
             5   Apply the operator OR and against that, specify the field as Gender with the condition that equalises or matches
                 the Value of the field (column) as Male.





                                                                                                   ICT Skills-IV  81
   78   79   80   81   82   83   84   85   86   87   88