Texas Instruments Voyage 200 Manual

2/7/02 ©2001, 2002 Texas Instruments
TI-89/TI-92 Plus/Voyage™ 200
CellSheet™
How To…
Navigate in Spreadsheets Format Spreadsheets
Cut, Copy, and Paste Select, Insert, or Delete
Manipulate Data
Enter Data Edit Data
Sort Data Plot Data
Use Statistics Import and Export Data
Examples
Sort by Key Column Linear Regression
Interest and Principal Paid Maximum Area
More Information
Customer Support Error Messages
Menu Map Key Shortcuts
TI

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 2
Important Information
Texas Instruments makes no warranty, either expressed or
implied, including but not limited to any implied warranties of
merchantability and fitness for a particular purpose, regarding
any programs or book materials and makes such materials
available solely on an “as-is” basis.
In no event shall Texas Instruments be liable to anyone for
special, collateral, incidental, or consequential damages in
connection with or arising out of the purchase or use of these
materials, and the sole and exclusive liability of Texas
Instruments, regardless of the form of action, shall not exceed
the purchase price of this product. Moreover, Texas Instruments
shall not be liable for any claim of any kind whatsoever against
the use of these materials by any other party.
Graphing product applications (Apps) are licensed. See the
terms of the license agreement for this product.
The instructions in this guidebook refer to this Flash application
only. For help using the TI-89 / TI-92 Plus / Voyage™ 200 PLT,
refer to the comprehensive guidebook at
education.ti.com/guides.
Microsoft, Windows, Windows NT, Apple, Macintosh, Mac, and Mac OS are trademarks
of their respective owners.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 3
What Is the CellSheet™ Application?
The CellSheet application (App) is a spreadsheet in the palm of
your hand. It combines spreadsheet functionality with the power
of a calculator and supplements other calculator software
applications. The application is useful in classes such as math,
social studies, business, and science.
Cells can contain:
•Real or complex numbers
•Formulas
•Expressions
•Variables
•Text strings
•Functions that evaluate to expressions
Each spreadsheet contains 999 rows and 64 columns. A
spreadsheet variable can be no larger than 64 kilobytes (KB).

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 4
You can use a unit-to-unit cable to share spreadsheets with
other TI-89 and TI-92 Plus / Voyage™ 200 PLT units. A
CellSheet™ computer-based utility is available separately. The
utility lets you share TI-89 and TI-92 Plus / Voyage 200 PLT
spreadsheets with Excel and other programs. You can also use
the utility to convert and share spreadsheets with TI-83 Plus and
TI-83 Plus Silver Edition units. Please see education.ti.com for
more information about the CellSheet computer-based utility.
Languages
This application is available in English, Danish, Dutch, Finnish,
French, German, Italian, Norwegian, Portuguese, Spanish,
Swedish. The corresponding language localization software
must also be installed and running.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 5
Overview
The 64 columns are labeled A through BL. Rows are numbered
1through 999. Although you may insert and delete columns and
rows, columns will always be labeled A-BL and rows will always
be numbered 1-999. You cannot change the alphabetical column
labels or row numbers.
Individual cells are referred to by their column letter and row
number. For example, B25 refers to the 25th cell in column B.
Cell ranges are separated by a colon. For example, A1:C5 refers
to the rectangular range that has the 1st cell in column A as its
top left corner and the 5th cell in column C as its bottom right
corner.
Spreadsheet
name
Row number Column letter
Edit line

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 6
Navigating and Selecting Cells
Press ƒB:Help for a help screen that shows key shortcuts for
navigating and selecting.
Navigating
•A,B,C,or Dmoves the cursor from the current cell to an
adjacent cell.
•¥ C or ¥ D moves the cursor to the first or last cell in a
column.
•¥Aor ¥Bmoves the cursor to the first or last cell in a
row.
•2 C or 2 D moves the cursor several rows up or down.
•2 B or 2 A moves the cursor several columns to the
right or left.
•…1:GoTo moves the cursor to the cell you indicate.
Tip For the TI-89 only, press jin the CellSheet™ App dialog
boxes before typing letters.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 7
Selecting multiple cells, rows, or columns
•…2:Select Range lets you select a range of cells by entering
the range in the dialog box. You can also press and hold ¤
while pressing A,B,C,or Din the spreadsheet.
•¥AAor ¥CCselects the entire row or column from the
current cursor location. You can hold ¤and press A,B,C,
or Dto select multiple rows or columns.
Inserting a cell, row, or column
Select a cell, row, or column. 2 / inserts a cell, row, or
column above (for cells or rows) or to the left (for columns) of the
current selection.
Deleting a cell, row, or column
•¥ 8 or 0deletes a selected cell, row, or column and
shifts the remaining cells, rows, or columns up or left one
space.
•Mclears the contents of the selected cell or range of
cells without deleting the cell, row, or column.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 8
File Management
Pressing ƒallows you to:
•Open an existing spreadsheet
•Save a copy of the current spreadsheet under a different
name
•Create a new spreadsheet
•Cut, copy, and paste cells in a spreadsheet
•Clear the spreadsheet
•Format the appearance of data and set cursor movement
direction
•Display a help screen with navigation and editing tips
Opening an existing spreadsheet
1. Press ƒ1:Open.
2. Select the folder.
3. Select the name of the spreadsheet you want to open
and press ¸.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 9
Tips You can open only one spreadsheet at a time. If a spreadsheet is
archived, you must unarchive it before you can edit it.
Saving a spreadsheet
The spreadsheet is automatically saved in Random Access
Memory (RAM) as you work. You do not have to save your work
manually. However, you can save the current spreadsheet with a
new file name.
1. Press ƒ2:Save Sheet As.
2. Select the folder.
3. Type the variable name for the spreadsheet, and press
¸ ¸.You are still working in the current
spreadsheet, not the one you just saved.
Tips The spreadsheet name can contain:
•Letters, numbers, and symbols, but must begin with a letter
•Up to 8 characters, but no spaces.
To access the saved spreadsheet, press ƒ1:Open and select
the name of the spreadsheet you just saved.
Creating a new spreadsheet
1. Press ƒ3:New.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 10
2. Select the folder.
3. Type the variable name for the spreadsheet, and press
¸ ¸.
—or –
Accept the suggested variable name and press ¸.
Using cut, copy, and paste
•ƒ4:Cut removes contents from the currently selected cell or
range and places these contents on the clipboard to be
pasted into other cells.
TI-89 shortcut: ¥ 5.TI-92 Plus / Voyage™ 200 PLT
shortcut: ¥X.
•ƒ5:Copy copies the contents of the currently selected cell
or range and places them on the clipboard to be pasted into
other cells.
TI-89 shortcut: ¥ 6.TI-92 Plus / Voyage 200 PLT
shortcut: ¥C.
•ƒ6:Paste pastes the contents of the clipboard into the
currently selected cell or range.
TI-89 shortcut: ¥ 7.TI-92 Plus / Voyage 200 PLT
shortcut: ¥V.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 11
You can cut, copy, and paste from cell to cell and from edit line
to edit line, but not from cell to edit line or vice versa. If you copy
or cut a cell reference from a cell and then paste it to another
cell, the cell reference changes accordingly, but does not change
if you copy from edit line to edit line.
Example
1. In cell A1, enter =a4.
2. Select cell A1 and press ƒ5:Copy.
3. Select cell B1 and press ƒ6:Paste.Your spreadsheet
should look like this:
4. In cell A2, enter =a5.
5. Go to the edit line for cell A2. Select =A5 and press
ƒ5:Copy.
Notice that A4 has automatically
changed to B4.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 12
6. Exit the edit line for cell A2 and access the edit line for
cell B2. Press ƒ6:Paste and then ¸.Your
spreadsheet should look like this:
For more information about cut, copy, and paste, go to Editing
Data.
Clearing a spreadsheet
To delete all the contents of a spreadsheet, Press ƒ8:Clear
Sheet.This action cannot be undone.
Formatting data
Formatting allows you to choose:
Notice that A5 has stayed the same and has
not changed to B5.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 13
•To have values calculated automatically as you enter data or
to calculate the value for the active cell only. AutoCalc
automatically recalculates the entire spreadsheet as you
work. When AutoCalc is set to NO,cells with formulas
containing references to other cells do not recalculate when
you make changes to the referred cells.
•Whether the cursor automatically moves down or to the right
as you enter data in cells.
•Whether a formula or a value is displayed in the edit line.
Example
1. Press ƒ9:Format.
2. Select
1:YES or 2:NO for AutoCalc.
3. Select the cursor movement (1:DOWN,2:RIGHT,or 3:OFF).
4. Select what the edit line will display (1:FORMULA or
2:VALUE).
5. Press ¸.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 14
ecalculating a spreadsheet
When you start the CellSheet™ App, the AutoCalc feature is
turned on by default. If you turn it off, you must recalculate the
spreadsheet manually.
To recalculate the spreadsheet, press 2 Š (TI-89) or Š.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 15
Entering N mbers
Type the number on the edit line and press ¸.If the number
is too large to fit in the cell, the partial number and an ellipsis (…)
appear in the cell. Select the cell containing a truncated number
to view the complete number on the edit line. The following
screen contains an example of a truncated number.
Example
1. On the edit line, enter 14/16.
2. Press ¸.The cell displays 7/8.
—or —
Press ¥ ¸.The cell displays .875.
Truncated number
appears in cell
Complete number
appears on edit line

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 16
Entering Text
To ensure that text is treated as a string and not as a variable,
type quotation marks at the beginning and end of the string. Text
strings continue past the cell boundary as long as the next cell is
blank. If the next cell contains information, the text is truncated in
the cell. Select the cell containing truncated text to view the
complete text string on the edit line.
To type letters on the TI-89, press jand then the letter key.
Press 2 ™ to turn on alpha-lock and jto turn off alpha-
lock.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 17
Entering Symbolic Expressions
Symbolic expressions involve variables and other symbols such
as pand ˆ.You can enter symbolic expressions into cells and
use them in formulas.
The CellSheet™ App handles variables in the following manner.
•You can use defined and undefined variables.
•If a variable is defined, its value will be substituted for the
variable.
•If you use a variable in a symbolic expression and then
change the variable’s value outside of the CellSheet App,
any cells using that variable will include the new value once
those cells have been recalculated.
•You can use variables that are stored in any folder on your
unit by including the folder name with the variable name.
•When cell names and defined variables are not part of a
formula, they are replaced by their value.
•If a variable has the same name as a cell name, the value of
the cell will be used unless you type the folder name and
variable name, even if the variable is in the current folder.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 18
Example 1
The variable x does not have a value.
1. Type 3x^2+2x on the edit line.
2. Press ¸.The cell displays 3*x^2…, and the edit line
displays 3x^2+2*x.
Example 2
Assume that the variable PV (Present Value) is stored in a folder
named FINANCE and its value is 12.
On the edit line, enter =finance\PV. The cell displays 12.
—or —
Enter = on the edit line, press 2 °,and select PV in the
finance folder. Press ¸.The edit line displays finance\PV.
Press ¸and the cell displays 12.
Example 3
1. On the edit line of cell A1, enter finance\PV. Do not
precede the entry with =. Press ¸.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 19
2. Go to the Home screen by pressing "(TI-89),
¥"(TI-92 Plus), or ¥ "
(Voyage™ 200 PLT).
3. On the Home screen, change the value of PV from 12 to
14 by entering 14 §finance\pv and pressing ¸.
4. Press 2 a to return to the CellSheet™ App. Notice
that the value in cell A1 has remained as 12.

TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 20
Form las
Aformula is an equation that performs operations on
spreadsheet data. Formulas can:
•Perform mathematical operations, such as addition and
multiplication
•Refer to other cells in the same spreadsheet
When you enter a formula, the formula and the evaluation of the
formula are both saved in the cell.
The following example adds 15 to the value in cell C4 and then
divides the result by the sum of the values in cells B4, B5, and
B6.
Always precede a formula with = or + so the formula is saved to
that cell and values can be recalculated as variable values
change. Formulas in cells are re-evaluated after changes are
made in other cells and upon returning to the CellSheet™ App.
Cell reference
=(C4+15)/sum(B4:B6)
Numeric constant Spreadsheet function
Range reference