Home » Casio Manuals » Calculators » Casio FX-9750GII-SC » Manual Viewer

Casio FX-9750GII-SC User Guide - Page 274

S • SHT Mode Memory, Saving Spreadsheet Data to a Memory

UPC - 079767186067

View all Casio FX-9750GII-SC manuals

Add to My Manuals
Save this manual to your list of manuals

Page 274 highlights

5. S • SHT Mode Memory You can use the calculator's different types of memory (variables, list memory, file memory, matrix memory) to store data, and recall data from a memory into the spreadsheet. I Saving Spreadsheet Data to a Memory The following table shows an overview of the store operations for each type of memory. For details about each operation, see the example operations following the table. Memory Type Variables (A ~ Z, r, Q) List Memory (List 1 ~ List 26) File Memory (File 1 to File 6) Matrix Memory (Mat A ~ Mat Z) Store Operation You can assign the content of a single cell to a variable. While a single cell is selected, press (E)(STO)(VAR), and then specify the variable name on the screen that appears. You can store data in a range of cells in a single row or a single column in list memory. While a range of cells in a single row or single column is selected, press (E)(STO)(LIST), and then specify the list number on the screen that appears. You can store data in a range of cells that spans a multiple rows and columns in file memory. While a range of cells is selected, press (E)(STO)(FILE), and then specify the file number on the screen that appears. The first column of the selected range is stored in the specified file as List 1, the second column is saved as List 2, and so on. You can store data in a range of cells that spans a multiple rows and columns in matrix memory. While a range of cells is selected, press (E)(STO)(MAT), and then specify the matrix name on the screen that appears. The first column of the selected range is stored in the specified matrix as List 1, the second column is saved as List 2, and so on. Important! The following describes what happens if you try to store data in memory when a cell does not contain any data, when a cell contains text, or when ERROR is displayed for a cell. • If you are assigning data to a variable, an error occurs. • If you are storing data in list memory, file memory, or matrix memory, 0 is written into the applicable cell(s). S Example: To store column data in list memory 1. In a single column, select the range of cells you want to store in list memory. • For example, you could select A1:A10. 2. Press (E)(STO)(LIST). • This will display a screen like the one shown to the right. The "Cell Range" setting will show the range of cells you selected in step 1. 3. Press A to move the highlighting to "List[1-26]". 9-20

