Palm TREOPROBLKSPT manual Calculating a Sum, Entering a Formula, 296

Did you know?

You can switch worksheets by selecting the sheet list at the bottom of the screen.

Calculating a Sum

1.Press View (left softkey) and select Toolbar.

2.Highlight the cell where you want to insert the sum.

3.Select Sum .

4.Tap and drag the stylus across the cells you want to add.

5.Press Return .

Entering a Formula

1.Highlight the cell where you want to enter the formula.

2.Enter an equal (=) sign followed by any values, cell references, name references, operators, and functions. Example: =(B4/25)+100=Revenue-Expenses

3.Press Return .

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.Navigate to the cell you want to refer to in the formula. To refer to a range, tap and drag the stylus over the cells you want to include in the range.

4.Finish entering the formula and press OK .

296 Section 5B: Increasing Your Productivity