User manual TEXAS INSTRUMENTS VOYAGE 200

[. . . ] TI TI-89/TI-92 Plus/VoyageTM 200 CellSheetTM How To. . . Navigate in Spreadsheets Cut, Copy, and Paste Format Spreadsheets Select, Insert, or Delete Manipulate Data Enter Data Sort Data Use Statistics Edit Data Plot Data Import and Export Data Examples Sort by Key Column Interest and Principal Paid Linear Regression Maximum Area More Information Customer Support Menu Map Error Messages Key Shortcuts 2/7/02 © 2001, 2002 Texas Instruments 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. The instructions in this guidebook refer to this Flash application only. [. . . ] 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. Default Setting YES TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App Page 46 Field Name Cursor Mvmt Description Controls the direction that the cursor moves after you press Í on the edit line. Select 1:DOWN, 2:RIGHT, or 3:OFF. Default Setting DOWN Show Controls what information is displayed on the edit line ­ formulas or resultant values. If you have chosen to show values and a selected cell contains a formula, the formula displays on the edit line when you press ¸ so that you can edit it. Select 1:FORMULA or 2:VALUE. FORMULA Formatting a column Formatting selected columns changes the way that data is viewed. 8:Column Format, and then change any of the following settings in the COLUMN FORMAT dialog box. Changes apply only to the current spreadsheet. Field Name Column Description The column you wish to format. Default Setting The column(s) currently selected TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App Page 47 Field Name Display Digits Description Determines how many digits, up to 12, are displayed in the column. The default is FLOAT 6, which means that results are rounded to a maximum of six digits. Changing the mode screen setting does not affect data displayed in the CellSheetTM App. Determines how many characters are displayed in the column's cells. Choose 1:DEFAULT, 2:LEFT, or 3:RIGHT. Default Setting FLOAT 6 Col Width 6 Justification Numeric values are right-justified in the cell; text is left-justified. TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App Page 48 Blank Cells If a blank cell is referenced directly in a formula, it is treated as a 0 (zero). For example, if A1 is blank and A2 contains the formula =A1x2, A2 will evaluate to 0 (zero). If a range of cells contains a blank cell, the blank cell is ignored in calculations. A4 evaluates to 2. TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App Page 49 Archiving Spreadsheets You cannot change cell entries or format settings in an archived spreadsheet. Press 8:Archive Variable. Note Archived and locked spreadsheets can be opened for viewing purposes only. Only unarchived/unlocked spreadsheets can be opened for editing. TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App Page 50 Key Shortcuts Press B:Help for a help screen showing navigation, selecting, and editing key shortcuts. To. . . Enter a value or symbolic expression in a cell Enter a formula in a cell Do this. . . From a selected cell, press Á if you need the cell content to be updated. Press ¸. Enter a string (text) in a cell TI-89 / TI-92 Plus / VoyageTM 200 PLT CellSheetTM App Page 51 To. . . If the variable has the same name as a cell or if it is in a different folder, include the path name. [. . . ] 16 Entering Symbolic Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Formulas. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Editing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ]