Page 35 - Plus_V2.2_C7_Flipbook
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