Microsoft Office Tutorials and References
In Depth Information
Using the AVERAGE, MAX, and MIN Functions
Select cell H16 and then press the DELETE key to delete the average of the tax %
(Figure 2 – 25).
Why delete the formula in cell H16?
The average of the tax percentage in cell H16 is deleted because an average of
percentages of this type is mathematically invalid.
How can I be sure that the function arguments are proper for the cells in range C14:I16?
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 – 25. 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
mathematically invalid
average of percentages
in range H4:H12 deleted
Figure 2 – 25
Other Ways
1. Select source area, tap
or click Copy button
(HOME tab | Clipboard
group), select
destination area, tap
or click Paste button
(HOME tab | Clipboard
2. Press and hold or
right-click source area,
tap or click Copy on
shortcut menu; press
and hold or right-click
destination area, tap
or 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
4. Select source area,
press CTRL + C , select
destination area,
press CTRL + V
To Save a Workbook Using the Same File Name
Earlier in this project, an intermediate version of the workbook was saved using
the le name, HyperMass Online Storage Salary Report. The following step saves the
workbook a second time, using the same le name.
Tap or click the Save button on the Quick Access Toolbar to overwrite the previously
saved le.
Search JabSto ::

Custom Search