beautypg.com

Inputting data into a cell, General input rules, Cell references – Casio PV-S6100 User Manual

Page 88

background image

86

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.

This manual is related to the following products: