Excel 2010 Bible

29

CHAPTER

Entering and Editing

Worksheet Data

IN THIS CHAPTER

Understanding the types of

data you can use

Entering text and values into

your worksheets

Entering dates and times into

your worksheets

Modifying and editing

information

Using built-in number formats

T

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 equally. Therefore, you need to learn about the various

types of data that you can use in an Excel worksheet.

Exploring the Types of Data You Can Use ...........................................................................

An Excel workbook can hold any number of worksheets, and each work-

sheet is made up of more than 17 billion cells. A cell can hold any of three

basic types of data:

l A numeric value

l (^) Text
l A formula
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-Reference
Chapter 22 discusses some of the items you can place on the draw layer. n