Microsoft Office Tutorials and References

In Depth Information

**Session 2.1**

Figure 2-2

Math and Statistical functions

Function

Description

AVERAGE(
number1
, [
number2
,
number3
, ...])

Calculates the average of a collection of numbers, where

number1
,
number2
, and so forth are numeric values or

cell references

COUNT(
value1
, [
value2
,
value3
, ...])

Calculates the total number of values, where
value1
,

value2
, and so forth are numeric values, text entries, or

cell references

MAX(
number
1, [
number2
,
number3
, ...])

Calculates the maximum of a collection of numbers, where

number1
,
number2
, and so forth are either numeric values

or cell references

MEDIAN(
number1
, [
number2
,
number3
, ...])

Calculates the median, or the number in the middle, of a

collection of numbers, where
number1
,
number2
, and so

forth are either numeric values or cell references

MIN(
number1
, [
number2
,
number3
, ...])

Calculates the minimum of a collection of numbers, where

number1
,
number2
, and so forth are either numeric values

or cell references

ROUND(
number
,
num_digits
)

Rounds a number to a specified number of digits, where

number
is the number you want to round and
num_digits

specifies the number of digits to which you want to round

the number

SUM(
number1
, [
number2
,
number3
, ...])

Calculates the sum of a collection of numbers, where

number1
,
number2
, and so forth are either numeric values

or cell references

For example, the
AVERAGE function
calculates the average value of a collection of

numbers. The syntax of this function is AVERAGE(
number1,
[
number2
, …]). When you

enter the arguments
(number1, number2)
, you can enter these numbers directly into the

function, as in AVERAGE(3, 2, 5, 8), or you can enter the references to the worksheet cells

that contain those numbers, as in AVERAGE(A1:A4). You can also enter a function as part

of a larger formula. For example, the formula
=MAX(A1:A100)/100
calculates the maxi-

mum value in the cell range A1:A100 and then divides that number by 100. You can

include, or “nest,” one function within another. For example, in the formula

=ROUND(AVERAGE(A1:A100),1)
, the first argument in the ROUND function uses the

value calculated by the AVERAGE function; the second argument is a constant. The result

is a formula that calculates the average value of the numbers in the range A1:A100,

rounding that value to the first decimal place.

In the previous tutorial, you calculated totals using the AutoSum button on the

Standard toolbar. Although using the AutoSum feature is a quick and convenient way to

calculate a value, it is only one way to perform this calculation in Excel. To determine the

totals Amanda wants, you can also use the
SUM function
, which calculates the sum of a

collection of numbers. The syntax of the SUM function is SUM(
number1,
[
number2
, …]),

which is similar to that of the AVERAGE function.

You’ll use the SUM function now to begin calculating the values Amanda needs, start-

ing with the values for the month of January.