Page 23 - Plus V4 with Adobe class 7
P. 23

To use Custom Sorting, follow these steps:

                                                             2
                                                                 Click on the Sort & Filter command.









                          Select the range
                      1   of columns  to
                          be sorted.
                                                                                 3   Click on the Custom
                                                                                     Sort option.



                                                    Check  My data has
                                                    headers checkbox, if the
                8   Click  on the  Add  Level   4   selected columns have a
                    button.                         heading at the top.


                                                                                        Click on the Order box
                                                                                        and select the  A to Z   7
                                                                                        or Z to A option.

                   Click  on the  Sort by
               5   box and select the
                   column header.


                                                           Click on the Sort On box and   6
                                                           select Cell Values option.




                                                                                      Hintbot


                                                                              To sort data: click
                          9
                             Click on the OK button.                             Data   Sort




                      Experiential Learning

                      #Sorting


              Do a poll/survey of students of your class on festivals of India. Visit https://utsav.gov.in/ and find the
              relevant information about each festival. Create an Excel sheet of the festival each student likes
              and sort the data according to the name of the student alphabetically.
                                                                                                          #Activity




                                                                                    #Advanced Features of Excel  21
   18   19   20   21   22   23   24   25   26   27   28