Page 55 - ModularV1.1 _c7_flipbook
P. 55

Step 4   Check My data has headers checkbox if the selected columns have a heading at the top.

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

                 Step 7   Click the Order box to select the A to Z option in case of text data and Smallest to
                         Largest option in case of numerical data.
                 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 the filtration process that is used to separate unwanted materials
                 from a mixture. Excel also provides you to filter unwanted data from a set of data.
                 To apply filters, follow these steps:

                 Step 1  Select the range of columns to be filtered.
                 Step 2   Click the  Sort  &  Filter command from the  Editing
                         group under the Home tab to open a drop-down list.
                 Step 3   Click Filter from the drop-down list. You will notice
                         that small arrows     appear in front of all the column
                         headers.
                                                                                              Unfiltered data
                 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.













                                 Using Filter command                        Filtered data



                                                                                              Excel as Database   53
   50   51   52   53   54   55   56   57   58   59   60