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
 
Search JabSto ::




Custom Search