Microsoft Office Tutorials and References
In Depth Information
Selecting a Cell
Selecting a Cell
Selecting a Cell
You can select any cell by
entering its cell reference,
such as B4, in the Name
box on the left side of the
formula bar.
To enter data into a cell, you i rst must select it. The easiest way to select a cell (make
it active) is to use the mouse to move the block plus sign mouse pointer to the cell and
then click.
An alternative method is to use the arrow keys that are located just to the right of
the alphanumeric keys on a standard keyboard. An arrow key selects the cell adjacent to
the active cell in the direction of the arrow on the key.
You know a cell is selected, or active, when a heavy border surrounds the cell and
the active cell reference appears in the Name box on the left side of the formula bar.
Excel also changes the active cell’s column heading and row heading to a gold color.
For an introduction
to Ofi ce 2010 and
instruction about
how to perform
basic tasks in Ofi ce
2010 programs, read
the Ofi ce 2010 and
Windows 7 chapter
at the beginning of
this topic, where you
can learn how to start
a program, use the
Ribbon, save a i le,
open a i le, quit a
program, use Help,
and much more.
Entering Text
In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or
space is considered text. Tex t is used to place titles, such as worksheet titles, column titles,
and row titles, on the worksheet.
Plan
Ahead
Select titles and subtitles for the worksheet.
Worksheet titles and subtitles should be as brief and meaningful as possible. A worksheet
title could include the name of the organization, department, or a description of the
content of the worksheet. A worksheet subtitle, if included, could include a more detailed
description of the content of the worksheet. Examples of worksheet titles are December
2010 Payroll and Year 2011 Projected Budget, and examples of subtitles are Marketing
Department and Rent and Utilities, respectively.
Plan
Ahead
Determine the contents of rows and columns.
As shown in Figure 1– 4, data in a worksheet often is identii ed by row and column titles
so that the user of a worksheet easily can identify the meaning of the data. Rows typically
contain information that is similar to items in a list. Columns typically contain descriptive
information about items in rows or contain information that helps to group the data in the
worksheet. Examples of row titles are Product and Total, and examples of column titles are
Name and Address.
worksheet title
worksheet subtitle
column titles
row titles
Figure 1– 4
 
Search JabSto ::




Custom Search