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

100

101

If you are working outside a spreadsheet, you can refer to a cell by its absolute reference. Thus, entering

Spreadsheet.$A$6 returns the contents of cell A6 in the Spreadsheet app.

NOTE: A reference to a spreadsheet name is case sensitive.

Referencing variables

Any variable can be inserted in a cell. This includes Home variables, App variables, CAS variables and user

variables.

Variables can be referenced or entered. For example, if you have assigned 10 to P in Home view, you could

enter =P*5 in a spreadsheet cell, press and get 50. If you subsequently change the value of P,

the value in that cell automatically changes to reect the new value. This is an example of a referenced

variable.

If you just wanted the current value of P and not have the value change if P changes, just enter P and press

. This is an example of an entered variable.

Variables given values in other apps can also be referenced in a spreadsheet. The Solve app can be used to

solve equations. An example used is V

= U

+ 2AD. You could have four cells in a spreadsheet with =V, =U, =A,

and =D as formulas. As you experiment with dierent values for these variables in the Solve app, the entered

and the calculated values are copied to the spreadsheet (where further manipulation can be done).

The variables from other apps include the results of certain calculations. For example, if you have plotted a

function in the Function app and calculated the signed area between two x-values, you can reference that

value in a spreadsheet by pressing , tapping , and then selecting Function > Results >

SignedArea.

Numerous system variables are also available. For example, you could enter to

get the last answer calculated in Home view. You could also enter

to get the last answer calculated in Home view and have the value automatically updated as

new calculations are made in Home view. (Note that this works only with the Ans from Home view, not the Ans

from CAS view.)

222 Chapter 10 Spreadsheet

1 2 ... 265 266 267 268 269 270 271 272 273 274 275 ... 700 701

Komentarze do niniejszej Instrukcji

Brak uwag

HP Prime Graphing Wireless Calculator Instrukcja Użytkownika Strona 270

Komentarze do niniejszej Instrukcji

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