Page 25 - Trackpad_V1_Book 7_Flipbook
P. 25

uiz   Bee        Write the use of custom sorting.
                                          _________________________________________________________________







                        Hashtag

                      #SUM(): Function is used to calculate the total of a given set of values.
                      #IF(): 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 option 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, the Conditional Formatting command is 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