Microsoft Office Tutorials and References
In Depth Information
Saving the Project
• With the mouse pointer in cell G4
and in the shape of a block plus
sign, drag the mouse pointer down
to cell G9 to highlight the range
G4:G9 with a transparent view
• Click the Sum
button on the Ribbon
to calculate and
display the sums of
rows of sales in cells
G4, G5, G6, G7, G8,
and G9 (Figure 1–40).
• Select cell A10 to
deselect the range
Why does Excel create
totals for each row?
If each cell in a selected
range is next to a row
of numbers, Excel
assigns the SUM
function to each cell when you click the Sum button.
totals for each
row of numbers
Excel allows you to save
a workbook in more than
30 different ﬁ le formats.
Choose the ﬁ le format by
clicking the ‘Save as type’
box arrow at the bottom
of the Save As dialog box
(Figure 1–41 on the next
page). Excel Workbook is
the default ﬁ le format.
While you are building a worksheet in a workbook, the computer stores it in memory.
When you save a workbook, the computer places it on a storage medium such as a USB
ﬂ ash drive, CD, or hard disk. A saved workbook is referred to as a ﬁ le . A ﬁ le name is
the name assigned to a ﬁ le when it is saved. It is important to save the workbook fre-
quently for the following reasons:
• The worksheet in memory will be lost if the computer is turned off or you lose
electrical power while Excel is open.
• If you run out of time before completing your workbook, you may ﬁ nish your
worksheet at a future time without starting over.