Microsoft Office Tutorials and References

In Depth Information

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

The next step is to select cell D15 and determine the highest (maximum) number in the range D4:D12.

Excel has 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, as performed in the

following steps.

1

•
Select cell D15.

•
Click the Insert Function box in the

formula bar to display the Insert

Function dialog box.

Insert Function

dialog box

Insert Function button

Or select a

category box

Search for a

function box

•
When Excel displays the Insert

Function dialog box, click MAX

in the ‘Select a function’ list

(Figure 2–19).

MAX selected in

Select a function list

equal sign

automatically

inserted in active

cell and formula bar

Help on this

function link

OK button

Figure 2–19

2

•
Click the OK button.

Function Arguments

dialog box

•
When Excel displays the Function

Arguments dialog box, type

d4:d12
in the Number1 box

(Figure 2–20).

range typed in

Number1 box

Collapse

Dialog button

Why did numbers appear in the

Function Arguments dialog box?

As shown in Figure 2–20, Excel

displays the value the MAX func-

tion will return to cell D15 in the

Function Arguments dialog box. It

also lists the ﬁ rst few numbers in

the selected range, next to the

Number1 box.

ﬁ rst few numbers

in selected range

result of function

last part of function

appears in active cell

Help on this

function link

OK button

Figure 2–20