Atari Portfolio - Page 80

This is
the ltst
payee.
Reposition
the cursor to
cell 84 and
enter anolher
payee
name.
Conlinue
enleting names
unlil
cells 83 th.ough
B6 conlain
payee
names.
(Make
up
any
names
you
wani...
be crealive{)
4. Position
ll"re cursor in cell
D3. Type
ihe iollowing:
-200
lEnrorl
This is the amounl
of the chbck
to the IBS.
Reposition the
cursor
lo cell D4 and
lype
-100
tEnlsrt.
Enter
-100
in cell
D5, and
-50
in cell D6.
These are lhe
amouhls o,
the
checks
lo the other
payees
you
invenled
lor step
3.
tUse
the
mrnus sign
on lhe hey to lhe
righl ol the
zero hey.)
5- Posilion
lhe cursor
in cell C7. Type
lhe iollowing:
400
IEnterI
This is lhe
amount ol
your paycheck
Just in
time lo keep
those
checks lrom
bouncingl
6. Use lhe Save
As command in
the Files menu to save vour
Worksheet as
CHECKING.WKS.
Leave CHECKTNG.WKS
displayed and conljnue
lo lhe nexl
seclion.
,
Entering
Formulas
Now
you
need lo lei the
spreadsheet know
whal calculaiions
-
you
want
perlormed
on lhese
nLtmbers. You
do this by linking
lwo cells togelher,
enlering
lhe operand, and
delining a desti
.
nation
cell lor the resull
ol the operation
1. Posilion lhe cursor
in cell E3. This is
the iarget cell lor
lhe
Iirst operalion
(subtracting
lhe
amount ol ch;ck
number
'
101
($200.00
ro lhe lFlS) Irom
your
account batance
The
Iirsl
operand is an addllton
sign. because
you
wanl
ro add
,
lhe starling balance.
Type lhe lollowing:
.
+ (Don'l
type
tEnterM