Casio fx-9860G Slim Manual De Usuario

9-20

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.

Variables

(A ~ Z, 

,

Q

)

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. 

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

(E)(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 
(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. 

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 
(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. 

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]”.