Microsoft Office Tutorials and References
In Depth Information
The Excel Workbook
each row. With the screen resolution set to 1024
768 and the Excel window maximized,
Excel displays 15 columns (A through O) and 25 rows (1 through 25) of the worksheet on
the screen, as shown in Figure 1–6.
cell A1 is active
in workbook limited
only by amount of
memory on computer
tab split box
The intersection of each column and row is a cell. A cell is the basic unit of a
worksheet into which you enter data. Each worksheet in a workbook has 16,384 columns
and 1,048,576 rows for a total of 17,179,869,180 cells. Only a small fraction of the active
worksheet appears on the screen at one time.
A cell is referred to by its unique address, or cell reference , which is the coordinates
of the intersection of a column and a row. To identify a cell, specify the column letter ﬁ rst,
followed by the row number. For example, cell reference D11 refers to the cell located at
the intersection of column D and row 11 (Figure 1–6).
One cell on the worksheet, designated the active cell , is the one into which you can
enter data. The active cell in Figure 1–6 is A1. The active cell is identiﬁ ed in three ways.
First, a heavy border surrounds the cell; second, the active cell reference shows immediately
above column A in the Name box; and third, the column heading A and row heading 1 are
highlighted so it is easy to see which cell is active (Figure 1–6).
The horizontal and vertical lines on the worksheet itself are called gridlines .
Gridlines make it easier to see and identify each cell in the worksheet. If desired, you can
turn the gridlines off so they do not show on the worksheet, but it is recommended that
you leave them on for now.
The mouse pointer in Figure 1–6 has the shape of a block plus sign. The mouse pointer
appears as a block plus sign whenever it is located in a cell on the worksheet. Another common
shape of the mouse pointer is the block arrow. The mouse pointer turns into the block arrow
whenever you move it outside the worksheet or when you drag cell contents between rows or
columns. The other mouse pointer shapes are described when they appear on the screen.
The key to developing
a useful worksheet is
careful planning. Careful
planning can reduce your
effort signiﬁ cantly and
result in a worksheet
that is accurate, easy
to read, ﬂ exible, and
useful. When analyzing a
problem and designing a
worksheet solution, you
should follow these steps:
(1) deﬁ ne the problem,
including need, source
of data, calculations,
charting, and Web or
(2) design the worksheet;
(3) enter the data and
formulas; and (4) test the