Palm Treo 750 User's Guide download pdf (Page 210)

YOUR MICROSOFT OFFICE AND OTHER DOCUMENT TOOLS

EXCEL MOBILE

202

10

CHAPTER

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)

1 2 ... 205 206 207 208 209 210 211 212 213 214 215 ... 349 350

Comments to this Manuals

No comments