Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 55 - 2620_Birla Open Mind C-6
P. 55

    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.

                     A.    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  53

| 50 51 52 53 54 55 56 57 58 59 60 |