Brother International WP7550JPLUS Owner's Manual - English - Page 115

RETURN., CURSOR, SPACE, RETURN, Spreadsheet

Page 115 highlights

2. Move the cursor to the column on which the select condition is to be applied and press RETURN. The SELECT window appears:

  • 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

2.
Move
the
cursor
to
the
column
on
which
the
select
condition
is
to
be
applied
and
press
RETURN.
The
SELECT
window
appears:
<<SELEDT»
CONDITION:
EMPONNIEn
SQUALID:
Press
SPACE
to
change
setting
and
press
RETURN_
3.
Use
CURSOR
UP
and
CURSOR
DOWN
to
move
the
cursor
to
the
desired
setting.
Use
SPACE
BAR
to
select
the
kind
of
CONDITION.
Type
the
condition
on
the
lower
line
of
the
window.
Press
RETURN
when
finished.
The
different
kinds
of
conditions
are:
EQUAL,
NOT
EQUAL,
LESS,
GREATER,
BETWEEN,
NOT
BETWEEN.
These
conditions
all
apply
to
numeric
data,
except
EQUAL
and
NOT
EQUAL
which
can
be
set
for
alphanumeric
data
(WORD).
With
EQUAL(WORD)
and
NOT
EQUAL(WORD),
the
machine
checks
for
an
exact
matching
of
the
first
characters
of
the
cells.
If
you
entered
EQUAL
TO:BA,
BANANA
and
BAY
will
be
selected
because
these
words
start
with
BA;
banana,
B,
B.A.,
and
1BANANA
will
not
be
selected.
The
selected
data
appears
in
the
SELECTED
DATA
window.
Example:
Suppose
you
have
a
list
of
salespersons
with
each
row
containing
the
last
name,
first
name,
and
sales
results.
if
you
try
this
example.
remember
to
make
sure
that
the
numbers
in
column
C
are
not
alphanumeric
characters.
Alphanumeric
characters
are
always
preceded
with
a
mark.
For
more
information,
see
Format
Marks.
7
H2:
'LAST
NAME
EIMEIFIRST
NAME
SALES
RESULTS
rsh
Henry
$12,345
Anderson
John
$10,539
Bennet
William
$34,129
Higgins
Ruth
$22,410
Carter
➢avid
$18,300
Higgins
Joyce
$15,885
Fox
Terry
$20,702
If
you
want
to
extract
a
list
of
the
salespersons
whose
sales
result
is
lower
than
$20,000,
you
must
specify
column
C
as
the
select
column
in
step
2
above,
then
select
LESS
in
the
SELECT
window,
and
enter
20000
at
the
back
of
Less.
<<SELECT>>
CONDITION:
LESS
LESS
THAN:
20000
Type
number
and
press
RETURN.
Spreadsheet
107