Output of file : SELFTST2.WK1 contained in archive : 123TESTS.ZIP
0/ÿÿ q H     d GDATEeiÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0Dÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ\$%ò&ò'((
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqqÿ'LOTUS 123 SELF TEST #2ÿ' by Steve BruhnMÿ' 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ðÿ¿DGood !;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½Á@
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 inFÿ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 displaysHÿQ'10% if the sales are less than \$200,000, and 13% if the sales are9ÿR'greater than \$200,000. Don't forget cell formats.
ÿT^REGION ÿT^SALESÿT^COMMISIONÿU\=ÿU\=ÿU\= ÿV'EAST
V(jA ÿW'WEST
W1A ÿX'SOUTH
X ¾ A ÿY'NORTH
Yþ@0ÿ[atð!û¿þ¿Pq=
×£pÝ?Good !;3ÿ[ÿ\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-ÿ\\-Iÿ^' Every office has some lightweight that enters dates as labelsLÿ_'instead of numbers. Change the dates to numbers using the @DATEVALUENÿ`'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" -AGood !;3ÿÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-

3 Responses to “Category : Lotus and other SpreadsheetsArchive   : 123TESTS.ZIPFilename : SELFTST2.WK1”

1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/