Page 28 - TP_Prime_V2.2_Class7
P. 28

d.  When we apply filter feature, small arrows appear near _______________.

                         (i)  Row headers                              (ii)  Column headers

                         (iii)  Sheet tab                              (iv)  Second Row
                      e.  Which of these is not a category used in conditional formatting?

                         (i)  Data Bars                                (ii)  A to Z
           Prime (Ver. 2.2)-VII  2.  Write ‘T’ for true and ‘F’ for false.                                  ________
                                                                       (iv)  Icon Sets
                         (iii)  Top/Bottom Rules




                      a.  Excel can arrange data in ascending order only.
                      b.  You cannot sort more than one columns at a time in a

                         selected range of cells.

                                                                                                            ________
                         c.  The Add Level button is available under the Insert tab.                        ________
          26          d.  Sorting can also be done through Sort & Filter group under the
                         Data tab.                                                                          ________
                      e.  Conditional Formatting is only used with numeric data.                            ________


                      Evaluation Time


                  1.  Fill in the blanks using the hints given below:


                                     Styles, Filters, Column, Conditional Formatting, Custom sort



                      a.  _______________ chart is used to compare values across categories.

                      b.   _______________  is  used  when  data  is  to  be  sorted  on  the  basis  of  more  than  one
                         criteria.

                      c.   The Conditional Formatting option is available in _______________ group under the Home
                         tab.

                      d.  Color Scales is a feature available in _______________.

                      e.  _______________ are used to separate required data from a set of data.

                  2.  Short answer type questions.

                      a.  What is a Pie chart?

                      b.  Define sorting.

                      c.  How do you remove filters?

                      d.  Which command is used to hide unimportant data?
   23   24   25   26   27   28   29   30   31   32   33