Hp Prime Graphing Calculator Uživatelský manuál stáhnout pdf (Strana 206)

100

101

202 Spreadsheet

Copy and paste

To copy one or more cells,

select them and press

SV (Copy).

Move to the desired location

and press

SZ (Paste).

You can choose to paste

either the value, formula,

format, both value and format, or both formula and format.

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.

If you are working outside a spreadsheet, you cannot refer to a

cell by its absolute reference. Thus Spreadsheet.$A$6

produces an error message.

Note that a reference to a spreadsheet name is case-sensitive.

1 2 ... 201 202 203 204 205 206 207 208 209 210 211 ... 607 608

Komentáře k této Příručce

Žádné komentáře

Hp Prime Graphing Calculator Uživatelský manuál Strana 206

Komentáře k této Příručce

Související produkty a manuály pro PDA Hp Prime Graphing Calculator