Page 61 - TP_Modular_V2.1_Class7
P. 61

Step 5   Click the Sort by box to open list of column headers. Select a column head, for example
                         ‘Marks Obtained’.

                 Step 6  Click on the Sort On box to select Values option.
                 Step 7   Click on the Order box to select A to Z option in case of text data and Smallest to
                         Largest option in case of values.

                 Step 8   Click on the Add Level button on the top of the dialog box. This will add one more row
                         to define new criteria.
                 Step 9  Repeat steps 5 to 7 to sort Marks in previous term column in descending order.

                 Step 10 Click on the OK button. The data will be sorted according to the criteria defined.














                                       Sort dialog box                                Sorted data
                    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:

                 Step 1  Select the range of columns to be filtered.
                 Step 2   Click on the  Sort & Filter command from  Editing
                         group under Home tab to open a drop-down list.
                 Step 3   Select  the  Filter  option  from  the  drop-down  list.

                         You will notice that small arrows       appear in front
                                                                                              Unfiltered data
                         of all the column headers.
                 Step 4   Click on  the  arrow  in front  of  the  header  Marks
                         Obtained 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.  Click
                         some of the checkboxes to uncheck them. Click on
                         the OK button.                                                        Filtered data

                 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.

                 Suppose, you want to know the names of the students who have scored more than 80 marks.



                                                                                           Excel as Database      59
   56   57   58   59   60   61   62   63   64   65   66