Page 28 - TP_Plus_v4_Class7
P. 28

Q    Answer the following questions:
                  A
                     1.   Define sorting.






                     2.   How do you remove filters?







                     3.   What is the difference between sorting data and filtering data?









                     4.   Write the steps to apply conditional formatting.












                                                                                                    21 st   #Critical Thinking
                     Scratch Your Brain.                                                          Century   #Initiative
                                                                                                   Skills
                     1.   Guess! Who am I?
                          a.  I allow you to sort more than one column at a time.

                         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 an option in Conditional Formatting command that provides criteria like Top 10
                           Items, Top 10%, Bottom 10 Items, etc.
                         e.  I am the order in which the data is arranged from smallest to largest.


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


                     3.   Competency-based/Application-based questions:
                         a.   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
                           can help him in doing his work quickly.
                         b.   Chetan wants to see the names of those people from a list who have the same age as him. Which
                           feature can he use for this?






                  26  Plus (Ver. 4.0)-VII
   23   24   25   26   27   28   29   30   31   32   33