Page 48 - Digicode_AI_class_7
P. 48

Filtering Data

            You must have studied about filtration process which is used to separate unwanted material from a
            mixture. Excel also provides you to filter unwanted data from a set of data.
            To apply filters, follow the given steps:


                                                           2  Click Sort & Filter command.





                                                                                             3  Click Filter from
                                                                                             the drop-down list.



              1  Select the
              range of columns
              to be filtered.





                                                           4  Click on the arrow in front of the header
                                                           Marks Obtained to open a drop-down list.






















                         5  Click some of
                         the checkboxes
                         to uncheck them.







                                                   6  Click on the OK button.


            You will notice that the rows of unchecked data are removed from the list. You need not worry as the
            data is not lost. Notice the row headings. Some of the row headings are missing. The unchecked rows
            have just been hidden from the display. To get the data back, open the filter list again and check the
            unchecked entries.


                 46    DigiCode AI-VII
   43   44   45   46   47   48   49   50   51   52   53