Output of file : SELFTST3.WK1 contained in archive : 123TESTS.ZIP
ÿBNNNNNNNN ÿÿ/ÿÿ q H     d GDATEÿÿÿÿG\0ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0@ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ\$ÿ%ò&ò'((
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqqÿ'LOTUS 123 SELF TEST #3 ÿ'\0 ÿ'/wgpeÿ' 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.ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-3ÿ' Erase the numbers in the section below:
ÿ
@
ÿ
@
ÿ
@
ÿ
@
ÿ

ÿ @
ÿ 
ÿ "@
ÿ @
ÿ @
ÿ ð?
ÿ @
ÿ @
ÿ @
ÿ "@
ÿ
@
ÿ
@
ÿ
@
ÿ
"@
ÿ
"@ õ õ õ õ*ÿåt ðû¿þ¿PGood !;3ÿÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-Nÿ' Find the error(s) in the section below. Press F9 (CALC) and study(ÿ'the results of the @SUM formulas.
ÿ@
ÿP@
ÿ"@
ÿG@
ÿ?@
ÿA@
ÿQ@
ÿJ@
ÿH@
ÿ@
ÿÀU@
ÿM@
ÿV@
ÿ0@
ÿG@
ÿK@
ÿ"@
ÿ@X@
ÿW@
ÿD@
ÿA@ÿ\=ÿ\=ÿ\=
ÿ'TOTALSÿ©@ ø¿Pÿ<¥@ ø¿Pÿ§@ ø¿Pÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-Cÿ!' Try to insert two rows in this section. Find the error<ÿ"'in the spreadsheet that prevents you from doing this.
ÿ\$
ÿ\$
ÿ\$
ÿ\$
ÿ%
ÿ%
ÿ%
ÿ%
ÿ&
ÿ&
ÿ&
ÿ&ÿ''Insert two rows==>
ÿ'
ÿ'
ÿ'
ÿ'
ÿ(
ÿ(
ÿ(
ÿ(
ÿ)
ÿ)
ÿ)
ÿ)ÿ+\-ÿ+\-ÿ+\-ÿ+\-ÿ+\-ÿ+\-ÿ+\-ÿ+\->ÿ-' Fix the section below so the totals are displayed.
ñ0@
ñ0P@
ñ0"@
ÿ1G@
ÿ1?@
ÿ1A@
ÿ2Q@
ÿ2J@
ÿ2H@
ÿ3@
ÿ3ÀU@
ÿ3M@
ÿ4V@
ÿ40@
ÿ4G@
ÿ5K@
ÿ5"@
ÿ5@X@ÿ6\=ÿ6\=ÿ6\=
ÿ7'TOTALSõ7p@ ù¿þ¿Põ7`p@ ù¿þ¿Põ7`r@ ù¿þ¿Pÿ9\-ÿ9\-ÿ9\-ÿ9\-ÿ9\-ÿ9\-ÿ9\-ÿ9\-Dÿ;' Write an @VLOOKUP formula to lookup and display the Part2ÿ<'description and price for each part number..ÿ>'Write the formulas under Part and Priceÿ>'This is the lookup table
ÿ?"Part # ÿ?"Part ÿ?"Price
ÿ?"Part # ÿ?"Part ÿ?"Price
ÿ@d
ÿ@d ÿ@'Bolt
¢@Ð?
ÿAi
ÿAe
ÿA'Cap
¢AÉ?
ÿBl
ÿBf
ÿB'Washer
¢B¹?
ÿCg ÿC'Screw
¢C333333Ã?
ÿDh
ÿD'Lid
¢Dà?
ÿEi
¢E
ÿFj ÿF'Plug
¢F333333ÿ?
ÿGk ÿG'Tool
¢Gfffffæ!@
ÿHl ÿH'Tape
¢H@
ÿIm ÿI'Lock
¢IÿJ'Now change the 108 toÿK'109. The Part and)ÿL'Price should change automatically.ÿN\-ÿN\-ÿN\-ÿN\-ÿN\-ÿN\-ÿN\-ÿN\-ÿ ÿ'

3 Responses to “Category : Lotus and other SpreadsheetsArchive   : 123TESTS.ZIPFilename : SELFTST3.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/