Page 27 - TP_Plus_v4_Class7
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 tabs                                 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.   Excel also allows you to use custom filter.

                       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