Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
2
AVERAGE, MAX, and MIN
functions in range C14:C16
copied to range D14:J16
button to copy the
three functions to
the selected range
(Figure 2 – 27).
Release the mouse
Auto Fill Options button
Figure 2 – 27
How can I be sure that the function arguments are proper for the cells in range D14:J16?
Remember that Excel adjusts the cell references in the copied functions so that each
function refers to the range of numbers above it in the same column. Review the numbers in
rows 14 through 16 in Figure 2 – 27. You should see that the functions in each column return
the appropriate values, based on the numbers in rows 4 through 12 of that column.
Save button
3
then press the DELETE
key to delete the
average of the tax %
(Figure 2 – 28).
Why is the formula
in cell J14 deleted?
The average of the
tax % in cell J14 is
deleted because
an average of
percentages of this
type is mathematically
invalid.
Select cell J14 and
average of
percents in
range J4:J12
mathematically
invalid
Figure 2 – 28
Other Ways
1. Select source area, click
Copy button (Home
tab | Clipboard group),
select destination area,
click Paste button
(Home tab | Clipboard
group)
2. Right-click source area,
click Copy on shortcut
menu, right-click destina-
tion area, click Paste icon
on shortcut menu
3. Select source area and
then point to border of
range; while holding down
CTRL , drag source area to
destination area
4. Select source area, press
CTRL + C , select destination
area, press CTRL + V
 
Search JabSto ::




Custom Search