[. . . ] 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ]