Brother International PDP350CJ Owner's Manual - English - Page 158

Working with Values and Labels, Entering V

Page 158 highlights

Working with Values and Labels You build a spreadsheet by entering values, labels, and formulas. Values. Values are numbersĊfor example, sales figures for the past four quarters. Labels. Labels are the titles or descriptive text you enter to describe the contents of rows and columnsĊ for example, First Quarter," Second Quarter," Third Quarter," and Fourth Quarter." Formulas. Formulas describe the calculations you want to performĊ for example, to total the sales for all four quarters. This section explains how to enter values and labels in a spreadsheet. For more information about formulas, see Working with Formulas" on page 149. Entering Values and Labels The procedure for entering values and labels is the same. However, some special considerations apply to each; for more information, see the notes following the procedure. If you want to enter dates in a spreadsheet, see "Entering and Changing Dates" on page 147. "To enter values or labels: 1. Select the cell in which you want the entry to appear. 2. Type the entry (numbers or words) that you want to appear in the cell. If you are using the numeric keypad to enter numbers, be sure the NUM LOCK key is on. To turn on NUM, press the NUM LOCK key at the bottom right of the keypad or click on the NUM button in the lower left corner of the screen. If you make a typing mistake, press the BACKSPACE key to erase characters to the left of the insertion pointer in the Edit Area. 3. Press one of the following keys to complete the entry: S ENTER. Moves the highlighting down one cell. S SHIFT + ENTER. Moves the highlighting up one cell. S TAB. Moves the highlighting to the right one cell. S SHIFT + TAB. Moves the highlighting to the left one cell. S LEFT and RIGHT ARROW. Move the highlighting one cell in the direction of the arrow. S UP and DOWN ARROW. Move the highlighting one cell in the direction of the arrow. S CODE + ENTER. Keeps the highlighting in the current cell; the active cell does not change. You can also complete your entry by clicking on Enter in the Edit Bar. In this case, the highlighting does not move. Spreadsheet 144

  • 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
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 410
  • 411
  • 412
  • 413
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420
  • 421
  • 422
  • 423
  • 424
  • 425
  • 426
  • 427
  • 428
  • 429
  • 430
  • 431
  • 432
  • 433
  • 434
  • 435
  • 436
  • 437
  • 438
  • 439
  • 440

Spreadsheet
144
Working with Values and Labels
You build a spreadsheet by entering
values
,
labels
, and
formulas
.
Values.
Values are numbersĊfor example, sales figures for the past four
quarters.
Labels.
Labels are the titles or descriptive text you enter to describe the
contents of rows and columnsĊ for example, ±First Quarter," ±Second
Quarter," ±Third Quarter," and ±Fourth Quarter."
Formulas.
Formulas describe the calculations you want to performĊ for
example, to total the sales for all four quarters.
This section explains how to enter values and labels in a spreadsheet. For
more information about formulas, see ±Working with Formulas" on page
149.
Entering V
alues and Labels
"
To enter values or labels:
1. Select the cell in which you want the entry to appear.
2. Type the entry (numbers or words) that you want to appear in the
cell. If you are using the numeric keypad to enter numbers, be sure
the
NUM LOCK
key is on. To turn on NUM, press the
NUM LOCK
key at the bottom right of the keypad or click on the NUM button in
the lower left corner of the screen. If you make a typing mistake,
press the
BACKSPACE
key to erase characters to the left of the
insertion pointer in the Edit Area.
3. Press one of the following keys to complete the entry:
S
ENTER.
Moves the highlighting down one cell.
S
SHIFT + ENTER.
Moves the highlighting up one cell.
S
TAB.
Moves the highlighting to the right one cell.
S
SHIFT + TAB.
Moves the highlighting to the left one cell.
S
LEFT
and
RIGHT ARROW.
Move the highlighting one cell in the
direction of the arrow.
S
UP
and
DOWN ARROW.
Move the highlighting one cell in the
direction of the arrow.
S
CODE + ENTER.
Keeps the highlighting in the current cell; the
active cell does not change.
You can also complete your entry by clicking on Enter in the Edit Bar. In
this case, the highlighting does not move.
The
procedure for entering
values and labels is the same.
However
, some special
considerations apply to each;
for more information, see the
notes following the procedure.
If you want to enter dates in a
spreadsheet, see “Entering and
Changing Dates” on page
147.