HP
Prime and Casio fxCG50: Basic
Spreadsheet Comparison

HP Prime

Casio fxCG50

Maximum
Spreadsheet Size

10,000 rows by 676 columns

999 rows by 26 columns

Accessing
Spreadsheet mode

[Apps], Spreadsheet

[MODE], 4

Creating
and saving files

The Spreadsheet app can be copied and renamed

Files can be created and saved. The fxCG50 stores spreadsheets as separate
files.

Clearing
the entire spreadsheet

[Shift], [Esc] (Clear), pressing OK

From the main menu: [ F3 ] (DELETE), [ F3 ]
(ALL), [ F1 ] (OK)

Inserting
text labels in cells

[ALPHA], [ 0 ] (“ “)

[ALPHA], [ *10^ ] (“). Text cells are indicated by a solid black
strip on the left side of the cell.

Inserting
the colon character, for ranges (:)

[ALPHA], [  ] ( : )

During cell entry/edit, [ F3 ] ( : )

Inserting
the dollar sign character, for absolute cell references ($)

During cell entry/edit, the touch key ( $ )

During cell entry/edit, [ F2 ] ( $ )

Starting
a formula with the equals sign (=)

[Shift], [ . ] ( = )

[Shift], [ . ] ( = )

The
SUM function

During formula entry: [Toolbox], (App), Spreadsheet, SUM

During formula entry: [ F5 ] (CELL), [ F5 ] (Sum). The function is named CellSum.

The
AVERAGE function

During formula entry: [Toolbox], (App),
Spreadsheet, AVERAGE

During formula entry: [ F5 ] (CELL), [ F3 ]
(Mean). The function is named CellMean.

The
IF function

During formula entry: [Toolbox], (Ctlg), select when
Syntax:
when(condition, do if true, do if false)

During formula entry: [ F5 ] (CELL), [ F4 ] (CellIf).

Entering
a random number

During formula entry: [Toolbox], 5. Probability, 4. Random:
1 for random number: RANDOM()
2 for random integer: RANDINT(a,b)

During formula entry: [OPTN], [ F5 ] (PROF), [ F4 ] (RAND)
[ F1 ] for random number: Ran#
[ F2 ] for random integer: RandInt#(a,b)

Change
text color

(Format), 4. Color, select color

[Shift], [ 5 ] (FORMAT), 1. Char Color,
choose color, [EXIT]

Change
cell color

(Format), 5. Fill, select color

[Shift], [ 5 ] (FORMAT), 2. Area Color,
choose color, [EXIT]

Number
of colors

16,777,216.
18 set colors, plus one master color selector

8 colors:
black, blue, red, magenta, green, cyan, yellow, white

Selecting
a Group of Cells

Press the soft key (Select), choose cells,
turn off by pressing (Sel *)

[Shift], [ 8 ] (CLIP), choose cells, turn of
by pressing [EXIT]

Sizing
columns

Go to top of the column, press (Format), 8, #
of bytes
Use 1 for auto sizing

(not available)

Number
format (number of decimal places)

Select cells, (Format), 1. Number Format. Select 8 to select the number of decimal
places

(not available)

Conditional
Formatting

(not available)

[ F6 ] ( > ), [ F5 ] (CONDIT), complete
the prompt

Filling
a formula

Select the source cell and copy it ([ Shift
], [ View ]). Select target cells and
paste the formula ( [ Shift ], [ Menu ], [ → ], select Formula)

Select the target cell range, [ F2 ] (EDIT), [ F6 ] ( > ), [ F1 ] (FILL)

Plotting
a scatter plot

(not available)

Select range, [ F6 ] ( > ), [ F1 ]
(Graph), [ F1 ] or [ F2 ] or [ F3 ] for Graph1, Graph2, or Graph3,
respectively

Trend
line analysis – Linear Regression

Go to an output cell, [ Shift ], [ . ]
(=),[Toolbox], (App), Spreadsheet, REGRS
Syntax: REGRS(range, 1)

Select range, [ F6 ] ( > ), [ F2 ] (CALC),
[ F3 ] (REG), [ F1 ] (X), [ F1 ] (ax+b).
Results are shown. Recall
separate variables through VARSSTATGRAPH

Do you use the spreadsheet mode on your
calculator? Check it out if you have not
done so.
Happy First Days of Summer (Northern
Hemisphere)/Winter (Southern Hemisphere)!
Eddie
This blog is property of Edward Shore, 2017
Conditional formatting is available on the Prime. Type this formula into any cell other that A1:
ReplyDelete=Cell(1,1,7):=IFTE(A1>0,16776960,16711680)
then Cell A1 is red if it contains a negative number and yellow if it contains a positive number or zero.
It says scatter plot is not possible on the prime, but don't you only have to copy the data to the advanced plot app and do it there?
ReplyDelete