Page 78 - Excel 2007 Bible

07_044039 ch03.qxp 11/21/06 10:55 AM Page 35
Entering and Editing
Worksheet Data
his chapter describes what you need to know about entering, using, and
modifying data in your worksheets. As you see, Excel doesn’t treat all data IN THIS CHAPTER
Tequally. Therefore, you need to learn about the various types of data that Understanding the types of data
you can use in an Excel worksheet.
you can use
Entering text and values into
Exploring the Types of Data your worksheets
You Can Use Entering dates and times into
your worksheets
An Excel workbook can hold any number of worksheets, and each worksheet
is made up of more than 17 billion cells. A cell can hold any of three basic types Modifying and editing
of data: information
n Numerical values Using built-in number formats
n Text
n Formulas
A worksheet can also hold charts, diagrams, pictures, buttons, and other objects.
These objects aren’t contained in cells. Rather, they reside on the worksheet’s
draw layer, which is an invisible layer on top of each worksheet.
CROSS-REF Chapter 18 discusses some of the items you can place on the
CROSS-REF
draw layer
About numerical values
Numerical values represent a quantity of some type: sales amounts, number of
employees, atomic weights, test scores, and so on. Values also can be dates (such
as Feb-26-2007) or times (such as 3:24 a.m.).
CROSS-REF Excel can display values in many different formats. Later in this
CROSS-REF
chapter, you see how different format options can affect the
display of numerical values (see “Applying Number Formatting”).

35