Page 38 - Touchpad_Plus_V3.2_Class 7
P. 38

Unfiltered data
                  Step 2  Click on the Data menu.

                  Step 3   Select the AutoFilter option. You will notice that small arrows          appear in front of
                           all the column headers.
                  Step 4   Click on the arrow in front of the header Department to open a drop-down list. You will
                           notice that all the entries in the column are present in the list with small checkboxes in
                           the beginning.
                  Step 5   Click on Sales checkbox to uncheck it.
                  Step 6  Click on the OK button.






















                                           Using AutoFilter option               Using filter options










                                                               Filtered data

                  You will notice that the rows of unchecked data are
                  removed from the list. You need not to worry as the          The moon highlights different aspects
                  data is not lost. Notice the row headings. Some of            at different times, much like filtering
                  the row headings are missing. The unchecked rows               focuses on specific data subsets.
                  have just been hidden from the display. To get the
                  data back, open the filter list again and check the
                  unchecked entries. We can use the Standard Filter to

                  apply advanced filtering criteria. Suppose you want to know the names of the employees from
                  the Sales department who have more than two years of experience.

               36       Plus (Ver. 3.2)-VII
   33   34   35   36   37   38   39   40   41   42   43