Page 26 - TrackpadV2.1_Class8
P. 26

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.  Which function checks whether a condition is true or false?
                         (i)  POWER()                                 (ii)  ELSE

                        (iii)  IF()                                  (iv)  None of these
                     b.  The Sort & Filter command is present under _____________ group.

                         (i)  Editing                                 (ii)  Cells
                        (iii)  Number                                (iv)  Both (i) & (ii)

                     c.  Which key combination is used to filter the data?
                         (i)  Ctrl+Shift+F                            (ii)  Ctrl+Shift+L

                        (iii)  Ctrl+L                                (iv)  Ctrl+F
                     d.  Under which group is the Conditional Formatting command present?

                         (i)  Styles                                  (ii)  Editing
                        (iii)  Font                                  (iv)  Cells





                   24   Trackpad (V2.1)-VII
   21   22   23   24   25   26   27   28   29   30   31