• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Entering and Editing Data > Entering Text and Values

Entering Text and Values

A worksheet can contain three basic types of entries: text, values, and formulas. (There are also functions, which are simply built-in formulas-you'll learn more about those in Chapter 6, "Using Excel Functions.") You can type up to 255 characters in a cell, text or numbers. Depending on the purpose of the data, the characters you type will fall into one of these categories:

  • Text. Excel refers to text data as text (sometime known as labels); Excel cannot perform calculations on entries that are strictly text. For example, if you type the word February into a cell, you won't be able to perform a mathematical function or calculation with it-it's just a word.

  • Values. Excel refers to numerical data as a value; Excel can calculate value entries. Values include numbers, dates, and times. For example, if you type the number 1,024, you can do something with it, such as multiply or add.

  • Formulas. The third type of data is a formula, which is simply an entry that tells Excel to perform calculations on the values in a cell or group of cells. You'll learn more about entering formulas later in the chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint