HP Prime Graphing Wireless Calculator Instrukcja Użytkownika Pobierz pdf (Strona 266)

100

101

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 when you have nished. 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 .

What you enter on the entry line is evaluated as soon as you press , with the result placed in the

cell or cells. However, if you want to retain the underlying formula, precede it with

. For

example, suppose that you want to add cell A1 (which contains 7) to cell B2 (which contains 12). Entering A1

B2 in, say, A4 yields19, as does entering 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

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 SIN(Row) and press . 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).

218 Chapter 10 Spreadsheet

1 2 ... 261 262 263 264 265 266 267 268 269 270 271 ... 700 701

Komentarze do niniejszej Instrukcji

Brak uwag

HP Prime Graphing Wireless Calculator Instrukcja Użytkownika Strona 266

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie HP Prime Graphing Wireless Calculator