Palm 700wx User Guide - Page 178

Calculating a sum, Entering a formula, Inserting a function, B4/25+100=Revenue-Expenses

Page 178 highlights

8 YOUR MICROSOFT OFFICE TOOLS CHAPTER Status Bar: Sets whether the status bar appears onscreen. Show: Sets whether headings and scroll bars appear onscreen. 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. 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 . 2 Enter an equals sign ( = )followed by any values, cell references, name references, operators, and functions. Example: =(B4/25)+100=Revenue-Expenses 3 Press Enter . Inserting a function 1 Open the workbook where you want to insert the function. 2 Press Menu (right action key) and select Insert > Function. 3 Select the Category list, and then select the type of function you want to insert. Entering a formula 1 Highlight the cell where you want to enter the formula. 4 Select the Function list, and then select the specific function you want to insert. 170 E X C E L M O B I L E

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290

YOUR MICROSOFT OFFICE TOOLS
EXCEL MOBILE
170
8
CHAPTER
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 equals sign ( = )followed by any
values, cell references, name
references, operators, and functions.
Example:
=(B4/25)+100=Revenue-Expenses
3
Press
Enter
.
Inserting a function
1
Open the workbook where you want to
insert the function.
2
Press
Menu
(right action key) 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.
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.