Page 27 - Plus V4 with Adobe class 7
P. 27

Timeline


                       Sorting data means to organise the data in ascending or descending order.


                       Custom sorting is used to apply sorting on more than one column in selected range on different


                     criteria.
                       The filters can be easily applied and removed according to the user’s requirements.

                       Conditional formatting can be applied on the basis of different criteria.







                   Choose the correct option.


                  1.  Under which tab is Sort & Filter command present?

                           a.  Home                                       b.  Insert
                           c.  Formula                                    d.  View

                  2.  We use Sort A to Z option to sort             .

                           a.  Numbers                                    b.  Text

                           c.  Symbols                                    d.  All of these

                  3.   Near which option do small arrows appear when we apply filter feature?
                           a.  Row headers                                b.  Column headers

                           c.  Sheet tab                                  d.  None of these

                  4.   Which of the following is not a category used in conditional formatting?

                           a.  Data Bars                                  b.  A to Z

                           c.  Top/Bottom Rules                           d.  Icon Sets
                  5.   Which option is used to remove conditional formatting?

                           a.  New Rule                                   b.  Clear Rules

                           c.  Remove Rules                               d.  Delete Rules


                    Tick () the correct statements and cross () the wrong ones.

                  1.  Excel can arrange data in ascending order only.

                  2.   You cannot sort more than one column at a time in a selected range of cells.

                  3.   The Add Level button is available under the Insert tab.

                  4.   Sorting can also be done through Sort & Filter group under the Data tab.


                  5.   Conditional Formatting is only used with numeric data.


                                                                                    #Advanced Features of Excel  25
   22   23   24   25   26   27   28   29   30   31   32