Page 65 - modular4.0
P. 65

Chapter Profile
                        FILTERING DATA


                 You must have studied about filtration process which is used to separate unwanted material from a

                 mixture. Excel also provides you with the ability to filter unwanted data from a set of data.

                 Follow the given steps to apply filter:

                                                                                                2  Click on the
                                                                                             Sort  &  Filter
                                                                                             command.


                                                                                              3  Select Filter
                                                                                             options.








                              1  Select the range of columns to be filtered.



                   4  Click on the
                  arrow in front
                  of  the  header
                  Marks Obtained
                  in Second Term.




                   5  Click some of
                  the check boxes
                  to uncheck them.



                                          6  Click on the OK button.

                 Now, suppose  you want to see rows of students  who  scored more than 80  in Marks Obtained
                 in Second Term. Number Filters in Excel allow you to filter numeric data in a column based on
                 conditions like greater than, less than, or equal to a specific number. This is useful for large datasets
                 as it eliminates the need to manually check and uncheck values.
                 Follow the given steps to use Number Filters option:

                  1  Select the range of columns                                                 2   Click  on  the
                  and apply filters.                                                             Marks Obtained
                                                                                                 in Second Term
                                                                                                 header.

                    3   Place  your  mouse  over
                    the Number Filters option.                                                   4  Select the Greater
                                                                                                 Than option.





                                                                                                   Excel as Database  63
   60   61   62   63   64   65   66   67   68   69   70