Microsoft Office Tutorials and References
In Depth Information
AutoCalculate
To Open a Workbook from Excel
Earlier in this chapter you saved your project on a USB l ash drive using the i le name,
Save Sable River Foundation. The following steps open the Save Sable River Foundation i le
from the Excel folder in the CIS 101 folder on the USB l ash drive. For a detailed example of
the procedure summarized below, refer to page OFF 57 in the Ofi ce 2010 and Windows 7
chapter at the beginning of this topic.
1
With your USB l ash drive connected to one of the computer’s USB ports, click File on the
Ribbon to open the Backstage view.
2
3
Click Open in the Backstage view to display the Open dialog box.
Navigate to the location of the i le to be opened (in this case, the USB l ash drive, then to
the CIS 101 folder [or your class folder], and then to the Excel folder).
4
Click Save Sable River Foundation to select the i le to be opened.
5
Click the Open button (Open dialog box) to open the selected i le and display the opened
workbook in the Excel window.
AutoCalculate
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 Coni guration shortcut menu (Figure 1– 72). 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 Coni guration shortcut
menu are described in Table 1– 4.
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.
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
 
Search JabSto ::




Custom Search