fx-991EX Quick Start Guide
30
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 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
i
1
(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.
SPREADSHEET