Category : Lotus and other Spreadsheets
Archive   : 123TESTS.ZIP
Filename : SELFTST2.WK1

˜–0˜
˜˜˜˜˜˜˜/


ÿ


ÿ q H 
   d GDATEe
i
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0

Dÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
%ò&ò'((
LB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
ÿ'LOTUS 123 SELF TEST #2ÿ
' by Steve BruhnMÿ' This will test your skill in using certain features of LOTUS 123.Kÿ' Follow the instructions for each section, then move to the nextÿ'section.Bÿ' When you finish, have the instructor check it for you.ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\->ÿ' Write a formula to add the numbers in each column.
ÿ

ÿ


ÿ

ÿ

ÿ
ÿ
ÿ
ÿ
ÿ 
ÿ 
ÿ 
ÿ 
ÿ

ÿ

ÿ

ÿ

ÿ
ÿ
ÿ
ÿ!
ÿ

ÿ
ÿ
ÿ"
ÿ
ÿ
ÿ
ÿ#
ÿ
ÿ
ÿ
ÿ$ÿ\=ÿ\=ÿ\=ÿ\=
ÿ
"TOTALS$ÿðtð
€ÿ¿DGood !;3ÿ$ÿítð
€ÿ¿„Good !;3ÿ$ÿêtð
€ÿ¿ÄGood !;3ÿ$ÿçtð
€ÿ¿
Good !;3ÿÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-Hÿ' Use the @MAX and @MIN formulas to find the highest and lowestÿ'numbers in this section.
x•@
ÀÐ/3!@
¨8µ¬@
p®ÔQ@
°
ÔE@
À´G@
è(N@
Ø¼"@
ÌÍd @
Ô«?
”ð¤›"@
ð˜Sô@
`çŠäö?
€A^Zò?
; ¯@
0ê›U@
0À,5@
@?€8
@
.Ý@

IWÊa7#@
XŽÅD@
¿å˺è4#@
ˆ;Ñ?@
@STý?
8½Á@
 6©Ô@
ORÞ@
‚†õ@
ðޗ¡@
€ä@
 ¸î~
@
 ¨«¸®"@
 pSr2@
 _™/þ?
 è1Ã@
!@Rêþõ?
!à¯AÊó?
!óT@
!ØC"@
!ø±À1#@
"8¶ª&@
"ӓœcI#@
"@ƒpí?
"˜
êe"@
"0îeë @ÿ$'Highest=&ÿ$Ätð
ÿ¿€
€€Good !;3ÿ$
ö$ӓœcI#@ÿ%' Lowest=&ÿ%Àtð
ÿ¿€
€€Good !;3ÿ%
ö%Ô«?ÿ&\-ÿ
&\-ÿ&\-ÿ&\-ÿ&\-ÿ&\-ÿ&\-ÿ&\-/ÿ(' The format for the @PMT formula is:ÿ
)'@PMT(prin,rate,term)?ÿ*' What is the MONTHLY payment for the following loan? ÿ,"prin=
 
,Û
A ÿ-"rate=
²
-¸…ëQ¸¾?ÿ-' per Year ÿ."term=
ÿ
.
ÿ.' Years(ÿ0' Write the @PMT formula here:  0
ö0z½kÇì¢@&ÿ1«tð
€ÿ¿

€ÿ¿Good !;3ÿ1ÿ2\-ÿ
2\-ÿ2\-ÿ2\-ÿ2\-ÿ2\-ÿ2\-ÿ2\-Iÿ4' Enter a down payment of $25,000 below. Edit the @PMT formula:ÿ5'to reduce the principal by the down payment amount. ÿ7"prin=
 
7@•A ÿ8"down= ÿ9"rate=
²
9¸…ëQ¸¾?ÿ9' per Year ÿ:"term=
ÿ
:
ÿ:' Yearsÿ<'Monthly payments=" <*„I’ ԟ@
ÿ¿û¿{®Gáz„?ð8
ö<šp…ó†›@&ÿ=•tð
€ÿ¿
€ÿ¿Good !;3ÿ=ÿ>\-ÿ
>\-ÿ>\-ÿ>\-ÿ>\-ÿ>\-ÿ>\-ÿ>\-Hÿ@' Use absolute cell references to write ONE formula to fill inFÿA'this multiplication table. (Hint: the formulas already in the IÿB'table will not work). Then copy the formula to fill in the table.
ÿ
D

ÿD
ÿD
ÿD
ÿD
ÿD
ÿDÿ
E\=ÿE\=ÿE\=ÿE\=ÿE\=ÿE\=ÿE\=
ÿF
ÿ
Fð?
ÿ¿€
€þ¿
ÿGÿG@
þ¿€
€ý¿
ÿH
ÿI
ÿJÿJ9@
û¿€
€ú¿
ÿKÿKB@
ú¿€
€ù¿
ÿLÿN\-ÿ
N\-ÿN\-ÿN\-ÿN\-ÿN\-ÿN\-ÿN\-GÿP' Write an @IF formula in the COMMISSION column that displaysHÿQ'10% if the sales are less than $200,000, and 13% if the sales are9ÿR'greater than $200,000. Don't forget cell formats.
ÿT^REGION ÿ
T^SALESÿT^COMMISIONÿU\=ÿ
U\=ÿU\=ÿV'EAST
 
V(jAÿW'WEST
 
W€1A ÿX'SOUTH
 
X ¾ A ÿY'NORTH
 
Y€„þ@0ÿ[atð!€û¿€þ¿P
q=
×£pÝ?Good !;3ÿ[ÿ\\-ÿ
\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-Iÿ^' Every office has some lightweight that enters dates as labelsLÿ_'instead of numbers. Change the dates to numbers using the @DATEVALUENÿ`'formula. Then write a formula that finds the number of days differenceÿa'between the dates.ÿc' Labelsÿc'Write formulas here.
ÿd^ONE
ÿ
d^TWO
ÿd^ONE
ÿd^TWOÿd'DIFFERENCEÿe'06/07/87ÿ
e'07/09/87 ñe ñeÿf'12/01/87ÿ
f'02/28/88 ñf ñfÿg'02/08/88ÿ
g'04/12/88 ñg ñgÿh'12/05/88ÿ
h'12/06/88 ñh ñhÿi'07/01/88ÿ
i'11/09/88 ñi ñi*ÿkBtð€ú¿€þ¿P
=
Good !;3ÿkÿl\-ÿ
l\-ÿl\-ÿl\-ÿl\-ÿl\-ÿl\-ÿl\-Hÿn' Use @Formulas to find the numbers indicated at the bottom of>ÿo'the list. Use F1 (Help) if you don't know the formula.
ÿq;h4T@
ÿr|J@
ÿsp…šø@
ÿtЊ+œ4@
ÿuʃQdJ@
ÿvtõ‚ÙF@
ÿw†Ö¥hB@
ÿxÐ×ÛyQ@ÿz'The highest number :&ÿz.t ð
ÿ¿€
€€Good !;3ÿz
öz;h4T@ÿ{'The lowest number :&ÿ{)t
ð
ÿ¿€
€€Good !;3ÿ{
ö{p…šø@ÿ|'The average :&ÿ|$tð
ÿ¿€
€€Good !;3ÿ|
ö|5i¹F@ÿ}'The sum :&ÿ}tð
ÿ¿€
€€Good !;3ÿ}
ö}5i¹v@ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-=ÿ' Find and correct the errors in the section below: ÿƒ"DATE:ÿ
ƒð 
W6 ÿƒ' (Should be Dec 1, 1987)
ÿ
…ÿ
†' 6
ÿ
‡
ÿ
ˆÿ
‰\-
ÿŠ"TOTAL:'ÿ
Š4@
€û¿
۟€ý¿
€þ¿ ÿŒ\-ÿ
Œ\-ÿŒ\-ÿŒ\-ÿŒ\-ÿŒ\-ÿŒ\-ÿŒ\-CÿŽ' Add 10% to each salary that has sales of over $100,000.ÿ^Name ÿ
^Sales
ÿ^Salaryÿ^Salary Plus Commisionÿ‘'Koppell
 
‘Lý@
 ‘y ÿ’'Meese
 
’€+ø@
 ’}ÿ“'Dole
 
“.ó@
 “`mÿ”'Dern
 
”ð)A
 ”`mÿ•'Lorenzo
 
•8c
 •À]1ÿ—ýsð"€ù¿€ÿ¿P
" -AGood !;3ÿ—ÿ˜\-ÿ
˜\-ÿ˜\-ÿ˜\-ÿ˜\-ÿ˜\-ÿ˜\-ÿ˜\-