Page 25 - Trackpad_V4.0_c7_Flpbook
P. 25

Check  My data has headers
                                                  4  checkbox, if the selected columns
                                                     have a heading at the top.

                  8   Click on the Add
                      Level button.                                                                 Click on the
                                                                                                    Order box and
                                                                                                    select the A to Z   7
                      Click on the                                                                  or Z to A option.
                      Sort by box
                  5   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                                                         Lab Activity


                    Do a poll/survey of the 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 listing the festivals that each student enjoys, then
                    sort the data alphabetically based on the student's names.





                 FILTERING DATA


                 You must have studied about the filtration process, which is
                 used to separate unwanted material from a mixture. Excel         The moon highlights different aspects
                 also allows you to filter unwanted data from a set of data.       at different times, much like filtering
                                                                                    focuses on specific data subsets.








                                                                                      Advanced Features of Excel    23
   20   21   22   23   24   25   26   27   28   29   30