
244
1
2
3
4
1
2
3
4
5
1
0
7
2
4
A
V
E
R
A
G
E
F
U
N
C
T
I
O
N
9
.
2
5
9
.
2
5
9
.
2
5
1
2
3
4
1
2
3
4
Understanding
Excel Functions
To build powerful and useful formulas, you often need to include one or more Excel
functions as operands. You need to understand the advantages of using functions, you need to
know the basic structure of every function, and you need to review Excel’s function types.
FUNCTIONS
A function is a predefined formula
that performs a specific task. For
example, the SUM function
calculates the total of a list of
numbers, and the PMT (payment)
function calculates a loan or
mortgage payment. You can use
functions on their own, preceded
by =, ...