Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2615_KEC
P. 26

    ABSOLUTE CELL REFERENCING                                    Typing the formula (=$A$2 + $B$2)
                      In  absolute cell referencing, cell references in the        in cell C2 for absolute referencing

                      formula remain the same even if we copy and paste the
                      formula to a new location. It is used when you maintain
                      the original references as they were. For this, we need
                      to use the $ (dollar) sign as a prefix before the column
                      name and row number in the formulas.

                      For example, if we want the value of A1 to be  constant
                      when multiplying it with a cell from column B, absolute
                      referencing will be used.

                      When the formula (=$A$2*$B$2) in cell C1 is copied            Displaying constant result after copying
                      and pasted to C2, the values in cells A2 and B2 remain            and pasting formula in cell C3
                      unchanged.

                      MIXED CELL REFERENCING
                      A  mixed cell reference refers  to  a specific  row  or
                      column. It is basically a combination of relative and

                      absolute references. There are times when we may
                      want a part of the cell reference to change when the
                      formula is copied.

                      In some  situations,  you  may  need  to  use  a  ‘Mixed’
                      reference, so that  you  can lock either  a column or
                      a row by preceding it with a Dollar ($) symbol. For
                      example,  when the column letter  changes, the row                            Typing the formula using
                                                                                                     a mixed cell reference
                      stays constant or vice versa.

                                FUNCTIONS

                      A function is a predefined formula in Excel. It starts with the = (equal) sign. Functions are used
                      for computing complex calculations. There are many built-in functions provided by Excel. They
                      accept arguments and return values.

                      Arguments are inputs to the functions. The values should be given in between opening and closing
                      ( ) parenthesis. For example, SUM(A1:A5) A1 and A5 are arguments and Sum is a function.

                      Some rules for using functions are:

                         All Excel functions must begin with = sign
                         Function name must be a valid Excel name.

                         Function must be followed by opening and closing parentheses.

                         Most of the functions must contain atleast one argument within it.

                       24   Premium Edition-VI

| 21 22 23 24 25 26 27 28 29 30 31 |