Palm TREO750, Руководство пользователя

Страница: 210 / 350

Y O U R M I C R O S O F T O F F I C E A N D O T H E R D O C U M E N T T O O L S
E X C E L M O B I L E 202
10
CH
AP
T
E
R
4 Tap and drag the stylus across the cells
you want to add.
5 Press Enter .
Entering a formula
1 Highlight the cell where you want to
enter the formula.
2 Enter equals sign ( = ) followed by any
values, cell references, name
references, operators, and functions.
Examples:
•
=(B4/25)+100
•
=Revenue-Expenses
3 Press Enter .
Referring to a cell or range in a formula
1 Open the workbook where you want to
refer to a cell or range in a formula.
2 Begin entering a formula in a cell.
3 Select the cell, or select an entire range
to set the reference.
4 Finish entering the formula and press
OK .
Inserting a function
1 Open the workbook where you want to
insert the function.
2 Press Menu (right action key)
and select Insert > Function .
TIP
For simple calculations, use the Calculator
(see Calculator).
TIP
To insert a symbol, place the cursor where
you want the symbol. Press Menu and select
Insert > Symbol . Highlight the symbol you
want to insert, and select Insert .
TIP
To refer to a cell from another worksheet
in your formula, enter the worksheet name
followed by an exclamation point (!) and the
cell, range, or name reference.
Example: =Sheet1!Earnings
TIP
To create a 3-D reference in your formula,
specify two or more sheets in a workbook;
use a colon between the first and last
worksheet names.
Example: =SUM(Sheet2:Sheet6!$A$2:$C$5)