Page 24 - TP_V5.1_C7_fb
P. 24

2.  Fill in the blanks using the words from the help box.

                                               Color Scales, Sorting, Add Level, Filter


                     a.  The physical arrangement of data in ascending or descending order is called _____________.
                     b.  _____________ option shows the data you wish to see while hiding the rest temporarily.
                     c.  _____________ option is selected when you want to add colour schemes to all selected cells slowly
                        varying from top to bottom items.
                     d.  _____________ button is used to add another column for sorting.

                  3.  Think and answer.
                     a.  How can we remove the filters from the worksheet in Excel?

                      ______________________________________________________________________________________
                     b.  How do you apply custom sorting to the data?

                        ______________________________________________________________________________________
                      ______________________________________________________________________________________

                      ______________________________________________________________________________________

                     c.  Write the steps to apply conditional formatting.
                      ______________________________________________________________________________________

                      ______________________________________________________________________________________
                     d.  How do you filter the data in Excel?
                        ______________________________________________________________________________________

                      ______________________________________________________________________________________

                      ______________________________________________________________________________________

                  4.  Differentiate between the following:
                     Sorting data                                Filtering data
                     __________________________________          __________________________________

                     __________________________________          __________________________________

                  5.  Competency-based/Application-based questions.                                  Experiential Learning

                     a.   Divya 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?
                      ______________________________________________________________________________________
                     b.   Chirag wants to highlight the names of those people on a list who have the same age as him. Which
                        feature can he use for this?

                      ______________________________________________________________________________________
                     c.   Subhash wants to highlight the names of students who have scored marks between 50 and 80 in
                        any subject. Which feature of MS Excel can he use for this?

                      ______________________________________________________________________________________


                   22   Premium Edition-VII
   19   20   21   22   23   24   25   26   27   28   29