Page 22 - TP_Prime_V2.2_Class7
P. 22

The chart will change to Line Chart similar to this.











           Prime (Ver. 2.2)-VII  Sorting Data                  Line chart









                  Every day, you deal with a lot of data. It is easier to work with sorted data. Sorting of data
                  means to organise the data in ascending or descending order. Excel allows you to sort both
                  numeric and textual data. You can sort the data according to a particular column as well as

          20      a range of data. You can sort the data according to a particular column as well as a range
                  of data.
                  To sort data, follow these steps:

                  Step 1:  Select  a  column  or  range  of  data  to  be

                            sorted.  In  this  case,  we  have  selected
                            the range A3:D8.                                               Selected data
                  Step 2:  Click on the Sort & Filter command from the Editing group under

                            the Home tab. A drop-down list appears.
                  Step 3:  Click on the Sort A to Z (for text) and Sort Smallest to Largest

                            (for numbers) to sort the data in ascending order.
                  The selected data will be sorted according to the names in ascending order.
                                                                                                           Sorting data

                   Custom Sorting
                  In case, more than one columns are to be sorted in such a way that the first column is in

                  ascending order and if some data is same for more than one rows then the second column
                  of such rows gets sorted in descending order. You can do this in Excel using Custom Sort.
                  To use C ustom Sorting, follow these steps:

                  Step 1:  Select the range of columns to be sorted.

                  Step 2:  Click on the Sort & Filter
                            command from the Editing

                            group  under  Home  tab.  A
                            drop-down list appears.                       Selected data                  Custom sorting

                  Step 3:  Click on the Custom Sort option from the drop-down list.
   17   18   19   20   21   22   23   24   25   26   27