Page 76 - IT-802_class_12
P. 76

3.7.2 Multiple Sorting

        Sorting can be applied with multiple columns criteria, where each criterion is applied one after the other. Sorting data
        that is based on more than one field (column) is known as multiple sorting.
        For example, if the worksheet contains the data of 30 students belonging to different groups and classes, multiple
        sorting can be applied to rearrange this data with the names and group codes in alphabetical order.
        Consider a sheet with three columns, viz., S. No., States, and Capital. For multiple sorting, perform the following steps:
         1   Click on the Sort from the Data menu. The Sort dialog box appears.

         2   From the Sort by option in the drop-down list box, select the field name (here, States of India) in which we have
             to apply the sorting.

         3   Click to select the sorting order, i.e., Descending. (Though the default setting is Ascending.)



                           1
                                                                                             2

                                                                                             3














         4   From the Then by option in the drop-down list box, choose another field name (here, Capital) and the sort order
             for this column by clicking on Ascending.










                                                                                         4












         5   From the next Then by option in the drop-down list box, choose another field name (S. No.) and the sort order
             for this column by clicking on Ascending.











          74    Touchpad Information Technology-XII
   71   72   73   74   75   76   77   78   79   80   81