Page 23 - TP_Plus_v4_Class7
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
                      8   Click  on the  Add  Level                                 checkbox, if the selected columns   4
                          button.
                                                                                    have a 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
                                                                                       Data   Sort



                  9   Similarly, set the  sorting  criteria for the
                      second column and click on the OK button.


                           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