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).
other functions?
Excel has more
functions that
perform just
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

Search JabSto ::

Custom Search