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.

 

 

 

 

 

 

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)

 

 

 

 

 

Inserting a Function

1.Highlight the cell where you want to insert the function.

2.Press Menu (right softkey) and select Insert > Function.

3.Select the Category list, and then select the type of function you want to insert.

4.Select the Function list, and then select the specific function you want to insert.

5.Select OK.

Did you know? To enter symbols that are not on the keyboard, such as the = sign, press Alt and select the symbol from the list.

Productivity

Section 5B: Increasing Your Productivity

297

Page 297
Image 297
Palm TREOPROBLKSPT manual Inserting a Function, Increasing Your Productivity 297