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

100

101

Copy and paste

To copy one or more cells, select them and press .

Move to the desired location and press .

You can choose to paste either the value, formula, format, both value and format, or both formula and

format.

You can also copy data from the Spreadsheet app and paste it into the Statistics apps, the List Editor, or the

Matrix Editor. Or, you can copy from one of those apps and paste into the Spreadsheet app. In these cases,

only the values are pasted.

Using the CHOOSE command

The CHOOSE command denes a cell as a drop-down box in the spreadsheet. The name of a cell is used as the

variable name.

For example, if you enter the command =CHOOSE($B$1, “Favorite Color”, {“Red”,

“Green”, “Yellow”, “Blue”}) in cell A1, cell A1 becomes a drop-down box. Tap this cell to open a

list titled Favorite Color with entries Red, Green, Yellow, and Blue. If you tap Blue, then cell B1 contains the

value 4 because Blue is the fourth entry. If you enter 2 in cell B1, the value selected in cell A1 changes to

Green, because Green is the second entry.

External references

You can refer to data in a spreadsheet from outside the Spreadsheet app by using the reference

SpreadsheetName.CR. For example, in Home view you can refer to cell A6 in the built-in spreadsheet by

entering Spreadsheet.A6. Thus the formula 6*Spreadsheet.A6 would multiply whatever value is currently

in cell A6 in the built-in app by 6.

If you have created a customized spreadsheet called, say, Savings, you simply refer to it by its name, as in

5*Savings.A6.

An external reference can also be to a named cell, as in 5*Savings.TOTAL.

In the same way, you can also enter references to spreadsheet cells in the CAS.

Using the CHOOSE command 221

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

Komentarze do niniejszej Instrukcji

Brak uwag

HP Prime Graphing Wireless Calculator Instrukcja Użytkownika Strona 269

Komentarze do niniejszej Instrukcji

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