Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - 2633 Trackpad Pro V5.1 Class 7
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 |