Casio FX-9750GII Bedienungsanleitung Seite 262
- Seite / 402
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
9-8
I Inputting a Formula into a Cell
For the sake of example, let’s try making a table that contains data based on the formula
<PRICE> s <QUANTITY> = <TOTAL>. To do this, we would put <PRICE> values in column
A, <QUANITY> values in column B, and calculation formulas (like = A1 s B1, = A2 s B2, and
so on) in column C. If the Auto Calc feature is enabled (On), the values in column C would be
recalculated and updated any time we change the values in column A or B.
In this example, note that we must start out the data in column C with the equal sign in
order to indicate it is a formula. In addition to values, arithmetic operators, and cell reference
names, a formula also can contain built-in function commands (page 2-11) and special S
•
SHT
mode commands (page 9-14).
S Formula Input Example
ABC
1
PRICE QUANTITY TOTAL
2 35 15 525
3 52 15 780
4 78 20 1560
Procedure
1. Input the text for line 1, and the applicable values in cells A2 through B4.
2. Move the cursor to cell C2, and input the formula for A2 s B2.
?T(A)A?J(B)AU
3. Copy the formula in cell C2 and copy it into cells C3 and C4. Move the cell cursor to cell C2
and then perform the following operation.
(EDIT)(COPY)A(PASTE)A(PASTE))
• For details about the copy and paste operations, see
“Copying and Pasting Cell Contents” (page 9-10).
I Inputting a Cell Reference Name
Each cell on a spreadsheet has what is called a “reference name”, which is derived by
combining its column name (A through Z) with its row name (1 through 999). A cell reference
name can be used inside of a formula, which makes the value of the called cell part of the
formula. See “Inputting a Formula into a Cell” above for more information. There are two
methods you can use to input a cell reference name: direct input of the name and input using
the GRAB command. The following illustrates how you would use each of these methods to
input =A1+5 into cell B1.
- http://edu.casio.com 1
- http://edu.casio.com/forum/ 1
- Contents 3
- Ⅱ SD only) 5
- — Read This First! 6
- I Contrast Adjustment 7
- Basic Operation 8
- 2. Display 9
- I Normal Display 11
- I About the Function Menu 11
- I About Display Screens 11
- I Special Display Formats 12
- I Inputting Calculations 12
- I Editing Calculations 13
- I Using Replay Memory 14
- S To specify the copy range 15
- S To cut the text 15
- S Using the MATH Menu 19
- 1+ x +1dx 20
- I History Function 24
- ( ) 26
- 5. Option (OPTN) Menu 29
- 6. Variable Data (VARS) Menu 30
- 7. Program (PRGM) Menu 32
- 8. Using the Setup Screen 33
- 9. Using Screen Capture 36
- Manual Calculations 39
- 2. Special Functions 44
- S String Memory 45
- II : 2(FMEM) 47
- = 0 to 9) 48
- 4. Function Calculations 49
- I Angle Units 51
- I Other Functions 52
- E10 B–A<1E10 1 n 999 54
- I Coordinate Conversion 55
- 10P4 = 5040 56
- 10C4 = 210 56
- I Fractions 57
- S About Logical Operations 58
- 5. Numerical Calculations 59
- II: (CALC) 60
- E–10 and cannot be changed 63
- Positive 65
- Negative part ( 65
- rƧ]/[a+bi] 70
- Calculations with Integers 71
- I Selecting a Number System 72
- S Negative Values 73
- S Bitwise Operations 73
- 8. Matrix Calculations 74
- 1 2 3 75
- 4 5 6 75
- I Matrix Cell Operations 76
- S Row Calculations 77
- S Row Operations 78
- S Column Operations 79
- Matrix name 80
- Number of rows/columns 80
- S Matrix Inversion [x 84
- S Squaring a Matrix [x 85
- Integer of a Matrix 85
- a+bi, r 86
- a+bi” and “r 86
- II: (CONV) 87
- List Function 90
- I Editing List Values 91
- I Naming a List 92
- I Sorting List Values 93
- 2. Manipulating List Data 94
- I Error Messages 99
- I Recalling List Contents 100
- Equation Calculations 103
- 3. Solve Calculations 106
- Graphing 107
- Y=) to (Yb) 108
- I V-Window Memory 110
- I Specifying the Graph Range 110
- 3. Drawing a Graph 112
- I Graph Memory 116
- S To recall a stored graph 117
- 6. Manual Graphing 118
- 7. Using Tables 121
- S Generating a Table 122
- I Editing Tables 123
- • CON) ... line graph 124
- • PLT) ... plot type graph 124
- 8. Dynamic Graphing 126
- I Using Dynamic Graph Memory 128
- 10. Graphing a Conic Section 133
- 12. Function Analysis 135
- I Graph to Table 136
- I Coordinate Rounding 136
- I Calculating the Root 136
- Statistical Graphs and 141
- Calculations 141
- Statistical Data 144
- I Med-box Graph 145
- I Bar Graph 145
- I Normal Distribution Curve 146
- I Broken Line Graph 146
- 0.1 0.2 0.4 0.7 0.8 0.9 1.0 148
- I Linear Regression Graph 151
- I Med-Med Graph 151
- I Power Regression Graph 153
- I Sinusoidal Regression Graph 153
- I Logistic Regression Graph 153
- I Residual Calculation 153
- I Regression Calculation 156
- 5. Tests 162
- I Z Tests 164
- Z Test Common Functions 164
- S 2-Sample Z Test 165
- S 1-Prop Z Test 165
- I t Tests 166
- S 1-Sample t Test 167
- S 2-Sample t Test 167
- S LinearReg t Test 168
- Test Common Functions 169
- GOF Test (Ƶ 169
- one-way Test) 169
- I 2-Sample F Test 170
- I ANOVA (Two-Way) 173
- S Input Example 174
- S Results 174
- 6. Confidence Interval 175
- I Z Interval 176
- Z Interval 176
- I t Interval 177
- 7. Distribution 178
- I Normal Distribution 179
- I Student-t Distribution 181
- Distribution 182
- F Distribution 183
- I Binomial Distribution 184
- I Poisson Distribution 186
- I Geometric Distribution 187
- I Hypergeometric Distribution 189
- I Input Terms 190
- I Output Terms 192
- 9. Statistic Formula 193
- I Confidence Interval 194
- I Distribution (Continuous) 194
- I Distribution (Discrete) 195
- Financial Calculation (TVM) 196
- 2. Simple Interest 197
- , = (1 + i) 198
- 0. The cash flow one year 200
- +1 0, or 0 201
- 5. Amortization 202
- 6. Interest Rate Conversion 204
- S Formula 205
- &67 : cost 205
- SEL : selling price 205
- 05* : margin 205
- 8. Day/Date Calculations 206
- 9. Depreciation 207
- 10. Bond Calculations 209
- S Annual Yield (YLD) 210
- CPN ...... coupon rate 210
- YLD ...... annual yield 210
- Programming 212
- 2. PRGM Mode Function Keys 213
- • SPD}*/ 214
- 4. File Management 216
- I Deleting a Program 217
- I Registering a password 217
- 5. Command Reference 218
- I Basic Operation Commands 219
- I ProgramCommands(COM) 220
- I Jump Commands (JUMP) 223
- I ClearCommands(CLR) 225
- I Display Commands (DISP) 225
- No parameters 226
- I Input/Output Commands (I/O) 227
- I Strings 229
- I Text Display 232
- (>Row+) 233
- S To add two rows (Row+) 233
- Population mean* 237
- Data upper limit 237
- Data lower limit 237
- • Normal Distribution 240
- • Binomial Distribution 242
- • Poisson Distribution 242
- • Geometric Distribution 242
- • Hypergeometric Distribution 243
- • Z Test 243
- • t Test 244
- • F Test 245
- • Setup Commands 246
- 7. PRGM Mode Command List 248
- Level 1Level 2Level 3 Command 251
- Level 3 Level 4 Command 252
- 8. Program Library 253
- Program Name Ellipse 254
- Spreadsheet 255
- I Spreadsheet File Operations 256
- S Auto Save 257
- S Auto Calc 257
- I Using the Cell Cursor 258
- S To select a range of cells 259
- S To edit cell data 260
- I Inputting Text into a Cell 261
- S Formula Input Example 262
- I Sorting Constant Data 266
- 3. Using Special S 268
- SHT Mode Commands 268
- SHT Mode Command Example 269
- I STAT Mode and S 273
- SHT Mode Memory 274
- Important! 275
- Chapter 10 eActivity 276
- 1. eActivity Overview 276
- 2. eActivity Function Menus 277
- 3. eActivity File Operations 278
- 4. Inputting and Editing Data 279
- I Inputting into a Text Line 280
- I Using Strips 282
- S To insert a strip 283
- S Notes Strips 285
- Important! 287
- Memory Manager 289
- I Memory Information Screen 290
- • F) to 292
- I Copying Data 294
- I Deleting Files 296
- II SD only) 296
- I Searching for a File 296
- I Backing Up Main Memory Data 297
- System Manager 300
- I System Language Setting 301
- I Version List 302
- Data Communications 304
- S To execute a send operation 307
- Data item name 309
- , fx-9860G AU 310
- II will cause an 311
- Series Calculator 313
- 5. Screen Image Send 314
- S Precautions when Connecting 317
- Using SD Cards 318
- Front BackFront Back 319
- 2. Formatting an SD Card 320
- Appendix 321
- II to an older model 323
- II to an 323
- II SD only 324
- 2. Input Ranges 325
- • Complex numbers can be 326
- Application 327
- 20051101 328
- 20070101 329
- ')J 397
- ') 397
- ') 399
- CASIO COMPUTER CO., LTD 402
Verwandte Produkte und Handbücher für Taschenrechner, Organisatoren Casio FX-9750GII
(31 Seiten)
(92 Seiten)
Taschenrechner, Organisatoren Casio ALGEBRA FX 2.0 Equation Calculations Bedienungsanleitung
(8 Seiten)
(8 Seiten)
Taschenrechner, Organisatoren Casio ALGEBRA FX 2.0 Statistical Graphs and Calculations Bedienungsanleitung
(32 Seiten)
(32 Seiten)
Taschenrechner, Organisatoren Casio ALGEBRA FX 2.0 Computer Algebra System and Tutoria Bedienungsanleitung
(30 Seiten)
(30 Seiten)
Taschenrechner, Organisatoren Casio ALGEBRA FX 2.0 System Settings Menu Bedienungsanleitung
(8 Seiten)
(8 Seiten)
Taschenrechner, Organisatoren Casio ALGEBRA FX 2.0 Manual Calculations Bedienungsanleitung
(70 Seiten)
(70 Seiten)
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.256 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern