Microsoft Office Tutorials and References
In Depth Information
EX 194
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Error Messages
When Excel cannot
calculate a formula, it
displays an error message
in a cell. These error
messages always begin
with a number sign (#).
The more commonly
occurring error messages
are: #DIV/0! (tries to
divide by zero); #NAME?
(uses a name Excel does
not recognize); #N/A
(refers to a value not
available); #NULL!
(specifi es an invalid
intersection of two
areas); #NUM! (uses a
number incorrectly); #REF
(refers to a cell that is
not valid); #VALUE! (uses
an incorrect argument
or operand); and #####
(cell not wide enough to
display entire entry).
To Determine Row Totals in Nonadjacent Cells
The following steps determine the row totals in column H. To determine the row
totals using the Sum button, select only the cells in column H containing numbers in
adjacent cells to the left. If, for example, you select the range H5:H16, Excel will display
0s as the sum of empty rows in cells H7, H8, and H15.
1 Select the range H5:H6. Hold down the CTRL key and select the range H9:H14 and cell H16
as shown in Figure 3–33.
2 Click the Sum button on the Ribbon to display the row totals in column H (Figure 3–33).
Sum button
projected semiannual cost
of goods, gross margin,
expenses by category, and
operating income
Figure 3–33
Toggle Commands
Many of the commands
on the Ribbon, in
the galleries, and the
shortcut keys function as
a toggle. For example,
if you click the Freeze
Panes command on the
Freeze Panes gallery, the
command changes to
Unfreeze Panes the next
time you view the gallery.
These types of commands
work like an on-off
switch, or toggle.
To Unfreeze the Worksheet Titles and Save the Workbook
All the text, data, and formulas have been entered into the worksheet. The following
steps unfreeze the titles and save the workbook using its current fi le name, Campus Clothiers
Semiannual Financial Projection.
1 Press CTRL + HOME to select cell B4 and view the upper-left corner of the screen.
2 Click the View tab on the Ribbon and then click the Freeze Panes button on the Ribbon to
display the Freeze Panes gallery (Figure 3–34).
3 Click Unfreeze Panes in the Freeze Panes gallery to unfreeze the titles.
Search JabSto ::

Custom Search