Page 26 - Trackpad_V1_Book 6_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 Typing the formula using
a mixed cell reference a mixed cell reference
Displaying a constant result after copying
and pasting the formula in cell C3
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, 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 parenthesis.
Most of the functions must contain an argument within it.
Let’s discuss the categories of function.
24 Trackpad (Version 1.0)-VI

