Microsoft Office Tutorials and References

In Depth Information

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

4

•
to determine the

lowest value in the

range C4:C12 and

display the result in

the formula bar and

in the selected cell

(Figure 2 – 25).

How can I learn about

other functions?

Excel has more

than 400 additional

functions that

perform just

about every type

of calculation

you can imagine.

These functions

are categorized in

the Insert Function

dialog box shown in

Figure 2 – 19 on page

EX 86. To view the

categories, click the ‘Or select a category’ box arrow. To obtain a description of a selected

function, select its name in the Insert Function dialog box. Excel displays the description of

the function below the Select a function list in the dialog box.

Click the Enter box

MIN function determines

lowest value in range C4:C12

result of MIN function

appears in cell

Figure 2 – 25

Other Ways

1. Click Insert Function box

in the formula bar (if

necessary, select Statistical

category), click MIN

2. Click Sum button arrow

(Formulas tab | Function

Library group), click Min

3. Type
=MIN
in cell

To Copy a Range of Cells Across Columns to an Adjacent Range Using the Fill Handle

The next step is to copy the AVERAGE, MAX, and MIN functions in the range C14:C16 to the adjacent

range D14:J16. The following steps use the i ll handle to copy the functions.

1

•

Select the source

copy range

C14:C16

selected

range from which to

copy the functions, in

this case C14:C16.

•

Drag the i ll handle

in the lower-right

corner of the selected

range through

cell J16 and continue

to hold down the

mouse button to

begin a i ll operation

(Figure 2 – 26).

i ll handle dragged to select

destination area, range D14:J16

mouse pointer

Figure 2 – 26