Chapter 2Entering 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
This chapter describes what you need to know about entering 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 Data Types
An Excel workbook file 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 of data:
- A numeric value
- Text
- A formula
A worksheet can also hold charts, diagrams, pictures, buttons, and other objects. These objects aren't contained in cells. Instead, they reside on the worksheet's draw layer, which is an invisible layer on top of each worksheet.
Numeric values
Numeric values represent a quantity of some type: sales amounts, number of employees, atomic weights, test scores, and so on. Values also can be dates (Feb 26, 2015) or times (such as 3:24 a.m.).
Get Excel 2016 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
