Microsoft Office Tutorials and References

In Depth Information

**Using the AVERAGE, MAX, and MIN Functions**

To Determine the Highest Number in a Range of Numbers Using the Insert Function Box

The next step is to select cell C15 and determine the highest (maximum) number in the range C4:C12. Excel

includes a function called the
MAX function
that displays the highest value in a range. Although you could enter

the MAX function using the keyboard and Point mode as described in the previous steps, an alternative method

to entering the function is to use the Insert Function box in the formula bar. The following steps use the Insert

Function box in the formula bar to enter the MAX function.

1

•

Select the cell to

contain the maximum

number, cell C15 in

this case.

Insert Function

dialog box

Insert Function box

•

Click the Insert

Function box in the

formula bar to display

the Insert Function

dialog box.

equal sign

automatically

inserted in

active cell and

formula bar

Search for a

function box

•

Click MAX in the

Or select a

category box

‘Select a function’

list (Insert Function

dialog box) to select

it (Figure 2 – 19). If

the MAX function is

not displayed in the

‘Select a function’ list,

scroll the list until the

function is displayed.

MAX selected in

Select a function list

Help on this

function link

OK button

Figure 2 – 19

2

•

Click the OK button

(Insert Function dialog

box) to display the

Function Arguments

dialog box.

Function Arguments

dialog box

function appears

in formula bar

range typed in

Number 1 box

•
c4:c12
in

the Number1 box

(Function Arguments

dialog box) to enter

the i rst argument

of the function

(Figure 2 – 20).

Why did numbers

appear in the

Function Arguments

dialog box?

As shown in

Figure 2 – 20, Excel

displays the value

the MAX function

will return to cell

C15 in the Function

Arguments dialog

box. It also lists the i rst few numbers in the selected range, next to the Number1 box.

Type

Collapse Dialog button

i rst few numbers

in selected range

result of function

OK button

Help on this

function link

last part of function

appears in active cell

Figure 2 – 20