Page 27 - trackpad v5.1 class 7 flipbook
P. 27

uiz   Bee        Write the use of custom sorting.
                                          _________________________________________________________________








                        Hashtag

                      #SUM(): This function is used to calculate the total of a given set of values
                      #IF(): This function is used to check a condition to be evaluated as True or False






                      REVISIT


                   ▶   The SUM() function calculates the total of a given set of values.
                   ▶   The IF() function checks a condition to be evaluated as True or False, and based on the result, suitable
                     actions are performed.
                   ▶   The physical arrangement of data in ascending or descending order is called sorting.
                   ▶   The feature of viewing rows of data suiting a specified selection criterion is called filtering data.













                 1.  Tick ( ) the correct option.
                    a.  What function in Excel is used to calculate the total of a given set of values?

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

                    b.  Which of the following is used to check a condition and take action based on the results in Excel?
                        (i)  SUM()                                        (ii)  AVERAGE()
                       (iii)  IF()                                        (iv)  COUNT()

                    c.  What feature in Excel allows you to arrange data in increasing or decreasing order?
                        (i)  Filtering                                    (ii)   Sorting

                       (iii)  Conditional Formatting                      (iv)   Data Validation
                    d.  To filter data in Excel, which command do you use?
                        (i)  Sort & Filter                                (ii)   Data Validation

                       (iii)  Pivot Table                                 (iv)   Conditional Formatting



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