Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 22 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 22

    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

| 17 18 19 20 21 22 23 24 25 26 27 |