Page 23 - TP_V5.1_C7_fb
P. 23

uiz   Bee        Write the use of custom sorting.
                                          _________________________________________________________________







                        Hashtag

                      #Sorting: A method of arranging data in ascending or descending order.
                      #Filtering: This allows us to see the important data and hide the rest data temporarily from the
                      set of data.





                      REVISIT



                   ▶   The physical arrangement of data in ascending or descending order is called sorting.
                   ▶   Custom sorting is used to apply sorting on more than one column in selected range on different criteria.
                   ▶   The feature of viewing rows of data suiting a specified selection criterion is called filtering data.
                   ▶   Custom sorting is used to apply sorting on more than one column in selected range on different criteria.










                 1.  Tick ( ) the correct option.

                    a.  Which of the following options is used to sort the data in descending order?
                        (i)  Sort Z to A                            (ii)  Sort A to Z

                       (iii)  Filter                                (iv)  None of these
                    b.   Which of the following features is used to view rows of data suiting a specified selection
                      criterion?
                        (i)  Sorting                                (ii)  Data Bars

                       (iii)  Filter                                (iv)  Both (i) & (ii)
                    c.   Which of the following options is suitable when you want to highlight all the cells satisfying
                      a given condition?
                        (i)  Data Bars                              (ii)  Highlight Cells Rules

                       (iii)  Color Scales                          (iv)  None of these
                    d.  Which of the following is not a category used in conditional formatting?
                        (i)  Data Bars                              (ii)  New Cell Style

                       (iii)  Top/Bottom Rules                      (iv)  Icon Sets



                                                                                         Advanced Features of Excel  21
   18   19   20   21   22   23   24   25   26   27   28