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

100

101

35. Choose a color for the background of the selected cells.

The most important cells in the spreadsheet will now stand out from the rest.

The spreadsheet is complete, but you may want to check all the formulas by adding some dummy data to the

PRICE column. When the prot reaches 250, you should see the value in D9 change from 0 to 1.

Basic operations

Navigation, selection, and gestures

You can move about a spreadsheet by using the cursor keys, by swiping, or by tapping and

specifying the cell you want to move to.

You select a cell simply by moving to it. You can also select an entire column—by tapping the column letter—

and select an entire row (by tapping the row number). You can also select the entire spreadsheet: just tap on

the unnumbered cell at the top-left corner of the spreadsheet. (It has the HP logo in it.)

A block of cells can be selected by pressing down on a cell that will be a corner cell of the selection and, after a

second, dragging your nger to the diagonally opposite cell. You can also select a block of cells by moving to a

corner cell, tapping , and using the cursor keys to move to the diagonally opposite cell. Tapping

or another cell deselects the selection.

Cell references

You can refer to the value of a cell in formulas as if it were a variable. A cell is referenced by its column and

row coordinates, and references can be absolute or relative. An absolute reference is written as $C$R (where C

is the column number and R the row number). Thus $B$7 is an absolute reference. In a formula it will always

refer to the data in cell B7 wherever that formula, or a copy of it, is placed. On the other hand, B7 is a relative

reference. It is based on the relative position of cells. Thus a formula in, say, B8 that references B7 will

reference C7 instead of B7 if it is copied to C8.

Ranges of cells can also be specied, as in C6:E12, as can entire columns (E:E) or entire rows ($3:$5). Note

that the alphabetic component of column names can be uppercase or lowercase except for columns g, l, m,

and z. (G, L, M, and Z are names reserved for graphic objects, lists, matrices, and complex numbers.) These

must be in lowercase if not preceded by $. Thus cell B1 can be referred to as B1,b1,$B$1 or $b$1 whereas M1

can only be referred to as m1, $m$1, or $M$1.

216 Chapter 10 Spreadsheet

1 2 ... 259 260 261 262 263 264 265 266 267 268 269 ... 700 701

Komentarze do niniejszej Instrukcji

Brak uwag

HP Prime Graphing Wireless Calculator Instrukcja Użytkownika Strona 264

Komentarze do niniejszej Instrukcji

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