558
Using Lists & Spreadsheet
Entering a formula in a column’s formula cell tells the Lists & Spreadsheet
application that you want to apply the formula to all cells in the column,
not just to a single cell.
À
Column formula based on a variable
Á
Column formula based on another column
Â
Column formula that generates a sequence
Notes:
•
If you generate data in a column that already contains one or more
cell values, Lists & Spreadsheet asks for confirmation before replacing
the existing values. Proceeding removes all of the existing values in
the column.
•
If you edit a cell manually in a column of generated data,
Lists & Spreadsheet asks for confirmation before replacing the
generated data. Proceeding removes the generated data for the
entire column.
Creating column values based on another column
1. Click the column formula cell (the second cell from the top) of the
column where you want to use a formula.
Lists & Spreadsheet inserts the leading equal sign (
=
) for the formula.
If the column is a named list, Lists & Spreadsheet inserts
listname
:=
followed by the cursor.
2. Type the expression for the formula after the = and press
·
. Use
brackets (
[]
) after any column letter you include in the formula. For
example, type
=a[]^2
to create a column of values in which each cell
is the square of the corresponding cell of column A.
À
Á
Â
Summary of Contents for TI-Nspire
Page 38: ...26 Setting up the TI Nspire Navigator Teacher Software ...
Page 46: ...34 Getting started with the TI Nspire Navigator Teacher Software ...
Page 84: ...72 Using the Content Workspace ...
Page 180: ...168 Capturing Screens ...
Page 256: ...244 Embedding documents in web pages ...
Page 336: ...324 Polling students ...
Page 374: ...362 Using the Review Workspace ...
Page 436: ...424 Calculator ...
Page 450: ...438 Using Variables ...
Page 602: ...590 Using Lists Spreadsheet ...
Page 676: ...664 Using Notes You can also change the sample size and restart the sampling ...
Page 684: ...672 Libraries ...
Page 714: ...702 Programming ...
Page 828: ...816 Data Collection and Analysis ...
Page 846: ...834 Regulatory Information ...
Page 848: ...836 ...