Microsoft Office Tutorials and References
In Depth Information
Selecting a Cell
Selecting a Cell
For an introduction to
office and instruction
about how to perform
basic tasks in office
apps, read the office and
Windows chapter at the
beginning of this topic,
where you can learn how
to run an application, use
the ribbon, save a le, open
a le, exit an application,
use Help, and much more.
To enter data into a cell, you rst must select it. The easiest way to select a cell (make
it active) is to tap it or use the mouse to move the block plus sign 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 shaded color.
BTW
Touch Screen
Differences
The office and Windows
interfaces may vary if you are
using a touch screen. For this
reason, you might notice that
the function or appearance of
your touch screen differs slightly
from this chapter’s presentation.
BTW
Q&As
For a complete list of the Q&As
found in many of the step-by-
step sequences in this topic,
visit the Q&A resource on
the Student Companion Site
located on www.cengagebrain
.com. For detailed instructions
about accessing available
resources, visit www.cengage
.com/ct/studentdownload or
contact your instructor for
information about accessing
the required les.
Entering Text
In Excel, any set of characters containing a letter, hyphen (as in a telephone number),
or space is considered text. Text is used to place titles, such as worksheet titles, column
titles, and row titles, on 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 2014 Payroll and Year 2015 Projected Budget, and
examples of subtitles are Marketing Department and Rent and Utilities, respectively.
As shown in Figure 1– 4, data in a worksheet often is identied 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 Income and
Total, and examples of column titles are Wages and Gas.
worksheet
title
column button shaded
to indicate it contains
active cell
worksheet
subtitle
column
titles
row
titles
active cell, F21,
appears in the
Name box and
has heavy border
row button shaded
to indicate it contains
active cell
Figure 1– 4
 
Search JabSto ::




Custom Search