Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 18 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 18

    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

| 13 14 15 16 17 18 19 20 21 22 23 |