Microsoft Office Tutorials and References
In Depth Information
To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle
4
Click the Enter box to determine
the lowest value in D4:D12 and
display the result in the formula
bar and in cell D14 (Figure 2–25).
How can I use other functions?
Excel has more than 400 additional
functions that perform just about
every type of calculation you can
imagine. These functions are cat-
egorized in the Insert Function
dialog box shown in Figure 2–19
on page EX 101. 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.
MIN function
determines lowest
value in range D4:D12
result of MIN function
appears in cell
Figure 2–25
Other Ways
1. Click Insert Function box
in formula bar, click MIN
function
2. Click Formulas tab on
Ribbon, click AutoSum
button arrow, click Min
function
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 D14:D16 to the adjacent
range E14:J16. The following steps use the fi ll handle to copy the functions.
1
Select the
range D14:D16.
copy range D14:D16
selected
Drag the fi ll handle
in the lower-right
corner of the
selected range
through cell J16 and
continue to hold
down the mouse
button (Figure 2–26).
mouse pointer
fi ll handle dragged
to select destination
area, range E14:J16
Figure 2–26
 
 
Search JabSto ::




Custom Search