Output of file : SELFTST1.WK1 contained in archive : 123TESTS.ZIP
 <mu ou/ÿÿ q H   d ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0
ÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ\$%ò&ò'((
LB)'*ÿÿÿÿÿÿÿÿ-·ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqqÿ'LOTUS 123 SELF TEST # 1ÿ' 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.ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-<ÿ' Use / Range Erase to erase the numbers below:
ÿ

ÿ
*
ÿ
R
ÿ
z
ÿ
¢
ÿ 
ÿ /
ÿ W
ÿ 
ÿ §
ÿ
ÿ 4
ÿ \
ÿ 
ÿ ¬
ÿ

ÿ
9
ÿ
a
ÿ

ÿ
±
ÿ
ÿ>
ÿf
ÿ
ÿ¶
ÿ
ÿC
ÿk
ÿ
ÿ»
ÿ
ÿH
ÿp
ÿ
ÿÀ
ÿ%
ÿM
ÿu
ÿ
ÿÅ*ÿôtðø¿ÿ¿PGood !;3ÿÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-Hÿ' Use / Move to move the numbers in column B to column F.
ÿ

ÿ
ÿ
ÿ
ÿ*ÿétðù¿ÿ¿PdGood !;3ÿÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-Dÿ ' Move the column of fives in between the fours and sixes.
ÿ"
ÿ"
ÿ"
ÿ"
ÿ"
ÿ"
ÿ"
ÿ#
ÿ#
ÿ#
ÿ#
ÿ#
ÿ#
ÿ#
ÿ\$
ÿ\$
ÿ\$
ÿ\$
ÿ\$
ÿ\$
ÿ\$
ÿ%
ÿ%
ÿ%
ÿ%
ÿ%
ÿ%
ÿ%
ÿ&
ÿ&
ÿ&
ÿ&
ÿ&
ÿ&
ÿ&
ÿ'
ÿ'
ÿ'
ÿ'
ÿ'
ÿ'
ÿ'
ÿ(
ÿ(
ÿ(
ÿ(
ÿ(
ÿ(
ÿ(*ÿ)ßtðø¿P#Good !;3ÿ)ÿ*\-ÿ*\-ÿ*\-ÿ*\-ÿ*\-ÿ*\-ÿ*\-ÿ*\-.ÿ,' Correct the spelling errors below:Hÿ.' Engineers do not make guesses. Theye look up someone else'sÿ.'ye lookÿ.' up someone else's'ÿ/'guess and use it as a reference!.ÿ0' "I lost my disks," said a student.&ÿ0' "Bummer," said teh instructor.-ÿ1' Why do they put kitchen neasuring+ÿ1'urign spoons on rings? When yuo useÿ1'? When ÿ1' yuo use,ÿ2'one you have to wash all six of them!ÿ2'of them!ÿ4\-ÿ4\-ÿ4\-ÿ4\-ÿ4\-ÿ4\-ÿ4\-ÿ4\-Lÿ6' Format all the numbers in column A like the numbers in column B.
ÿ8È
 8È
ÿ9}
ò9}
ÿ:}
ù:}
ÿ;}
Â;}
ÿ<
 <
ÿ=
=
ÿ>
ö>
ÿ?
ð?
ÿ@ìQ¸ëÁ?
±@ìQ¸ëÁ?AS+¼à@7÷AS+¼à@7ñB¤Cfþø²-À
&
õB¤Cfþø²-À
&
ÿD\-ÿD\-ÿD\-ÿD\-ÿD\-ÿD\-ÿD\-ÿD\-7ÿF' Delete the rows that appear more than once.
ÿH
ÿH
ÿH
ÿH
ÿI
ÿI
ÿI
ÿI
ÿJ
ÿJ
ÿJ
ÿJ ÿK'extra
ÿK
ÿK
ÿK
ÿK
ÿL
ÿL
ÿL
ÿL
ÿM
ÿM
ÿM
ÿM
ÿN
ÿN
ÿN
ÿN
ÿO
ÿO
ÿO
ÿO ÿP'extra
ÿP
ÿP
ÿP
ÿP
ÿQ
ÿQ
ÿQ
ÿQ*ÿS©t ðõ¿þ¿P\$Good !;3ÿSÿT\-ÿT\-ÿT\-ÿT\-ÿT\-ÿT\-ÿT\-ÿT\-FÿV' Insert a row between the threes and fives and enter fours.
ÿX
ÿX
ÿX
ÿX
ÿX
ÿY
ÿY
ÿY
ÿY
ÿY
ÿZ
ÿZ
ÿZ
ÿZ
ÿZ
ÿ[
ÿ[
ÿ[
ÿ[
ÿ[
ÿ\
ÿ\
ÿ\
ÿ\
ÿ\*ÿ^tðú¿þ¿PiGood !;3ÿ^ÿ_\-ÿ_\-ÿ_\-ÿ_\-ÿ_\-ÿ_\-ÿ_\-ÿ_\-8ÿa' Find and correct the errors in this section.
ÿc
ÿc- ÿc"10
ÿcZ
ÿd

ÿd ÿd"30
ÿd
ÿe
ÿe- ÿe"45
ÿe-
ÿf-
ÿfÿf"3
ÿfÿg' 3
ÿg ÿg"45
ÿg-
ÿh-
ÿhÿh"6
ÿhÿi\=ÿi\=ÿi\=ÿi\=ÿi\=
ÿj'TOTALS3ÿjà`@\$ù¿ú¿ û¿ ü¿ ý¿ þ¿ 3ÿjÀ^@\$ù¿ú¿ û¿ ü¿ ý¿ þ¿ 3ÿj\$ù¿ú¿ û¿ ü¿ ý¿ þ¿ 3ÿj j@\$ù¿ú¿ û¿ ü¿ ý¿ ÿ¿ *ÿktðø¿ý¿PjGood !;3ÿkÿl\-ÿl\-ÿl\-ÿl\-ÿl\-ÿl\-ÿl\-ÿl\-ÿm"LOOKUP TABLE:ÿn' Copy the formulas below to complete the table.
ÿo
ÿ o"SUNùpS+¼à@ÿp'is today's date
ÿp
ÿ p"MON"q"IF THE TIME AT LAX IS=====>øqS+¼à@7 q
ÿq
ÿ q"TUEÿr^DIFFERENCE ÿr^TIME ÿr^DATE
ÿr^DAY ÿr^CITY
ÿr
ÿ r"WEDÿs\=ÿs\=ÿs\=ÿs\=ÿs\=
ÿs
ÿ s"THU
ÿtøtS+¼à@ý¿ùtS+¼à@ÿ8ÿt,tð)ÿ"/ÿ/;o uU3 ÿtSUNÿt"LOS ANGELES
ÿt
ÿ t"FRI
ÿu"øud¨ìp,¼à@tÿ@ ùud¨ìp,¼à@ÿ8ÿu,tð)ÿ"/ÿ/;o uU3 ÿuSUN
ÿu"DENVER
ÿu
ÿ u"SAT
ñv"øvS/¼à@tÿ@ ùvS/¼à@ÿ8ÿv+t
ð)ÿ"/ÿ/;o uU3 ÿvSUNÿv"NEW YORK
ÿw øw ùw
ÿw"LONDON
ÿx øxùxÿ ÿx^PARIS
ÿy øy ùy ÿy^GUAMÿ{\-ÿ{\-ÿ{\-ÿ{\-ÿ{\-ÿ{\-ÿ{\-ÿ{\-Iÿ}' Write a date formula to display the following dates, and find,ÿ~'the number of days between the dates.Iÿ' Write your formula in column C then format the cell as a date. ÿ^DATEÿ' January 10, 1986 :ÿ' March 18, 1988 :ÿ"Difference:\$ÿ;tðÿ¿Good !;3ÿ4ÿ'(Difference = number for 03/18/88 - 01/10/86)ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-Aÿ' Change all the labels in column B to right justified. ÿ'Ed
ÿ^Ted ÿ"Total