Page 51 - TP_Plus_v4_Class6
P. 51

Double Tap                                              Century   #Technology Literacy
                                                                                    21 st
                                                                                   Skills  #Productivity & Accountability

                        Write the output of the following:
                        a.  =MIN (5,7,8)                               d.  =TODAY()

                        b.  =Left("Computer", 4)                       e.  =LEN("Touch")
                        c.  =AVERAGE(12,3,6)                           f.  =COUNT(4,8,12)




                           Timeline


                            A cell reference is a cell address that can be used in a formula to denote a specific cell.

                            By default, all cell references are Relative references and makes the cells reference free.

                            If you wish to maintain the original references as they were, then you should make use of the absolute
                         references.
                            A mixed reference is a reference that is a combination of absolute and relative reference. It refers to
                         a specific row or column.
                            Functions are predefined formulas in Excel to perform both simple and complex calculations.
                            Operators are the symbols that specify what calculations to be performed.







                        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



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