Page 27 - KEC Khaitan C6 Flipbook
P. 27

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.


                                                                                 Formulas and Functions in Excel 2021  25
   22   23   24   25   26   27   28   29   30   31   32