Casio fx-9860G User Guide - Page 255
Spreadsheet, 1. Spreadsheet Basics and the Function Menu, - how to put a text file
UPC - 079767177928
View all Casio fx-9860G manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 255 highlights
Chapter 9 Spreadsheet The Spreadsheet application provides you with powerful, take-along-anywhere spreadsheet capabilities. All of the operations in this section are performed in the S • SHT mode. Important! • The fx-7400GII and fx-9750GII are not equipped with the S • SHT mode. 1. Spreadsheet Basics and the Function Menu Selecting S • SHT on the Main Menu will display a spreadsheet screen. Entering the S • SHT mode automatically creates a new spreadsheet file named "SHEET". The spreadsheet screen shows a number of cells (squares) and the data contained in each cell. File name Shows as many characters as possible of the file name. Column letters (A to Z) Row numbers (1 to 999) Edit box Shows the contents of the cell where the cell cursor is currently located. When multiple cells are selected, the edit box indicates the selected cell range. Cell cursor Function menu 9 You can enter the following types of data into a cell. Constants A constant is something whose value is fixed as soon as you finalize its input. A constant can be either a numeric value, or a calculation formula (such as 7+3, sin30, A1s2, etc.) that does not have an equal sign in front of it. Text A character string that starts with a quote mark (") is treated as text. Formula A formula that starts out with an equal sign , such as =A1s2, is executed as it is written. Note that complex numbers are not supported in the S • SHT mode. I Spreadsheet Screen Function Menu • {FILE} ... Displays the following FILE submenu. • {NEW}/{OPEN}/{SV • AS}/{RECAL} • {EDIT} ... Displays the following EDIT submenu. • {CUT}/{PASTE}/{COPY}/{CELL}/{JUMP}/{SEQ}/{FILL}/{SRT • A}/{SRT • D} • PASTE is displayed only immediately after CUT or COPY is executed. 9-1