SPREADSHEETThe Spreadsheet mode is useful for studying the statistics of data that require more than two lists. It also supports
recursive formulas, sequences, and series.
From the Main Menu, use the arrow keys to highlight theSpreadsheet 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 incell 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 first stepnecessary when entering a formula.

To “grab” the value within a cell, press i2(Grab).

28

fx-991EX Quick Start Guide

SPREADSHEETNavigate to cell B1, and press p (Set) to Grab the value in thatcell.

This places a reference to cell B1 within the formula.

To create a conversion from fluid ounces (fl oz.) to milliliters (mL),type O29.5735p.

The formula has correctly calculated that a 40 fl oz. bottle oflaundry detergent has a volume of 1182.9 mL.
Formulas can also be typed directly, without using the Grabcommand.
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 someother bottle sizes:
To populate many different cells with the same value, pressi2(Fill Value).
fx-991EX Quick Start Guide29

SPREADSHEET
Input the density of laundry detergent as the Value andA2:A6 as the cell Range. Press Qz(A)2Qy(:)
Qz(A)6pp.

Column A is now filled 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 beenadjusted 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).

30fx-991EX Quick Start Guide

SPREADSHEETNavigate to cell C1, which still displays the formula used toconvert fluid ounces to milliliters.

The ClassWiz has a “copy and paste” option that can be usedinstead 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 themass calculation formula from cell D1 into cells D2 through D6.

If done correctly, Column D should show masses (in grams) asshown.
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 checkhow much free space remains in ClassWiz’s memory, pressi4(Free Space).

fx-991EX Quick Start Guide31

SPREADSHEET
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 fluid ounces.

If one of each of these bottles was purchased, what is the total
weight of laundry detergent purchased that would be placed ina car?

Navigate to cell D7, and press i.
Return again to the summary statistics calculation screen(RRR) and select 4(Sum).

32fx-991EX Quick Start Guide

SPREADSHEETUse the Grab command rather than typing the locations of thecells in the cell range.

Press i2(Grab).

Scroll up to cell D1, and Set it as the object to be Grabbed bypressing p.

Use Qy(:) to type a colon.

Grab cell D6 as the ending cell in the cell range by pressingi2Ep.

Close the parentheses ()), and press p to calculate the sumof 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!

fx-991EX Quick Start Guide33

SPREADSHEETThis 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 inkilograms, 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 tobe edited.

34

fx-991EX Quick Start Guide

SPREADSHEETUse the right arrow key ($) to move within the formula,inserting parentheses and a factor-of-1000 adjustment asshown. Press $($$P1000)p.

Phew! That’s better. The car is no longer carrying 19+ tons oflaundry detergent home. The actual total weight is a much morereasonable 38 pounds.

fx-991EX Quick Start Guide

35