Microsoft Office Tutorials and References
In Depth Information
Additional Microsoft Office Programs
Unique Features of Excel
The Excel window consists of a variety of components to make your work more
efi cient and worksheets more professional. These include the document window, Ribbon,
Mini toolbar and shortcut menus, Quick Access Toolbar, and the Backstage view. Some
of these components are common to other Microsoft Ofi ce 2010 programs; others are
unique to Excel.
Excel opens a new workbook with three worksheets. 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 Brain
Busters workbook. If you click the sheet tab labeled Sheet2, Excel displays the Sheet2
The 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 , identii es each column. A row number on the left side of the grid, also called
the row heading , identii es each row. With the screen resolution set to 1024
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 68.
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 i 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 68).
One cell on the worksheet, designated the active cell , is the one into which you
can enter data. The active cell in Figure 68 is A1. The active cell is identii 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 68).
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 that they do not show on the worksheet, but it is recommended
that you leave them on for now.
The mouse pointer in Figure 68 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 when 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 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.
In addition to customizing
the Quick Access Toolbar,
you can add items to and
remove items from the
Ribbon. To customize the
Ribbon, click File on the
Ribbon to open the
Backstage view, click
Options in the Backstage
view, and then click
Customize Ribbon in the
left pane of the Options
dialog box. More
customizing the Ribbon is
presented in a later chapter.
Ribbon When you start Excel, the Ribbon displays eight main tabs: File, Home, Insert,
Page Layout, Formulas, Data, Review, and View. The Formulas and Data tabs are specii c
to Excel. The Formulas tab allows you to work with Excel formulas, and the Data tab
allows you to work with data processing features such as importing and sorting data.