Chapter 8 Pocket Sheet

Inputting Data Into a Cell

This section explains the rules and procedures for inputting text, values, and mathematical expressions into sheet cells. It also contains detailed information on the various cell functions that are available.

General Input Rules

The following are the general rules that you should observe whenever inputting data.

•Anything you enter on the keyboard is input into the sheet’s active cell.

•You can input up to 256 characters into each cell.

•Mixing text and numbers inside the same cell causes everything in the cell to be treated as text.

•Do not manually input commas as separators inside values. Doing so interferes with correct display of calculation results. Use the procedure under “Changing the Format Settings of a Cell” on page 93 to turn on automatic comma separators.

Cell References

The term cell reference means calling the contents of one cell into another cell. Pocket Sheet supports three types of cell references: relative, absolute, and mixed. Whether a cell references is relative, absolute, or mixed does not make affect the results it normally produces. The cell reference type matters only when the contents of the cell are copied and then pasted into another location. See “Copying a Relative Cell Reference” on page 105 and “Copying an Absolute or Mixed Cell Reference” on page 105 for full information about how cell references are affected by cut, copy, and paste operations.

86