Page 49 - Plus V4 with Adobe class 6
P. 49

Choose the correct option.

                   1.  Which one of the following cell references can be included in relative reference?

                            a.  A3                                         b.  $A$4

                            c.  A$1                                        d.  $D6
                   2.  Which of the following functions is used to calculate the average of a range of values?

                            a.  Average                                    b.  SUM

                            c.  AVG                                        d.  None of these

                   3.  Which of the following options is known as  the cell address in the formula?

                            a.  Range                                      b.  Cell reference
                            c.  Mixed reference                            d.  None of these

                   4.  Which of the following is called group of selected cells?

                            a.  Selection                                  b.  Combination

                            c.  Cell range                                 d.  None of these
                   5.  Which of the following is not a component of chart?

                            a.  Chart Title                                b.  Data Series

                            c.  Gridlines                                  d.  Formula


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

                   1.  Every function begins with a + sign.

                   2.  Combined reference is a type of cell reference.

                   3.  The NOW( ) function is used to display the current date.
                   4.  Excel does not provide functions for working on textual content.

                   5.  The MAX( ) function returns the largest value from a set of values.

                   6.  The chart area includes all the objects and elements of a chart.


                   Fill in the blanks with the correct words.


                                      Hints  equal, square root,   Functions, MIN(), dollar($)

                   1.                 are predefined formulas in Excel.

                   2.  Formulas in Excel begin with the              sign.
                   3.  The SQRT function returns the               of the given number.

                   4.   In Mixed Referencing, you can lock either a column or a row by preceding it with a    symbol.

                   5.  The                function returns the smallest value.


                                                                          #Charts, Formulas and Functions in Excel  47
   44   45   46   47   48   49   50   51   52   53   54