
All the variables available to you are listed on the variables menus, displayed by pressing .
Using the CAS in spreadsheet calculations
You can force a spreadsheet calculation to be performed by the CAS, thereby ensuring that results are
symbolic (and thus exact). For example, the formula =√Row in row 5 gives 2.2360679775 if not calculated by
the CAS, and √5 if it is.
You choose the calculation engine when you are entering the formula. As soon as you begin entering a
formula, the button changes to or (depending on the last selection). This is a
toggle key. Tap it to change it from one to the other.
When is showing, the calculation will be numeric (with the number of signicant digits limited by
the precision of the calculator). When is showing, the calculation will be performed by CAS and be
exact.
In the following gure, the formula in cell A is exactly the same as the formula in cell B: = Row2–√(Row–1).
The only dierence is that was showing (or selected) while the formula was being entered in B,
thereby forcing the calculation to be performed by the CAS. Note that CAS appears in red on the entry line if
the cell selected contains a formula that is being calculated by the CAS.
Buttons and keys
Button or key Purpose
Activates the entry line for you to edit the object in the selected cell. This button is visible only if the
selected cell has content.
Converts the text you have entered on the entry line to a name. This button is visible only when the
entry line is active.
/
Toggles between options that force the expression to be handled by the CAS; however, only
evaluates it. This button is visible only when the entry line is active.
Enters the $ symbol. This button is a shortcut when entering absolute references and is visible only
when the entry line is active.
Using the CAS in spreadsheet calculations 223
Comentários a estes Manuais