Page 25 - Trackpad_V5_Book 7
P. 25

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





                                                                                    Advanced Features of Excel  23
   20   21   22   23   24   25   26   27   28   29   30