Page 19 - TP_V5.1_C7_fb
P. 19

In the previous class, we learned that Excel is a spreadsheet software used to work with numbers,
                 text, formulae and charts. Excel is used when there is a need to handle large sets of data that
                 require various calculations and in-depth analysis. Let's learn some more useful features of Excel.



                           SORTING DATA IN EXCEL


                 It is easy to maintain data in Excel as the sheet is divided into rows and columns but the data may
                 not be arranged in a specific order automatically as we enter it.

                 For such a purpose, Excel provides us with a feature called sorting. Sorting means arranging the
                 data either in ascending or descending order. Data can be sorted in two ways:

                   Ascending order: Arranging data in increasing order, for example, letters from A to Z, numbers
                   from lowest to highest, etc.

                   Descending  order:  Arranging data  in  decreasing  order, for example,  letters  from Z  to  A,
                   numbers from highest to lowest, etc.

                 To sort the data, follow the given steps:


                                                             2  Click on the Sort & Filter command.


                                                                                                    3  For ascending
                                                                                                    order, select
                                                                                                    the Sort A to Z
                                                                                                    option and for
                                                                                                    descending order,
                                                                                                    select the Sort Z
                                                                                                    to A option.












                                             1  Select a column or range
                                             of the data to be sorted.


                 CUSTOM SORTING

                 Even when the data is arranged in ascending or descending order, it can still be sorted again within
                 another column. For example, if Student’s mark list is sorted with respect to Roll No. column, we
                 can still sort it in the Name column. You can do this in Excel using Custom Sort.








                                                                                         Advanced Features of Excel  17
   14   15   16   17   18   19   20   21   22   23   24