Page 26 - Trackpad_V1_Book 7_Flipbook
P. 26

e.   Which function calculates the total of a given set of values?

                            (i)  POWER()                                   (ii)  SUM()
                           (iii)  IF()                                     (iv)  AVERAGE()

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

                                              Home, SUM(), 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.   Sort & Filter command is present under the _____________ tab.
                      d.   The _____________ calculates the total of a given set of values.
                      e.   _____________ button is used to add another column for sorting.
                  3.  Think and answer.

                      a.   Write the use of the IF function.
                           ____________________________________________________________________________

                      b.   How can we remove the filters from the worksheet in Excel?
                           ____________________________________________________________________________

                           ____________________________________________________________________________

                      c.   How do you apply custom sorting to the data?
                           ____________________________________________________________________________

                           ____________________________________________________________________________
                      d.   Write the steps to apply conditional formatting.

                           ____________________________________________________________________________
                           ____________________________________________________________________________

                      e.   How do you filter the data in Excel?
                           ____________________________________________________________________________

                           ____________________________________________________________________________

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

                      ________________________                                 ________________________

                  5.  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?
                           ____________________________________________________________________________






                   24   Trackpad (Version 1.0)-VII
   21   22   23   24   25   26   27   28   29   30   31