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

ÿ–BN
NNNNNNN ÿÿ/


ÿ


ÿ q H 
   d GDATEÿÿÿÿ
G\0ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0
@ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
ÿ%ò&ò'((
LB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
ÿ'LOTUS 123 SELF TEST #3 ÿ'\0 ÿ'/wgpeÿ
' 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.ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-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 Part2ÿ<'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'Thread
¢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\-ÿ ÿ'