Microsoft Office Tutorials and References
In Depth Information
To Open a Document from Excel
Earlier in this chapter you saved your workbook using the le name, Bob
Gleamin Budget. The following steps open the Bob Gleamin Budget le from
the Excel folder in the CIS 101 folder. For a detailed example of the procedure
summarized below, refer to the office and Windows chapter at the beginning of
Tap or click FILE on the ribbon to open the Backstage view and then tap or click the
Open tab in the Backstage view to display the Open gallery.
If the le you wish to open is displayed in the Recent Workbooks list, tap or click the
le name to open the le and display the opened workbook in the Excel window;
then skip the remaining steps. If the le you wish to open is not displayed in the
Recent Workbooks list, proceed to the next step to locate the le.
To print document properties,
tap or click FILE on the ribbon
to open the Backstage view,
tap or click the Print tab
in the Backstage view to
display the Print gallery, tap
or click the rst button in the
Settings area to display a list
of options specifying what
you can print, tap or click
Document Info in the list to
specify you want to print the
document properties instead
of the actual document, and
then tap or click the Print
button in the Print gallery
to print the document
properties on the currently
Tap or click Computer, SkyDrive, or another location in the left pane and then
navigate to the location of the le to be opened (in this case, the Excel folder in the
CIS 101 folder).
Tap or click Bob Gleamin Budget to select the le to be opened.
Tap or click the Open button (Open dialog box) to open the selected le and display
the opened workbook in the Excel window.
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, press and hold or right-click the
AutoCalculate area to display the Customize Status Bar shortcut menu (Figure 1– 69).
The check marks indicate that the calculations are included in the status bar; more
than one may be selected. The functions of the AutoCalculate commands on the
Customize Status Bar shortcut menu are described in Table 1– 4.
Table 1– 4 Commonly Used Status Bar Commands
AutoCalculate area displays the average of the numbers in the
AutoCalculate area displays the number of nonblank cells in the
AutoCalculate area displays the number of cells containing numbers
in the selected range
AutoCalculate area displays the lowest value in the selected range
AutoCalculate area displays the highest value in the selected range
AutoCalculate area displays the sum of the numbers in the
To Use the AutoCalculate Area
to Determine a Maximum
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
The following steps display the largest total for the months in the budget. Why? Sometimes, you want to see
a quick analysis, which can be shown in the AutoCalculate area on the status bar.