Casio fx-991CW: The Spreadsheet
Welcome to the Casio fx-991CW segment, which is planned to be every last Saturday of the month for 2025!
Spreadsheet
Screenshots are used the classpad.net website which contains the fx-991CW emulator.
The Casio fx-991CW has a Spreadsheet mode. The spreadsheet is 45 rows and 5 columns. The spreadsheet has a memory capacity of 2,380 bytes. The spreadsheet has basic spreadsheet functions. Data is saved as long as the calculator is in the Spreadsheet mode. Individual results can be stored in the calculator’s memory registers A, B, C, D, E, F, x, y, and z.
The spreadsheet of the fx-991CW can only contain numerical data. There are no labels.
Auto Calc is assumed to be on.
Sum, Mean, and Count of a Range of Cells
The sum of a range: = Sum( α# : β# )
The arithmetic mean of all the numbers in a range: = Mean( α# : β# )
The count of all cells that have a value stored: = Sum( α# : β# ) ÷ Mean( α# : β# )
The count has to be constructed because there is no count function in the fx-991CW. Since Sum is Σx and Mean is Σx / n. Hence count, or n, is: Count = Sum / Mean = Σx / (Σx / n) = Σx * (n / Σx) = n.
The Sum, Count, and the colon character ( : ) are found in the Catalog.
Example:
|
A |
B |
1 |
45 |
88 |
2 |
25 |
76 |
3 |
93 |
39 |
Min, Max, and Statistical Range of a Range of Cells
The minimum value of a range of cells: = Min( α# : β# )
The maximum value of a range of cells: = Max( α# : β# )
The statistical range of a range of cells: = Max( α# : β# ) - Min( α# : β# )
Example:
|
A |
B |
1 |
45 |
88 |
2 |
25 |
76 |
3 |
93 |
39 |
Multiply a Range of Cells with a Constant Rate
We can apply a formula to a range of cells through the Tools menu. The Fill Formula dialogue:
Fill Formula
Fill = (start the formula with the cell you are currently at)
Range : α# : β#
> Confirm
To make a cell absolute, attack a dollar sign, to both the column letter and row number. The dollar sign ( $ ) is in the Catalog.
Example:
|
A |
B |
1 |
|
0.85 |
2 |
59.95 |
|
3 |
42.75 |
|
4 |
73.95 |
|
Storing a Cell’s Value
Exiting the Spreadsheet mode or turning the calculator off will erase the contents of the Spreadsheet. A way to store values permanently is to store the cell’s contents in one of the variables (A – F, x, y, z). To store a value:
1. Go to the cell.
2. Press the [ VARIABLE ] button.
3. Select a variable and press [ EXE ].
4. Select Store.
The value is now stored in the variable, which can be used in other modes. Unlike the spreadsheet, values stored in values are kept until a reset.
I hope you find this helpful.
Until next time,
Eddie
All original content copyright, © 2011-2025. Edward Shore. Unauthorized use and/or unauthorized distribution for commercial purposes without express and written permission from the author is strictly prohibited. This blog entry may be distributed for noncommercial purposes, provided that full credit is given to the author.
