Casio ClassPad 101 User's Guide Page 219
- Page / 275
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Chapter 13: Spreadsheet Application 219
Chapter 13:
Spreadsheet Application
The Spreadsheet application provides you with powerful, take-along-anywhere spreadsheet capabilities
including graphing and statistical calculations on your ClassPad. A spreadsheet has 999 rows and 64 columns
(A1 to BL999).
The Spreadsheet window shows a screen of cells and their contents. Each cell can contain a value, expression,
text, or a formula. Formulas can contain a reference to a specific cell or a range of cells.
Example Spreadsheet application windows
1 Spreadsheet window
2 Edit box … Shows the contents of the current cell as they were
input. You can tap the edit box and edit its contents.
3 Status bar … Shows the location (or range) of the current cell.
When a single cell is selected, the value of the cell is also shown.
4 Cell cursor … Indicates the currently selected cell(s).
5 Spreadsheet Graph window
1
2
5
3
4
Spreadsheet Window-Specific Menus and Buttons
The menus and buttons of the Spreadsheet window are described below. For information about the menus and
buttons of the Spreadsheet Graph window, see “13-2 Graphing”.
• Import variable data to spreadsheet .............................................................................................File - Import
• Export spreadsheet data to a variable ......................................................................................... File - Export
• Recalculate the contents of the cell(s) on the spreadsheet ................................................. File - Recalculate
• Display a dialog box for specifying the color of the text in the cell and the cell fill color ................ Edit - Style
• Toggle linking between text color and graph color on or off ....................................Edit - Format - Color Link
• Display the Options dialog box (see “Option Settings” on page 221) ......................... Edit - Format - Options
• Automatically resize columns to fit the data into the selected cells ..............Edit - Format - AutoFit Selection
• Display a dialog box for specifying column width .............................................. Edit - Format - Column Width
• Display a dialog box for specifying the number format (page 34)
of the selected cell(s) .................................................................................Edit - Format - Number Format
• Display or hide the Cell Viewer window ...................................................... Edit - Format - Cell Viewer or A
• Display a dialog box for specifying a cell to jump to .................................................. Edit - Select - Goto Cell
• Display a dialog box for specifying a range of cells to select ...............................Edit - Select - Select Range
• Insert row(s)/column(s) .......................................... Edit - Insert - Rows or K / Edit - Insert - Columns or a
• Delete the currently selected row(s)/column(s) .. Edit - Delete - Rows or H / Edit - Delete - Columns or J
• Delete the contents of the currently selected cells ............................................................Edit - Delete - Cells
- ClassPad II 1
- Backing Up Data 2
- Contents 3
- About This User’s Guide 9
- Chapter 1: 10
- 1-2 Power Supply 11
- Using the Application Menu 12
- Built-in Applications 12
- Application Window 13
- Using the O Menu 14
- 1-4 Input 15
- Soft Keyboard Key Sets 16
- Input Basics 17
- Message box 19
- ( ) 22
- 1-5 ClassPad Data 25
- Main Memory Data Types 26
- Main Memory Folders 26
- Using Variable Manager 27
- Selecting a Folder 28
- Managing Application Files 30
- Creating a New Variable 31
- Variable Usage Example 32
- “library” Folder Variables 32
- Application Format Settings 34
- k Graph Format Dialog Box 36
- k Geometry Format Dialog Box 38
- k Advanced Format Dialog Box 38
- 3. Reset the ClassPad 41
- Chapter 2: 42
- Main Application 42
- Using the e Key 43
- Calculation Priority Sequence 44
- Calculation Modes 44
- Complex Mode and Real Mode 45
- Angle Conversion (° 46
- Integer Functions 50
- Angle Symbol (∠) 52
- Derivative Symbol (’) 52
- Primality Test (isPrime) 53
- “with” Operator ( 53
- ∞, const, constn) 54
- n th-Delta Function 54
- 2-4 List Calculations 55
- Inputting Matrix Data 56
- Selecting a Number Base 58
- Arithmetic Operations 58
- Bitwise Operations 58
- 2-7 Using the Action Menu 59
- Example Screenshots 60
- L[ ()] ()= 62
- Using the Complex Submenu 67
- Using the List-Create Submenu 69
- Using the Vector Submenu 77
- ∞, and upper limit = ∞ 79
- Using the Assistant Submenu 82
- ∞, upper bound value = 36 83
- ∞, df = 18 84
- ∞, df = 4 85
- Using the Financial Submenu 88
- Using the Command Submenu 88
- Other Applications 89
- Using the Stat Editor Window 90
- Using the Geometry Window 91
- 2-10 Using Verify 92
- 2-11 Using Probability 92
- u To start up Probability 93
- Chapter 3: 95
- Graph & Table Application 95
- Graph window 96
- Table window 96
- 3-1 Storing Functions 97
- Graphing a Stored Function 98
- 3-2 Using the Graph Window 100
- Using View Window Memory 102
- Panning the Graph Window 103
- Scrolling the Graph Window 103
- Zooming the Graph Window 103
- Using Quick Zoom 104
- 3-3 Using Table & Graph 106
- (Link Trace) 107
- Generating a Summary Table 108
- 3-4 Using Trace 109
- 3-5 Using the Sketch Menu 110
- Using G-Solve Menu Commands 112
- 3-7 Modifying a Graph 113
- Chapter 4: 114
- Conics Application 114
- 4-1 Inputting an Equation 115
- 4-2 Drawing a Conics Graph 115
- Drawing a Circle 116
- Drawing an Ellipse 116
- Drawing a Hyperbola 116
- Drawing a General Conics 116
- Chapter 5: 118
- Function Graphs 123
- (y’, y”…, x) = 0 124
- Chapter 6: 125
- Sequence Application 125
- Generating a Number Table 126
- 6-2 Graphing a Recursion 127
- Chapter 7: 128
- Statistics Application 128
- u To create a list 129
- u To open an existing list 129
- u To close a list 129
- kPlot graphs 132
- u ClassPad Operation 135
- 1 2 63 3 4 4 4 75 137
- MSe Formulas 138
- 11 68 3 142
- 9 23 5 142
- Confidence Intervals 143
- Distributions 145
- : number of trials 146
- (x = 0, 1, 2, ...) 146
- : mean (0 < ) 146
- (x = 1, 2, 3, ...) 147
- Input and Output Terms 148
- Chapter 8: 150
- Geometry Application 150
- 8-1 Drawing Figures 151
- u To draw an ellipse 153
- u To draw a hyperbola 153
- u To draw a parabola 153
- u To draw a polygon 153
- Using the Construct Submenu 157
- u To construct a midpoint 158
- u To rotate a line segment 160
- 8-2 Editing Figures 161
- Moving and Copying Figures 162
- 8-4 Working with Animations 167
- u To trace a locus of points 168
- u To edit an animation 168
- Applications 170
- Chapter 9: 171
- Numeric Solver Application 171
- Chapter 10: 173
- u To insert a text row 174
- Expand button 175
- Tap here to display 175
- Application data strip list 176
- u To use a Geometry Link row 177
- File Compatibility 178
- Chapter 11: 179
- Financial Application 179
- Page Operations 180
- 11-3 Calculation Formulas 182
- ( ) 183
- Amortization 184
- Interest Conversion 184
- Cost/Sell/Margin 185
- Depreciation 185
- Bond Calculation 185
- (N–1+B/D ) 186
- (k–1+B/D ) 186
- Chapter 12: 189
- Program Application 189
- Creating a Program 190
- Pausing Program Execution 191
- Running a Program 192
- Terminating Program Execution 193
- Creating a Text File 193
- Using Text Files 194
- 12-2 Debugging a Program 195
- 12-3 User-defined Functions 196
- Using This Reference 198
- Syntax Conventions 198
- Command List 199
- M value, N value 205
- Chapter 13: 219
- Spreadsheet Application 219
- u Using the stylus 220
- Option Settings 221
- Selecting Cells 221
- Inputting Data into a Cell 222
- Inputting a Formula 222
- Inputting a Cell Reference 223
- Using the Cell Viewer Window 226
- 13-2 Graphing 229
- Graph Colors and Color Link 230
- MedMin MaxQ 234
- Other Graph Window Operations 236
- Distribution Calculations 240
- About DispStat Command 241
- Chapter 14: 243
- System Application 243
- Main Memory Sheet 244
- Configuring System Settings 245
- Warning! 246
- Chapter 15: 249
- Performing Data Communication 249
- Computer System Requirements 251
- Important! 251
- Auto Import of VCP Files 253
- VCP and XCP File Operations 253
- u To open a VCP file 254
- u To create a new VCP file 254
- ClassPads 255
- Communication Standby 257
- Precautions when Connecting 258
- Appendix 259
- System Variable Table 263
- Error Message Table 267
- Warning Message Table 269
- Low Memory Error Processing 270
- Number of Digits 271
- Precision 271
- Specifications 272
- CASIO COMPUTER CO., LTD 275
Related products and manuals for Mice Casio ClassPad 101
Mice Casio ClassPad 101 User Manual
(12 pages)
(12 pages)
© 2020, manymanuals.com. All rights reserved. | 1.256 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals