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.