Page 27 - TrackpadV2.1_Class8
P. 27

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, AVERAGE(), 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 _____________ function calculates the average 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 can custom sorting be useful in Excel? Give an example.
                     ______________________________________________________________________________________

                     ______________________________________________________________________________________

                     ______________________________________________________________________________________
                    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
                    __________________________________          __________________________________

                    __________________________________          __________________________________

                                                                                                 21 st
                 5.  Application-based questions.                                              Century   #Technology Literacy
                                                                                                 Skills
                    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?



                                                                                         Advanced Features of Excel  25
   22   23   24   25   26   27   28   29   30   31   32