underlying formula that generates the value, move your cursor to the cell. The entry line shows a formula if there is one.

A single formula can add content to every cell in a column or row. For example, move to C (the heading cell for column C), enter S.SIN(Row)and press E. Each cell in the column is populated with the sine of the cell’s row number. A similar process enables you to populate every cell in a row with the same formula. You can also add a formula once and have it apply to every cell in the spreadsheet. You do this by placing the formula in the cell at the top left (the cell with the HP logo in it). To see how this works, suppose you want to generate a table of powers (squares, cubes, and so on) starting with the squares:

1.Tap on the cell with the HP logo in it (at the top left corner). Alternatively, you can use the cursor keys to move to that cell (just as you can to select a column or row heading).

2.On the entry line type S.RowkCol+1

Note that Row and Col are built-in variables. They are placeholders for the row number and column number of the cell that has a formula containing them.

3.Tap or Press E.

Note that each column gives the nth power of the row number starting with the squares. Thus 95 is 59,049.

Import data You can import data from the Statistics 1Var and Statistics 2Var apps (and from any app customized from a statistics app). In the procedure immediately below, dataset D1 from the Statistics 1Var app is being imported.

1.Select a cell.

2.Enter Statistics_1Var.D1.

3.Press E.

202

Spreadsheet

Page 206
Image 206
HP Prime Graphing NW280AAABA manual Enter Statistics1Var.D1, Press E