Page 34 - iPro_trackGPT_V5_Class8
P. 34

The chart will change to the selected  line chart.



















                     SORTING DATA

                  Sorting means arranging data in a certain order, like ascending (from smallest to largest) or
                  descending (from largest to smallest) order. It helps you to organise and find information more
                  easily.

                                                           3  Click on the Sort & Filter command.



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

                  Note that, if you want to sort the number, then Sort A to Z and Sort Z to A options changes to
                  Sort Smallest to Largest and Sort Largest to Smallest options, respectively.

                  The selected data gets arranged in ascending order.
















                  When we sort data by one column, the values in the other columns move with it to keep all the
                  rows intact.

                  Custom Sort

                  When you need to sort multiple columns, with the first column in ascending order and, for rows
                  with the same data in the first column, sorting the second column in descending order, you can




                    32    TrackGPT iPRO (V5.0)-VIII
   29   30   31   32   33   34   35   36   37   38   39