beautypg.com

Calculating a sum, Entering a formula – Palm Treo 700w User Manual

Page 153

background image

Using Your Treo 700w Smartphone

145

Excel Mobile

CHAPTER 7

Zoom: Sets the magnification level so that you can easily read
the worksheet.

Sheet: Lets you switch to a different worksheet.

Split: Divides the window into two scrollable areas. To move the
split bar, tap and drag the split bar. To remove the split bar, select
View > Remove Split.

Freeze Panes: Locks rows and columns so they remain visible
while you scroll. Highlight the cell at the juncture you want to
lock before you select this command. To unlock the rows or
columns, select View > Unfreeze Panes.

Toolbar: Sets whether the toolbar appears onscreen.

Status Bar: Sets whether the status bar appears onscreen.

Show: Sets whether headings and scroll bars appear onscreen.

Calculating a sum

1.

Press View

(left action key) and select Toolbar.

2.

Highlight the cell where you want to insert the sum.

3.

Select .

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 an = sign followed by any values, cell references, name
references, operators, and functions.
Example: =(B4/25)+100=Revenue-Expenses

3.

Press Enter

.

Tip

To jump to a cell or
region, press Menu
and select Edit > Go
To. Select Cell
reference or name
and enter the target
cell info or select
Current region. Select
OK.

Did You Know?

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