Brother International WP1700MDS Owners Manual - English - Page 219

Organizing

Page 219 highlights

Organizing Your Data It is important to realize that you can create files of textual information as well as numbers and formulas. The next example will illustrate this. Sorting a Range When you update a file of names, addresses and phone numbers, you usually add data at the end of the file. To facilitate later reference, however, you need some logical organization. Alphabetical order is commonly used. The sorting fea- ture shown here will save you time and effort in the organization of your data. To prepare: 1. Enter the data shown in the illustration. Marsh r„' enry Ander on John Jackson Howard Bennet William C Higgins Ruth Carter David 7 Bender William ;? Higgins Joyce 9 Fox Terry 10 Lee Kevin Mlammiurg Oh Denver CO Stanford CA Westfield NJ Cambridge MA Dallas TX Freeport VT Atlanta GA Fremont CA Bedford TX 46,542 82222 56904 28854 11000 76021 66622 30341 94537 76021 91TrH,lo 2. If you wish, make several copies of the data (using the copy function - + ) so that you will be able to try several different types of sorts. You are now ready to go on with the first example: 1. Position the cursor on Al and press to display the function menu. COLUMN FORMAT RECALC CLEAR CONVERT 2. Select SORT and press . This menu will appear: SOW SELECT SORT & SELECT 3. Select SORT and press ME. This message will appear: Mark range to be sorted. Press RETURN when done. We are going to rearrange the data in alphabetical order according to the last names (column A). It is important that you mark all the columns so that all data will move together with the names. 209

  • 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

Organizing
Your
Data
It
is
important
to
realize
that
you
can
create
files
of
textual
information
as
well
as
numbers
and
formulas.
The
next
example
will
illustrate
this.
Sorting
a
Range
When
you
update
a
file
of
names,
addresses
and
phone
numbers,
you
usually
add
data
at
the
end
of
the
file.
To
facilitate
later
reference,
however,
you
need
some
logical
organization.
Alphabetical
order
is
commonly
used.
The
sorting
fea-
ture
shown
here
will
save
you
time
and
effort
in
the
organization
of
your
data.
To
prepare:
1.
Enter
the
data
shown
in
the
illustration.
Marsh
9
1TrH,lo
r„'
enry
Mlammiurg
Oh
46,542
Ander
on
John
Denver
CO
82222
Jackson
Howard
Stanford
CA
56904
Bennet
William
Westfield
NJ
28854
C
Higgins
Ruth
Cambridge
MA
11000
Carter
David
Dallas
TX
76021
7
Bender William
Freeport
VT
66622
;?
Higgins
Joyce
Atlanta
GA
30341
9
Fox
Terry
Fremont
CA
94537
10
Lee
Kevin
Bedford
TX
76021
2.
If
you
wish,
make
several
copies
of
the
data
(using
the
copy
function
—
+
)
so
that
you
will
be
able
to
try
several
different
types
of
sorts.
You
are
now
ready
to
go
on
with
the
first
example:
1.
Position
the
cursor
on
Al
and
press
to
display
the
function
menu.
COLUMN
FORMAT
RECALC
CLEAR
CONVERT
2.
Select
SORT
and
press
.
This
menu
will
appear:
SOW
SELECT
SORT
&
SELECT
3.
Select
SORT
and
press
ME.
This
message
will
appear:
Mark
range
to
be
sorted.
Press
RETURN
when
done.
We
are
going
to
rearrange
the
data
in
alphabetical
order
according
to
the
last
names
(column
A).
It
is
important
that
you
mark
all
the
columns
so
that
all
data
will
move
together
with
the
names.
209