Section	Page
Contents	3
Getting Acquainted — Read This First!	6
Chapter 1 Basic Operation	8
1. Keys	8
2. Display	9
3. Inputting and Editing Calculations	12
4. Using the Math Input/Output Mode	17
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
10. When you keep having problems...	37
Chapter 2 Manual Calculations	39
1. Basic Calculations	39
2. Special Functions	44
3. Specifying the Angle Unit and Display Format	48
4. Function Calculations	49
5. Numerical Calculations	59
6. Complex Number Calculations	68
7. Binary, Octal, Decimal, and Hexadecimal Calculations with Integers	71
8. Matrix Calculations	74
9. Metric Conversion Calculations	86
Chapter 3 List Function	90
1. Inputting and Editing a List	90
2. Manipulating List Data	94
3. Arithmetic Calculations Using Lists	99
4. Switching Between List Files	102
Chapter 4 Equation Calculations	103
1. Simultaneous Linear Equations	103
2. High-order Equations from 2nd to 6th Degree	104
3. Solve Calculations	106
Chapter 5 Graphing	107
1. Sample Graphs	107
2. Controlling What Appears on a Graph Screen	108
3. Drawing a Graph	112
4. Storing a Graph in Picture Memory	116
5. Drawing Two Graphs on the Same Screen	117
6. Manual Graphing	118
7. Using Tables	121
8. Dynamic Graphing	126
9. Graphing a Recursion Formula	128
10. Graphing a Conic Section	133
11. Changing the Appearance of a Graph	133
12. Function Analysis	135
Chapter 6 Statistical Graphs and Calculations	141
1. Before Performing Statistical Calculations	141
2. Calculating and Graphing Single-Variable Statistical Data	144
3. Calculating and Graphing Paired-Variable Statistical Data	149
4. Performing Statistical Calculations	155
5. Tests	162
6. Confidence Interval	175
7. Distribution	178
8. Input and Output Terms of Tests, Confidence Interval, and Distribution	190
9. Statistic Formula	193
Chapter 7 Financial Calculation (TVM)	196
1. Before Performing Financial Calculations	196
2. Simple Interest	197
3. Compound Interest	198
4. Cash Flow (Investment Appraisal)	200
5. Amortization	202
6. Interest Rate Conversion	204
7. Cost, Selling Price, Margin	205
8. Day/Date Calculations	206
9. Depreciation	207
10. Bond Calculations	209
11. Financial Calculations Using Functions	211
Chapter 8 Programming	212
1. Basic Programming Steps	212
2. PRGM Mode Function Keys	213
3. Editing Program Contents	214
4. File Management	216
5. Command Reference	218
6. Using Calculator Functions in Programs	232
7. PRGM Mode Command List	248
8. Program Library	253
Chapter 9 Spreadsheet	255
1. Spreadsheet Basics and the Function Menu	255
2. Basic Spreadsheet Operations	256
3. Using Special S • SHT Mode Commands	268
4. Drawing Statistical Graphs, and Performing Statistical and Regression Calculations	269
5. S • SHT Mode Memory	274
Chapter 10 eActivity	276
1. eActivity Overview	276
2. eActivity Function Menus	277
3. eActivity File Operations	278
4. Inputting and Editing Data	279
Chapter 11 Memory Manager	289
1. Using the Memory Manager	289
Chapter 12 System Manager	300
1. Using the System Manager	300
2. System Settings	300
Chapter 13 Data Communications	304
1. Connecting Two Units	304
2. Connecting the Calculator to a Personal Computer	304
3. Performing a Data Communication Operation	305
4. Data Communications Precautions	308
5. Screen Image Send	314
Chapter 14 Using SD Cards (fx-9860G SD only)	318
1. Using an SD Card	318
2. Formatting an SD Card	320
3. SD Card Precautions during Use	320
Appendix	321
1. Error Message Table	321
2. Input Ranges	325
E-CON2 Application	327
1 E-CON2 Overview	329
2 Using the Setup Wizard	330
3 Using Advanced Setup	340
4 Using a Custom Probe	354
5 Using the MULTIMETER Mode	360
6 Using Setup Memory	361
7 Using Program Converter	365
8 Starting a Sampling Operation	370
9 Using Sample Data Memory	373
10 Using the Graph Analysis Tools to Graph Data	376
11 Graph Analysis Tool Graph Screen Operations	380

Match case Limit results 1 per page

9-20

5. S

•

SHT Mode Memory

You can use the calculator’s different types of memory (variables, list memory, file memory,

matrix memory) to store data, and recall data from a memory into the spreadsheet.

Saving Spreadsheet Data to a Memory

The following table shows an overview of the store operations for each type of memory. For

details about each operation, see the example operations following the table.

Memory Type

Store Operation

Variables

(A ~ Z,

)

You can assign the content of a single cell to a variable.

While a single cell is selected, press

(

)

(STO)

(VAR), and

then specify the variable name on the screen that appears.

List Memory

(List 1 ~ List 26)

You can store data in a range of cells in a single row or a single

column in list memory.

While a range of cells in a single row or single column is selected,

press

(

)

(STO)

(LIST), and then specify the list number

on the screen that appears.

File Memory

(File 1 to File 6)

You can store data in a range of cells that spans a multiple rows

and columns in file memory. While a range of cells is selected, press

(

)

(STO)

(FILE), and then specify the file number on the

screen that appears.

The first column of the selected range is stored in the specified file

as List 1, the second column is saved as List 2, and so on.

Matrix Memory

(Mat A ~ Mat Z)

You can store data in a range of cells that spans a multiple rows and

columns in matrix memory. While a range of cells is selected, press

(

)

(STO)

(MAT), and then specify the matrix name on the

screen that appears.

The first column of the selected range is stored in the specified

matrix as List 1, the second column is saved as List 2, and so on.

Important!

The following describes what happens if you try to store data in memory when a cell does not

contain any data, when a cell contains text, or when ERROR is displayed for a cell.

• If you are assigning data to a variable, an error occurs.

• If you are storing data in list memory, file memory, or matrix memory, 0 is written into the

applicable cell(s).

Example: To store column data in list memory

1. In a single column, select the range of cells you want to store in list memory.

• For example, you could select A1:A10.

2. Press

(

)

(STO)

(LIST).

• This will display a screen like the one shown to the right.

The “Cell Range” setting will show the range of cells you

selected in step 1.

3. Press

to move the highlighting to “List[1-26]”.