Page 33 - Trackpad_ipro 4.1_Class8
P. 33

The chart will change to a Line Chart similar to this.

















                     SORTING DATA

                 Excel can arrange the selected data in either ascending or descending order. This is called sorting
                 of data. To sort data, follow these steps:


                                                               3  Click on the Sort & Filter command.



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

                 The selected data gets arranged in ascending order.

                 Custom Sort

                 If you need to sort multiple columns such that the first column is in ascending order and, for
                 rows with identical data in the first column, the second column is sorted in descending order.
                 You can do this in Excel using Custom Sort.
                 To use Custom Sort, follow these steps:

                                                                  3  Click on the Sort & Filter command.



                         2  Click on
                         Home tab.
                                                                                                    4  Click on
                                                                                                   the Custom
                                                                                                   Sort option.

                        1  Select
                        the range of
                        columns to
                        be sorted.




                                                                             Spreadsheet—Functions and Charts    31
   28   29   30   31   32   33   34   35   36   37   38