Page 35 - iPlus_Ver_2.0_class_8
P. 35

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.




                   9  Click on the Add                                        8  Click on the Order box to select
                  Level button to            7  Click on the Sort On box      A to Z (for text) and Smallest to
                  define a new criteria.     to select Cell Values option.    Largest (for numbers).

















                                                                       5  Check My data has headers checkbox if the
                                 6  Click on the Sort by box to        selected columns have a heading at the top.
                                 select a column head for sorting.






                       10 Repeat steps 6 to 8 to
                       sort Marks in previous term                             11 Click on the OK button.
                       column in descending order.


                 The data will be sorted according to the criteria defined.
                    Quick Byte


                     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.












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