Page 39 - Touchpad_Plus_V3.2_Class 7
P. 39

Perform the following steps to apply a Standard Filter:

                 Step 1  Select the range of cells you want to filter, including the headers.
                 Step 2  Click on the Data menu.
                 Step 3  Click on the More Filters option.
                 Step 4  Click on the Standard Filter option. The Standard Filter dialog box will open.
                 Step 5  Under the Filter Criteria section, in the Field Name drop-down list, select Department
                          as the first criterion.

                 Step 6  In the Condition drop-down list, select equals (=).
                 Step 7  In the Value drop-down list, select Sales to filter for employees from the Sales department.
                 Step 8  To add another filter condition, in the second row of the Filter Criteria section, in the
                          Field Name drop-down list, select Years of Experience as the second criterion.

                 Step 9  In the Condition drop-down list, select greater than (>).
                 Step 10  In the Value drop-down list, enter 2 to filter only rows where the years of experience
                          are greater than 2.
                 Step 11  Under the Operator drop-down list, choose AND to connect rows that meet both filter
                          criteria.
                 Step 12  Once you have set up all criteria, click the OK button.






















                                                         Using Standard Filter

                 You will notice that only the details of the employees who are from the Sales department and
                 have more than 2 years of experience are displayed, and the rest of the rows are hidden.
                 Remove Filters

                 The AutoFilter, once applied, can be easily removed. Perform the following steps to remove
                 AutoFilter:
                 Step 1  Select the range of data where the AutoFilter was applied in the worksheet.

                 Step 2  Click on Data menu.
                 Step 3  Click on the AutoFilter option.

                 You will notice that the filter arrows in front of the column headers will disappear, and any
                 hidden rows will reappear.



                                                                                                  More on Calc       37
   34   35   36   37   38   39   40   41   42   43   44