Page 39 - Computer Genius Class 07
P. 39

Filtering Data
                  ou must ha e studied a out filtration process  hich is used to separate un anted material  rom a
                 mi ture.   cel also pro ides you to filter un anted data  rom a set o  data.

                 To apply filters   ollo  the gi en steps


                                                                2  Click Sort & Filter command.





                                                                                                  3  Click Filter from
                                                                                                  the drop do n 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 do n 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.  otice the ro  headings. Some o  the ro  headings are missing. The unchec ed ro s
                 ha e  ust  een hidden  rom the display. To get the data  ac   open the filter list again and chec  the
                 unchecked entries.


                                                                             Advanced Features of Excel 2016  37
   34   35   36   37   38   39   40   41   42   43   44