Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - 2610_Springdales_C-7
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 |