Microsoft Office Tutorials and References
In Depth Information
Entering Functions with the AutoSum Feature
To enter the SUM function to add the values in the range F6:F9:
1. Click cell E10 , type TOTAL in all uppercase letters as the label, and then press the
Tab key. The label is entered in cell E10, and cell F10 is the active cell.
You can also insert a range
reference into a function
by selecting the range
with the pointer.
2. Type =SUM(F6:F9 in cell F10. As you begin to type the function, a ScreenTip lists
the names of all functions that start with the letter “S.” When you type the cell
references, Excel highlights all the cells in the specified range to provide a visual
reminder of exactly which cells the SUM function is using. See Figure 1-23.
Figure 1-23
SUM function being entered
a colored border indicates the
range used in the function
ScreenTip shows t he function
being entered into the cell
3. Type to complete the function, and then press the Tab key. The value of the SUM )
function appears in cell F10, indicating that Amanda has to create 79 DVDs to
complete all of her current orders.
Entering Functions with the AutoSum Feature
A fast and convenient way to enter commonly used functions is with the AutoSum
feature. The AutoSum feature includes buttons to quickly insert the SUM, AVERAGE,
COUNT, MIN, and MAX functions to generate the following:
• Sum of the values in the column or row
• Average value in the column or row
• Total count of numeric values in the column or row
• Minimum value in the column or row
• Maximum value in the column or row
The Sum button automatically inserts both the function name and the range reference
to the row or column of data to which the summary function is being applied.
Search JabSto ::




Custom Search