Microsoft Office Tutorials and References
In Depth Information
AutoCalculate
AutoCalculate
AutoCalculate
Use the AutoCalculate
area on the status bar
to check your work
as you enter data in a
worksheet. If you enter
large amounts of data,
you select a range of
data and then check
the AutoCalculate area
to provide insight into
statistics about the data
you entered. Often, you
will have an intuitive feel
for whether the numbers
are accurate or if you
may have made a mistake
while entering the data.
You easily can obtain a total, an average, or other information about the numbers in a
range by using the AutoCalculate area on the status bar. First, select the range of cells
containing the numbers you want to check. Next, right-click the AutoCalculate area to
display the Status Bar Confi guration shortcut menu (Figure 1–92). The check mark to the
left of the active functions (Average, Count, and Sum) indicates that the sum, count, and
average of the selected range are displayed in the AutoCalculate area on the status bar.
The functions of the AutoCalculate commands on the Status Bar Confi guration shortcut
menu are described in Table 1–4.
Table 1–4 AutoCalculate Shortcut Menu Commands
Command
Function
Average
AutoCalculate area displays the average of the numbers in the selected range
Count
AutoCalculate area displays the number of nonblank cells in the selected range
Numerical Count
AutoCalculate area displays the number of cells containing numbers in the selected range
Minimum
AutoCalculate area displays the lowest value in the selected range
Maximum
AutoCalculate area displays the highest value in the selected range
Sum
AutoCalculate area displays the sum of the numbers in the selected range
To Use the AutoCalculate Area to Determine a Maximum
The following steps show how to display the largest quarterly sales for any region for the Micro product type.
1
Select the range B6:F6
and then right-click the
AutoCalculate area on the
status bar to display the
Status Bar Confi guration
shortcut menu (Figure 1–92).
What is displayed on the
Status Bar Confi guration
shortcut menu?
This shortcut menu includes
several commands that
allow you to control the items
displayed on the Customize
Status Bar shortcut menu. The
AutoCalculate area of the
shortcut menu includes six
commands as well as the result
of the associated calculation
on the right side of the menu.
Customize
Status Bar
shortcut menu
selected
range is
B6:F6
calculated values
appear on
shortcut menu
Maximum
command
AutoCalculate area
AutoCalculate area
on status bar
Figure 1–92
 
 
Search JabSto ::




Custom Search