Creating Spreadsheet Data

You can type numeric values, text, or formulas into body cells. Column formula cells can contain formulas only. (For more information, see Generating Columns of Data.)

Data Examples

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. 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 more information, 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.

Typing a Math Expression, Text, or Spreadsheet Formula

Double-click the cell to select it and put it in edit mode.

Note: If the cell is already selected, you can press Enter or click the entry line.

Type the expression, text, or formula. Be sure to enclose text entries in quotes and start formula entries with an “=” symbol.

As you type the data, it appears in the cell and on the entry line simultaneously.

Press Enter to complete the entry and move down to the next cell.

—or—

Press Tab 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 (_).

Inserting a Cell Range into a Formula

The Select Range feature lets you insert a cell range (such as a1:b3) into a formula by selecting the range instead of typing cell addresses into an argument.

Suppose you want to calculate the mean of a range of cells.

Select the cell that will contain the result.

From the Data menu, click List Math > Mean.

An editable formula appears in the cell.

Click Actions > Select > Select Formula Range.

Drag a selection rectangle around the range of values for which you want to calculate the mean.

Handheld: Move to the first cell in the range, hold g, and press the arrow keys.

The formula is updated as you select the cells.

Press Enter to complete the formula and display the result.