The following is a more complex example involving the naming of an entire column.

1.Select cell A (that is the header cell for column A).

2.Enter COST and tap

.

3.Select cell B (that is the header cell for column B).

4.Enter

S.COST*0.33 and tap .

5.Enter some values in column A and observe the calculated results in column B.

Entering content

You can enter content directly in the spreadsheet or import data from a statistics app.

Direct entry A cell can contain any valid calculator object: a real number (3.14), a complex number (a + ib), an integer (#1Ah), a list ({1, 2}), a matrix or vector([1, 2]), a string ("text"), a unit (2_m) or an expression (that is, a formula). Move to the cell you want to add content to and start entering the content as you would in Home view. Press Ewhen you have finished. You can also enter content into a number of cells with a single entry. Just select the cells, enter the content—for example, =Row*3—and press E.

What you enter on the entry line is evaluated as soon as you press E, with the result placed in the cell or cells. However, if you want to retain the underlying formula, precede it with S.. For example, suppose that want to add cell A1 (which contains 7) to cell B2 (which contains 12). Entering A1+B2Ein, say, A4 yields19, as does entering S.A1+B2 in A5. However, if the value in A1 (or B2) changes, the value in A5 changes but not the value in A4. This is because the expression (or formula) was retained in A5. To see if a cell contains just the value shown in it or also an

Spreadsheet

201

Page 205
Image 205
HP Prime Graphing NW280AAABA manual Entering content, Enter Cost and tap, COST*0.33 and tap