Microsoft Office Tutorials and References
In Depth Information
EX 62
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
AutoCalculate
AutoCalculate
Use the AutoCalculate
area on the status bar
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
you entered. Often, you
will have an intuitive feel
for whether the numbers
are accurate or if you
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 Conﬁ 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 Conﬁ 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 Conﬁ guration
What is displayed on the
Status Bar Conﬁ guration
several commands that
allow you to control the items
displayed on the Customize
AutoCalculate area of the
commands as well as the result
of the associated calculation
on the right side of the menu.
Customize
Status Bar
selected
range is
B6:F6
calculated values
appear on