Page 231 - CA_165_V2.0_C9_Flipbook
P. 231

Solved Exercise


                                                              SECTION A

                                                      (Objective Type Questions)
                 A. Multiple choice questions.
                     1.     To create an absolute cell referencing, a sign that is put before the row number and column name in the
                         cell address is:
                         i.  $                                               ii.  +
                         iii.  =                                             iv.  None of these

                     2.     A chart that represents the data or value of each item in proportion or percentage to the sum value of all
                         items:

                         i.  Column Chart                                    ii.  Bar Chart
                         iii.  Pie Chart                                     iv.  Line Chart
                     3.   The set of values that the user wants to plot in the chart is:
                         i.  Data Series                                     ii.  Data range
                         iii.  Chart Elements                                iv.  None of these

                     4.   This option filters data according to specific value or string:
                         i.  Autofilter                                      ii.  Standard Filter
                         iii.  Advanced Filter                               iv.  None of these
                     5.   Which of the following errors occurs when an invalid numeric value is used in a formula or function?

                         i.  #VALUE!                                         ii.  #REF!
                         iii.  #DIV/0!                                       iv.  #NUM!
                     6.   Which of the following is a built-in function to calculate the average of values in OpenOffice Calc?
                         i.  Median()                                        ii.  AVG()
                         iii.  AVERAGE()                                     iv.  AVER()


                     Ans. 1. i.    2. iii.   3. i.   4. ii.   5. iv.   6. iii.

                 B.   Fill in the blanks.
                     1.  ..................................... function produces the largest value from the given range of cells.
                     2.  ..................................... is a symbol that performs certain mathematical or logical operations.
                     3.  ..................................... is a quick and easy way to get required information from the subset of data in a range
                         of cells.

                     4.  ..................................... helps to identify the plotted data series.
                     5.     Cell referencing which is combination of absolute and relative referencing is called .....................................
                         referencing.

                     Ans. 1. MAX( )   2. Operator   3. Filtering   4. Legend    5. Mixed







                                                                                                Data Analysis    229
   226   227   228   229   230   231   232   233   234   235   236