Page 28 - Plus V4 with Adobe class 7
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 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.


               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.   Akriti was making a list of all the students of her class. She wishes to sort them alphabetically.
                     Which type of sorting can she use for this?

                   c.   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