Page 35 - iprime_V2.2_class8
P. 35

Using Sort & Filter Command
                 Step 3  Click Sort A to Z (for text) and Sort Smallest to Largest (for numbers) to sort the data
                         in ascending order.

                 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:
                 Step 1  Select the range of columns to be sorted.
                 Step 2  Click on the Sort & Filter command from the Editing group under the Home tab to open a
                         drop-down list.
                 Step 3  Click on the Custom Sort option from the drop-down list to open the Sort dialog box.

                 Step 4  Check My Data Has Headers checkbox if the selected columns have a heading at the top.
                 Step 5  Click on the Sort By box to open a list of column headers. Select a column head, for
                         example, ‘Marks Obtained’.
                 Step 6  Click on the Sort On box to select the Values option.

                 Step 7  Click on the Order box to select the A to Z option in case of text data and the Smallest
                         to Largest option for numerical data.
                 Step 8  Click on the Add Level button at the top of the dialog box. This will add one more row
                         to define the new criteria.
                 Step 9  Repeat steps 5 to 7 to add more criteria.

                 Step 10 Click on the OK button.
                 The data will be sorted according to the criteria defined.
                 Clickipedia


                   The sorting can also be done through the Sort & Filter group under the Data tab by selecting

                        and      commands for sorting in ascending and descending order, respectively. To

                   create, a custom sort, click on       command.





                                    If Excel was a magical library, how would you sort books and filter books you
                                    had read?




                                                                             Spreadsheet—Functions and Charts      33
   30   31   32   33   34   35   36   37   38   39   40