Page 26 - Chinmaya_C6_flipbook
P. 26
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 make the cell reference as 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 stays constant or vice versa.
Typing the formula using
a mixed cell reference
FUNCTIONS
A function is a predefined formula in Excel. It starts with the = (equal to) 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 input to the functions. The values should be given in between opening and closing
( ) parenthesis. For example, in SUM(A1:A5), A1 and A5 are arguments and Sum is a function.
Some rules for using the functions are as follows:
All Excel functions must begin with = sign.
Function name must be a valid Excel name.
Function must be followed by opening and closing parenthesis.
Most of the functions must contain an argument within it.
Let’s discuss the categories of function.
24 Premium Edition-VI

