Entering Data in a Worksheet

Entering data in a worksheet is just a matter of clicking a particular cell and then typing the information. When you work in Excel, you enter different types of information, such as text, numbers, dates, times, formulas, and functions. In terms of the raw data that you enter (precluding the insertion of formulas or functions), you are really working with two different types of information: labels and values.

A label is typically descriptive information, such as the name of a person, place, or thing, or a time designation such as the day of the week or month of the year. A label has no numerical significance in Excel; labels provide context for the values in the worksheet. Now, don’t get me wrong—dates can have numerical ...

Get Office 2013 In Depth 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.