Page 30 - TP_Pluse_V2.2_Class_7
P. 30

Step 5:   Click on the Sort by box and select the column header according to which you want to sort
                          the data. In this case, we have selected Client Name header.

                  Step 6:  Click on the Sort On box and select Cell Values option.
                  Step 7:   Click on the Order box and select the A to Z or Z to A option. In this case, we have selected
                          A to Z option.

                  Step 8:   Click on the Add Level button at the top of the Sort dialog box to add another column to sort.
                          In this case, we have added Amount Billed column.

                  Step 9:  Click on the OK button.














                                                              Sort dialog box
                  The data will be sorted according to the criteria defined.





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







                                                             Tech Hint

                                                      To sort data: click Data → Sort




                          Let’s CatCh uP


                    Why sorting is important?
                    ________________________________________________________________________________
                    ________________________________________________________________________________



                         FILTERING DATA


                  You must have studied about filtration process which is used to separate unwanted material from a
                  mixture. Excel also allows you to filter unwanted data from a set of data. To apply filters, follow these
                  steps:
                  Step 1:   Select the range of columns to be filtered.


                  28    Plus (Ver. 2.2)-VII
   25   26   27   28   29   30   31   32   33   34   35