Microsoft Office Tutorials and References
In Depth Information
EX 8
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
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.
Sheet 1
worksheet
Name box
with active
cell reference
mouse
pointer
column
heading N
worksheet
window
heavy border
surrounds
active cell
gridlines
highlighted row
and column
headings indicate
cell A1 is active
row
heading 11
cell D11
number of
worksheets available
in workbook limited
only by amount of
memory on computer
scroll boxes
view buttons;
default is
normal layout
tab
scrolling
buttons
scroll bars
adjusts size
of displayed
document
sheet tabs
tab split box
mode
indicator
Microsoft Excel
taskbar button
status bar
scroll arrows
Figure 1–6
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 fi 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 identifi 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.
Worksheet
Development
The key to developing
a useful worksheet is
careful planning. Careful
planning can reduce your
effort signifi cantly and
result in a worksheet
that is accurate, easy
to read, fl exible, and
useful. When analyzing a
problem and designing a
worksheet solution, you
should follow these steps:
(1) defi ne the problem,
including need, source
of data, calculations,
charting, and Web or
special requirements;
(2) design the worksheet;
(3) enter the data and
formulas; and (4) test the
worksheet.
Search JabSto ::




Custom Search