Brother International WP1700MDS Owners Manual - English - Page 8

Spreadsheet

Page 8 highlights

Label Input/Editing 159 Adding a New Label 159 Deleting one Column 160 Changing the Width of a Column 160 Reorganizing Your File 161 Sorting the Data 161 Selecting Records 162 Printing the Selected Data 164 Saving the Selected Data on Diskette 164 Inserting a Blank Column or Record 165 File Operation 166 Saving the Address Book File 166 Retrieving an Address Book File 166 Printing the Current Address Book File 167 Printing Labels 168 Printing a List 170 During Printing 171 Printing a File 171 Using the Function Menu 172 Spreadsheet 173 Introduction 174 What is a Spreadsheet? 174 Starting the Spreadsheet Application 175 Input/Edit Mode and Command Mode 176 Help Menus 176 The Input/Edit Mode 177 The SPREADSHEET INPUT/EDIT Screen 177 Moving Around the Screen 177 The Input Area 178 Entering and Editing Data 179 Alphanumeric Data 181 Format Marks 181 Maximum Length of Alphanumeric Data 182 Numeric Data 183 Direct Numbers 183 Formulas 184 Operators 184 Operands 184 Using Simple Formulas 185 Order of calculation of a formula 187 Maximum Length of a Formula 188 Math Functions 188 What is a Range of Cells? 189 Easy Input of a Range 189 List of Functions 190 The Command Mode 194 Bold 194 Underline 194 Absolute and Relative Addresses 195 Copying a Range of Cells 195 Copying one Cell to Many Other Cells 196 Deleting Rows and Columns 197 Inserting Blank Rows and Columns 198 Moving a Range of Cells 200 Printing a Range 201 Using the Function Menu 203 Adjusting the Width of the Columns 203 vi

  • 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

Label
Input/Editing
159
Adding
a
New
Label
159
Deleting
one
Column
160
Changing
the
Width
of
a
Column
160
Reorganizing
Your
File
161
Sorting
the
Data
161
Selecting
Records
162
Printing
the
Selected
Data
164
Saving
the
Selected
Data
on
Diskette
164
Inserting
a
Blank
Column
or
Record
165
File
Operation
166
Saving
the
Address
Book
File
166
Retrieving
an
Address
Book
File
166
Printing
the
Current
Address
Book
File
167
Printing
Labels
168
Printing
a
List
170
During
Printing
171
Printing
a
File
171
Using
the
Function
Menu
172
Spreadsheet
Introduction
174
What
is
a
Spreadsheet?
174
Starting
the
Spreadsheet
Application
175
Input/Edit
Mode
and
Command
Mode
176
Help
Menus
176
The
Input/Edit
Mode
177
The
SPREADSHEET
INPUT/EDIT
Screen
177
Moving
Around
the
Screen
177
The
Input
Area
178
Entering
and
Editing
Data
179
Alphanumeric
Data
181
Format
Marks
181
Maximum
Length
of
Alphanumeric
Data
182
Numeric
Data
183
Direct
Numbers
183
Formulas
184
Operators
184
Operands
184
Using
Simple
Formulas
185
Order
of
calculation
of
a
formula
187
Maximum
Length
of
a
Formula
188
Math
Functions
188
What
is
a
Range
of
Cells?
189
Easy
Input
of
a
Range
189
List
of
Functions
190
The
Command
Mode
194
Bold
194
Underline
194
Absolute
and
Relative
Addresses
195
Copying
a
Range
of
Cells
195
Copying
one
Cell
to
Many
Other
Cells
196
Deleting
Rows
and
Columns
197
Inserting
Blank
Rows
and
Columns
198
Moving
a
Range
of
Cells
200
Printing
a
Range
201
Using
the
Function
Menu
203
Adjusting
the
Width
of
the
Columns
203
173
vi