fx-991EX Quick Start Guide28
From the Main Menu, use the arrow keys to highlight the
Spreadsheet icon, then press por press 8.
The ClassWiz spreadsheet looks and acts similarly to many
popular software spreadsheet applications.
Investigate the mass of different common sizes of laundry
detergent bottles, when the average density of liquid laundry
detergent is 0.885 g/mL. Type 0.885p in
cell A1.
Use the arrow keys to move over to cell B1
, and input
40p to represent a 40 fl oz. (1 fl oz. = 29.5735 mL)
bottle of laundry detergent.
Move to cell C1, and press Qr(=) to create an equals
sign. Like in other spreadsheet programs, this is the rst step
necessary when entering a formula.
To “grab” the value within a cell, press i2(Grab).
The Spreadsheet mode is useful for studying the statistics of data that require more than two lists. It also supports
recursive formulas, sequences, and series.
SPREADSHEET
fx-991EX Quick Start Guide 29
Navigate to cell B1, and press p (Set) to Grab the value in that
cell.
This places a reference to cell B1 within the formula.
To create a conversion from uid ounces ( oz.) to milliliters (mL),
type O29.5735p.
The formula has correctly calculated that a 40 oz. bottle of
laundry detergent has a volume of 1182.9 mL.
Formulas can also be typed directly, without using the Grab
command.
Navigate to cell D1 and input Qr(=)
Qz(A)1OQu(C)1p.
A 40 fl oz. (1182.9 mL) bottle of laundry detergent
has a mass of 1046.9 grams.
Now, let’s use the power of relational formulas to check some
other bottle sizes:
To populate many different cells with the same value, press
i2(Fill Value).
SPREADSHEET
fx-991EX Quick Start Guide30
Input the density of laundry detergent as the Value and
A2:A6 as the cell Range. Press Qz(A)2Qy(:)
Qz(A)6pp.
Column A is now lled with the density value.
Next populate column B with additional bottle sizes.
Navigate to cell B2, and input the value 75 by pressing
75p.
To populate many different cells with the same formula,
press i1(Fill Formula).
Input the formula Qx(B)2+25p.
Notice, the cell Range is pre-populated with the currently
highlighted cell (B3).
Use the right arrow to edit only the end cell by pressing
$$$$$$o6pp.
Scroll down to cell B6 to make sure that the formula has been
adjusted relative to each cell’s position, so that cells B2
to B6 now
display bottle sizes from 75 to 175 fl oz. (1 fl oz. = 29.5735 mL).
SPREADSHEET
fx-991EX Quick Start Guide 31
Navigate to cell C1, which still displays the formula used to
convert uid ounces to milliliters.
The ClassWiz has a “copy and paste” option that can be used
instead of retyping the same formula repeatedly.
Press iR2(Copy & Paste).
The formula from the currently highlighted cell (C1) has now
been copied.
Scroll down one cell at a time (Rp) to Paste this formula
into cells C2 through C6.
Column C now contains the volumes, in milliliters, of the different
sizes of laundry detergent bottles.
To exit Copy & Paste mode, press C.
Time to practice! Use the same technique to Copy & Paste the
mass calculation formula from cell D1 into cells D2 through D6.
If done correctly, Column D should show masses (in grams) as
shown.
So, for example, a 175 fl oz. (5175.3 mL) bottle of laundry
detergent has a mass of about 4.5 kg.
A decent amount of data has been entered now. To check
how much free space remains in ClassWiz’s memory, press
i4(Free Space).
SPREADSHEET
fx-991EX Quick Start Guide32
1318 Bytes of memory remain as free space.
Numerical values require 10 Bytes each, while formulas require
17+ Bytes each.
Determine the average capacity of the different bottles of laundry
detergent.
Navigate to cell B7, and press i.
Scroll down three pages (RRR), and select 3(Mean).
Type in the cell range of the average Qx(B)1Qy(:)
Qx(B)6)p.
The average capacity is 110.83 uid ounces.
If one of each of these bottles was purchased, what is the total
weight of laundry detergent purchased that would be placed in
a car?
Navigate to cell D7, and press i.
Return again to the summary statistics calculation screen
(RRR) and select 4(Sum).
SPREADSHEET
fx-991EX Quick Start Guide 33
Use the Grab command rather than typing the locations of the
cells in the cell range.
Press i2(Grab).
Scroll up to cell D1, and Set it as the object to be Grabbed by
pressing p.
Use Qy(:) to type a colon.
Grab cell D6 as the ending cell in the cell range by pressing
i2Ep.
Close the parentheses ()), and press p to calculate the sum
of the masses in cells D1 through D6.
The bottles would have a total mass of 17404 grams, or about
17.4 kilograms.
But this is a mass, not a weight!
SPREADSHEET
fx-991EX Quick Start Guide34
This is one example of the powerful ways in which various
features of the fx-991EX can be combined.
Begin entering the formula as shown into cell D8 by pressing
Qr(=)Qj(D)7.
Press q8(CONV) to access the Conversion menu.
Select 4(Mass).
Choose mass conversion 4(kg:lb).
This will convert the mass from cell D7, which is currently in
kilograms, into pounds.
Press p, and Voila!
Even ClassWiz’s powerful Conversion feature can be used within
the Spreadsheet module. But wait… 38 thousand pounds?!?
17404 grams needs to be converted into kilograms.
With cell D8 highlighted, press i3(Edit Cell).
A cursor appears in the previously entered formula, allowing it to
be edited.
SPREADSHEET
fx-991EX Quick Start Guide 35
Use the right arrow key ($) to move within the formula,
inserting parentheses and a factor-of-1000 adjustment as
shown. Press $($$P1000)p.
Phew! That’s better. The car is no longer carrying 19+ tons of
laundry detergent home. The actual total weight is a much more
reasonable 38 pounds.
SPREADSHEET
