Page 35 - TP_iPlus_V2.1_Class8
P. 35

i +  SORTING DATA

                 Sorting of data refers to the process of arranging data in ascending or descending order based
                 on a certain criteria. To sort data, follow the given steps:


                                                                 3  Click on the Sort & Filter command.



                    2  Click on
                   the Home                                                                           4  Select Sort
                                                                                                     A to Z (for
                   tab.
                                                                                                     text) or Sort
                                                                                                     Smallest to
                                                                                                     Largest (for
                      1  Select                                                                      numbers) to
                     the data                                                                        sort the data
                     to be                                                                           in ascending
                     sorted.                                                                         order.







                 The selected data gets arranged in ascending order.

                 Custom Sort

                 In case more than one column is to be sorted in such a way that the first column is in ascending
                 order and if some data is the same for more than one row, then the second column of such rows
                 gets sorted in descending order. You can do this in Excel using Custom Sort.
                 To use Custom Sort, follow the given steps:


                                                                 3  Click on the Sort & Filter command.


                   2  Click on the
                   Home tab.

                                                                                                        4   Click on
                                                                                                        the Custom
                                                                                                        Sort option.
                     1  Select
                     the range of
                     columns to
                     be sorted.
















                                                                                                                  33
                                                                              Spreadsheet—Functions and Charts
   30   31   32   33   34   35   36   37   38   39   40