Microsoft Office Tutorials and References
In Depth Information
Running and Using an App
Excel opens a new workbook with one worksheet. If necessary, you can add additional
worksheets as long as your computer has enough memory to accommodate them.
Each worksheet has a sheet name that appears on a sheet tab at the bottom of
the workbook. For example, Sheet1 is the name of the active worksheet displayed in
the Inverstonit Electronics workbook (Figure 13 on the next page). You can add more
sheets to the workbook by clicking the New sheet button.
The Worksheet Size
The 16,384 columns
and 1,048,576 rows in
Excel make for a huge
worksheet that — if you
could imagine — takes up
the entire side of a building
to display in its entirety.
Your computer screen,
by comparison, is a small
window that allows you to
view only a minute area of
the worksheet at one time.
While you cannot see the
entire worksheet, you can
move the window over
the worksheet to view any
part of it.
Worksheet The worksheet is organized into a rectangular grid containing vertical
columns and horizontal rows. A column letter above the grid, also called the column
heading , identies each column. A row number on the left side of the grid, also called
the row heading , identies each row. With the screen resolution set to 1366 3 768
and the Excel window maximized, Excel displays 20 columns (A through T) and 23
rows (1 through 23) of the worksheet on the screen, as shown in Figure 13 on the next
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 E2 refers to
the cell located at the intersection of column E and row 2 (Figure 13).
One cell on the worksheet, designated the active cell , is the one into which you
can enter data. The active cell in Figure 13 is A1. The active cell is identied 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 that it is easy to see which cell is active (Figure 13).
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 off the gridlines so that they do not show on the worksheet. While learning
Excel, gridlines help you to understand the structure of the worksheet.
The pointer in Figure 13 has the shape of a block plus sign. The pointer appears
as a block plus sign whenever it is located in a cell on the worksheet. Another common
shape of the pointer is the block arrow. The pointer turns into the block arrow when
you move it outside the worksheet or when you drag cell contents between rows or
columns. The other pointer shapes are described when they appear on the screen.
Scroll Bars You use a scroll bar to display different portions of a worksheet in
app worksheet windows. At the right edge of the window is a vertical scroll bar. If
a worksheet is too wide to t in the window, a horizontal scroll bar also appears at
the bottom of the window. On a scroll bar, the position of the scroll box reects the
location of the portion of the worksheet that is displayed in the window.
Status Bar The status bar , located at the bottom of the worksheet window above
the Windows taskbar, presents the progress of current tasks and controls for viewing
the worksheet. As you type text or perform certain tasks, various indicators and buttons
may appear on the status bar.
The right side of the status bar in Figure 13 includes buttons and controls you can
use to change the view of a document and adjust the size of the displayed document.