Using Lists & Spreadsheet 549
Data examples
Typing a math expression, text, or spreadsheet formula
1. Double-click the cell to select it and put it in edit mode.
Note: If the cell is already selected, you can press · or click the
entry line.
2. Type the expression, text, or formula. Be sure to enclose text entries in
quotes and start formula entries with an “=” symbol.
As you enter the data, it appears in the cell and on the entry line
simultaneously.
3. Press
· to complete the entry and move down to the next cell.
– or –
Press e to complete the entry and move right to the next cell.
The Lists & Spreadsheet application automatically recalculates any
cells that are dependent on the cell you entered. If you have shared
the cell, and other TI-Nspire™ applications are linked to the cell, the
other applications are also updated.
Note: Empty cells in a spreadsheet display as a void represented by an
underscore (_). The underscore is automatically added to empty cells
when a list is named or when an empty cell is referenced in a formula.
When you plan to perform calculations on a range of cells, be sure to
notice the location of void cells. Cells without a value can affect
calculations. For example, if you include a void cell in the range for a
sum such as “=b2+c2,” the result of the calculation is void (_).
Entry Remarks
1.234 Simple numeric entry
“Green” Text - Enclose categorical data (such as the names of
colors used in a study) within quotes to distinguish
them from variable names. On the Handheld, press
/r to enter quoted data.
=a3*length Formula - Consists of an “=” symbol followed by an
expression.
You can type the expression or use the Catalog and
expression templates to build it. For details, see the
Calculator section.
To ensure a decimal result instead of a fraction,
type one of the integers in the expression as a
decimal. For example, type 1.0 instead of 1.
To Next Page
Loading...
Need help?
General
