Page 48 - ThinkGPT_V2.1_C7_Flipbook
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 under
                                                                 Editing group in the Home tab.





                                                                                                     3  Select Filter
                                                                                                    option 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    Premium Edition-VII
   43   44   45   46   47   48   49   50   51   52   53