Page 70 - modular4.0
P. 70

Chapter Profile
                  Perform the following steps to use the Pivot Table:

                            2  Click on the
                           Insert tab.


                    3   Click  on  the  Pivot
                    Table  command  from
                    the Tables group.


                                                                                                   1   Select  the  data
                                                                                                   on  which  you  want
                                                                                                   to apply Pivot Table
                                                                                                   command.










                                                                                                                                            Exercise


                                                                                                                                            A.   Tick ( ) the correct option.

                                                                                                                                                 1.  A form displays                   record at a time.
                                                                                                                                                     a.  One                                       b.  two

                                                                                                                                                     c.   three                                    d.  many
                                                                                                                                                 2.   Which facility of Excel is used to hide data in a range of cells so that only the data that meets certain
                                                                                                                                                     criteria is visible?

                                                                                                                                                     a.  Custom Sort                               b.  Filter
                                                      4  Click on the OK button.
                                                                                                                                                     c.   Conditional Filter                       d.  Data Validation

                                                                                                                                                 3.   Which option of Conditional Formatting is selected when you want to highlight all cells satisfying a
                                                                                                                                                     given condition?
                                                                                                                                                     a.  Top/Bottom Rules                          b.  Percent Rules
                                                                                       6   Similarly,  drag  the                                     c.  Highlight Cell Rules                      d.  Data bars
                                                                                       Department  column
                                                                                       into  Column Labels                                       4.  In which tab is Pivot table feature present?
                                                                                       box.
                                                                                                                                                     a.  Home                                      b.  Formula
                                                                                       7  Finally, drag the                                          c.  Insert                                    d.  Page Layout
                                                                                       Total  column  into                                       5.  Which of the following is not a tab option of Data Validation dialog box?
                                                                                       Values box.
                                          5  Drag the Employee Name column from                                                                      a.  Settings                                  b.  Input Message
                                         Choose  fields to add to report box and                                                                     c.  Error Alert                               d.  Define Range
                                         drop into Row Labels box.


                  Your report will appear on the worksheet.



                68   Modular (Ver. 4.0)-VII
   65   66   67   68   69   70   71   72   73   74   75