Microsoft Office Tutorials and References
In Depth Information
Making Sure That the Data Is Safe and Sound
Figure 2-20:
Using the
Totals
feature on
the Quick
Analysis
tool to add
a column
of quarterly
totals to a
selected
worksheet
table.
To add the running totals to the sample worksheet table shown in Figure 2-20
after adding a column of quarterly totals with the Sum button, you simply
select the table of data, A2 through D12 (to include the new Sum column),
and click the Quick Analysis tool followed by the Totals and Running Total
buttons. Then, edit the heading, Sum, in cell E2 to make it read Qtr 1 and
you’re all done!
If you have trouble selecting the Quick Analysis tool to open its palette for any
reason, simply right-click the cell selection and click the Quick Analysis item
on its context menu.
Making Sure That the Data
Is Safe and Sound
All the work you do in any of the worksheets in your workbook is at risk
until you save the workbook as a disk file, normally on your computer’s hard
drive. Should you lose power or should your computer crash for any reason
Search JabSto ::




Custom Search