[. . . ] 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 2
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. [. . . ] If you wish to save a particular statistics variable, a better option would be to paste it into a non-formula cell.
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App
Page 43
Sorting Data
You can sort columns of data whose cells contain numbers or text. If any cell in the range to be sorted contains formulas, the range cannot be sorted. You can export a range containing formulas as a list or matrix, then import the data that now contains no formulas, and then sort the imported range. Sorting by key column Sometimes columns along the same row contain related information, such as a student’s first name, last name, and test scores. In such a case, sorting only a single column would destroy the relationship between the columns. All columns must have the same length.
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App Page 44
Example Sort a grade sheet by last name. Press ¸ ¸.
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App
Page 45
Formatting
Format information is retained after the CellSheet™ App is closed. Formatting an entire spreadsheet To format the entire spreadsheet, press ƒ 9:Format and then change any of the following settings in the FORMATS dialog box. The changes apply only to the current spreadsheet.
Field Name AutoCalc Description Automatically recalculates the entire spreadsheet as you work. Note: When AutoCalc is set to NO, cells with new formulas that you create will display a value determined using the current values in the other cells. Because the current cell is the only one that is evaluated, other cells may be incorrect. • ¥ A or ¥ B moves the cursor to the first or last cell in a row. • 2 B or 2 A moves the cursor several columns to the right or left. Note: For the TI-89 only, press j in the CellSheet™ App dialog boxes before typing alpha characters.
Navigate rapidly in a spreadsheet
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App
Page 52
To… Select a range of cells
Do this… 1. Tip: For a large range, it might be faster to use … 2:Select Range. In the dialog box, type the column/row of the beginning and end of the range and press ¸ (Example: a6:m53). Tip: Press B to deselect a row.
Select one or more rows
Select one or more columns
Insert a cell
Insert a row
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App
Page 53
To… Insert a column
Do this… 1. Columns to the right of the deleted area move to the left by the number of columns deleted. Press M.
Delete a cell
Delete a row
Delete a column
Clear data without deleting the cell, row, or column
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App
Page 54
To… Cut, copy, and paste
Do this… To cut: 1. Press: TI-89: ¥ 5 TI-92 Plus / Voyage™ 200 PLT: ¥ X To copy: 1. Press: TI-89: ¥ 6 TI-92 Plus / Voyage 200 PLT: ¥ C To paste: 1. Press: TI-89: ¥ 7 TI-92 Plus / Voyage 200 PLT: ¥ V Note: If you are pasting to a range, the destination range must have the same dimensions as the cut or copied range.
TI-89 / TI-92 Plus / Voyage™ 200 PLT CellSheet™ App
Page 55
To… Quick fill
Do this… 1. [. . . ] 5 Navigating and Selecting Cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 File Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Entering Numbers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Entering Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ]