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

