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
   285   286   287   288   289   290   291   292   293   294   295