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

 “–<
mu ou/


ÿ


ÿ q H 
 d ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0


ÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
%ò&ò'((
LB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
ÿ'LOTUS 123 SELF TEST # 1ÿ
' 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.ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-<ÿ' 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
dGood !;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¸…ëÁ?€AS—+¼à@7÷
AS—+¼à@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
iGood !;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'TOTALS3ÿ
jà`@$
€ù¿
€ú¿
€û¿
۟€ý¿
€þ¿ 3ÿjÀ^@$
€ù¿
€ú¿
€û¿
۟€ý¿
€þ¿ 3ÿj$
€ù¿
€ú¿
€û¿
۟€ý¿
€þ¿ 3ÿj j@$
€ù¿
€ú¿
€û¿
۟€ý¿
€ÿ¿ *ÿk‚tð
€ø¿€ý¿P
jGood !;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ùpS—+¼à@
€
€ÿp'is today's date
ÿp
ÿ p"MON"q"IF THE TIME AT LAX IS=====>øqS—+¼à@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ø
tS—+¼à@

€ý¿ùtS—+¼à@
ÿ€€8ÿt,tð)
ÿ€€"/
ÿ€€/;o u
U3 ÿtSUNÿt"LOS ANGELES
ÿt
ÿ t"FRI
ÿu
"ø
ud¨ìp,¼à@

t
ÿ€€@ ùud¨ìp,¼à@
ÿ€€8ÿu,tð)
ÿ€€"/
ÿ€€/;o u
U3 ÿuSUN
ÿu"DENVER
ÿu
ÿ u"SAT
ñv"ø
vS—/¼à@

t
ÿ€€@ ùvS—/¼à@
ÿ€€8ÿv+t
ð)
ÿ€€"/
ÿ€€/;o u
U3 ÿ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
ÿ
Œ^Buyÿ
'Sellÿ
Ž'Cashÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-