
Cell naming
Cells, rows, and columns can be named. The name can then be used in a formula. A named cell is given a blue
border.
Method 1
To name an empty cell, row, or column, go the cell, row header, or column header, enter a name and tap
.
Method 2
To name a cell, row, or column—whether it is empty or not:
1. Select the cell, row, or column.
2.
Tap and select Name.
3.
Enter a name and tap .
Using names in calculations
The name you give a cell, row, or column can be used in a formula. For example, if you name a cell TOTAL, you
could enter in another cell the formula =TOTAL*1.1.
The following is a more complex example involving the naming of an entire column.
1. Select cell A (that is the header cell for column A).
2.
Enter COST and tap .
3. Select cell B (that is the header cell for column B).
4.
Enter COST*0.33, and then tap .
5. Enter some values in column A and observe the calculated results in column B.
Entering content
You can enter content directly in the spreadsheet or import data from a statistics app.
Basic operations 217
Komentarze do niniejszej Instrukcji