Microsoft Office Tutorials and References
In Depth Information
Saving the Project
EX 29
2
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
(Figure 1–39).
range
G4:G9
selected
Figure 1–39
3
Click the Sum
button on the Ribbon
to calculate and
display the sums of
the corresponding
rows of sales in cells
G4, G5, G6, G7, G8,
and G9 (Figure 1–40).
Sum button
4
Select cell A10 to
deselect the range
G4:G9.
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
Figure 1–40
Saving the Project
Saving
Excel allows you to save
a workbook in more than
30 different fi le formats.
Choose the fi 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 fi 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
fl ash drive, CD, or hard disk. A saved workbook is referred to as a fi le . A fi le name is
the name assigned to a fi le when it is saved. It is important to save the workbook
frequently 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 fi nish your
worksheet at a future time without starting over.
 
Search JabSto ::




Custom Search