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

Entering Data

Excel worksheet cells can contain values or formulas. The constant values that cells can contain are numbers, text, dates, times, logical values, and errors. A logical value, such as TRUE or FALSE, is the result displayed after a condition is tested. Error values, such as #NUM!, occur when Excel cannot properly evaluate a formula in a cell.

When you type a value or formula in the active cell, your entry appears at the insertion point, or cursor, in the formula bar near the top of the screen. The entry appears in the long text box on the right side of the formula bar. You can also type and edit directly in a cell if you turn on in-cell editing. Even if what you type exceeds the width of the cell, the full contents of the cell are displayed so that you can see what you are doing. Figure 4.1 shows editing in the formula bar and in cell D5.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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