Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - 2626_South Point_C-7
P. 35

    a.  What is the difference between sorting data and filtering data?
                        b.   Write the names of the criteria on the basis of which conditional formatting can be applied.

                        c.  Write the steps to apply Custom Sort feature.
                        d.  Write the steps to apply conditional formatting.

                                                                                            fun Zone

                        Let's soLve                                                                    Experiential Learning

                         1.   Application based question.
                              John is preparing a list of students with their marks obtained in exams. He wants to arrange
                            the data in ascending order according to the students names. Suggest him a feature of Excel
                            which helps him in doing his work quickly.
                         2.   Guess who am I?                                                             Critical Thinking

                              a.   I am a group of the Home tab that contains the Sort & Filter command.    ____________
                            b.   I am a feature in Excel to separate unwanted data from a range of data.   ____________
                            c.   I am a feature in Excel to arrange data in ascending or descending order.   ____________
                            d.  I am a type of formatting that can be applied on the basis of a criteria.    ____________
                            e.  I am the order in which the data is arranged from smallest to largest.     ____________

                         Let's exPLore

                           Find out the various ways in which people organise data to make their everyday work easier.
                         You can start this by asking a shopkeeper.

                         teCh PraCtiCe                                                                    Interdisciplinary

                       1.   Make a list of your 10 friends in Excel. Make columns for the distance of their home
                          from school, distance of post office from their home, etc. Use sorting to arrange data in
                          an order. Highlight the cells which have distance less than 2.5 km in any cell.

                       2.   Make a list of 15 teachers and subjects taught by them. Apply Filters on the subject’s
                          field. Take printouts of various filter options of subjects and their result.

                                                            For The Teacher

                           Demonstrate to the students the concepts discussed in the chapter.
                           Make the students understand differences between filtering and sorting features.

                                                                                            Advanced Features of Excel  33

| 30 31 32 33 34 35 36 37 38 39 40 |