Brother International PN-5700DS Owner's Manual - English - Page 145

Description, Templates

Page 145 highlights

The Templates The Spreadsheet Templates are pre-formatted files to be used with the Spreadsheet mode. These files allow for easy creation of most standard spreadsheets. They are stored on the Template disk that comes with your machine. The Templates are write-protected, which means that they cannot be erased and that they will always be available on the Template disk in their original form. For all templates, just remember, you enter the data in the blank cells only. Never enter data into the cells that contain a formula. Listed below are the templates that we have already designed for your use. These files come with an easy-to-use format. All you need to do is enter your data. The cells which are supposed to display a result already contain the appropriate formulas and format. Never enter data in the cells that already contain a formula. After you have completed your work on the template spreadsheet, you may give your template a file name and save it to a data disk. Each time you recall a template from the Template disk, a new blank file appears. In order to recall a template that you previously worked with, simply recall it from the data disk by the file name you assigned. Description of the Templates INTRO - This template is actually an overview file that contains a reading introduction to the Spreadsheet. This template discusses some of the features and capabilities of the Spreadsheet Program. TELEPHONE AND ADDRESS DIRECTORY - This template allows you to keep an organized listing of names and addresses. With the sort capability, you are able to rearrange this file alphabetically after each addition or edit. CHECKBOOK - This Checkbook template resembles the ledgers that you receive from your bank. It calculates the balance after you input your deposits and withdrawals. After entering your deposits and withdrawals, select RECALC from the function menu to process the balance column. If you later make changes or additions to the data you entered in the checkbook, simply use the RECALC function to determine the new balance. MONTHLY BUDGETING - This template helps you keep your personal finances in order. It outlines your monthly expenses for you. Once your expenses are itemized, use the RECALC function to determine your budget results. Later, if you make changes or additions to the budget, simply use the RECALC function to determine the new totals. 131 SPREADSHEET

  • 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

The
Templates
The
Spreadsheet
Templates
are
pre
-formatted
files
to
be
used
with
the
Spread-
sheet
mode.
These
files
allow
for
easy
creation
of
most
standard
spreadsheets.
They
are
stored
on
the
Template
disk
that
comes
with
your
machine.
The
Tem-
plates
are
write
-protected,
which
means
that
they
cannot
be
erased
and
that
they
will
always
be
available
on
the
Template
disk
in
their
original
form.
For
all
templates,
just
remember,
you
enter
the
data
in
the
blank
cells
only.
Never
enter
data
into
the
cells
that
contain
a
formula.
Listed
below
are
the
templates
that
we
have
already
designed
for
your
use.
These
files
come
with
an
easy
-to
-use
format.
All
you
need
to
do
is
enter
your
data.
The
cells
which
are
supposed
to
display
a
result
already
contain
the
appropriate
formulas
and
format.
Never
enter
data
in
the
cells
that
already
con-
tain
a
formula.
After
you
have
completed
your
work
on
the
template
spreadsheet,
you
may
give
your
template
a
file
name
and
save
it
to
a
data
disk.
Each
time
you
recall
a
tem-
plate
from
the
Template
disk,
a
new
blank
file
appears.
In
order
to
recall
a
tem-
plate
that
you
previously
worked
with,
simply
recall
it
from
the
data
disk
by
the
file
name
you
assigned.
Description
of
the
Templates
INTRO
-
This
template
is
actually
an
overview
file
that
contains
a
reading
intro-
duction
to
the
Spreadsheet.
This
template
discusses
some
of
the
features
and
capabilities
of
the
Spreadsheet
Program.
TELEPHONE
AND
ADDRESS
DIRECTORY
-
This
template
allows
you
to
keep
an
organized
listing
of
names
and
addresses.
With
the
sort
capability,
you
are
able
to
rearrange
this file
alphabetically
after
each
addition
or
edit.
CHECKBOOK
-
This
Checkbook
template
resembles
the
ledgers
that
you
receive
from
your
bank.
It
calculates
the
balance
after
you
input
your
deposits
and
withdrawals.
After
entering
your
deposits
and
withdrawals,
select
RECALC
from
the
function
menu
to
process
the
balance
column.
If
you
later
make
changes
or
additions
to
the
data
you
entered
in
the
checkbook,
simply
use
the
RECALC
function
to
determine
the
new
balance.
MONTHLY
BUDGETING
-
This
template
helps
you
keep
your
personal
finances
in
order.
It
outlines
your
monthly
expenses
for
you.
Once
your
expenses
are
itemized,
use
the
RECALC
function
to
determine
your
budget
results.
Later,
if
you
make
changes
or
additions
to
the
budget,
simply
use
the
RECALC
function
to
determine
the
new
totals.
SPREADSHEET
131