home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Simtel MSDOS 1992 September
/
Simtel20_Sept92.cdr
/
msdos
/
lotus123
/
123train.arc
/
SSEVAL.AST
< prev
next >
Wrap
Text File
|
1986-11-05
|
1KB
|
57 lines
Spreadsheet Test Drive
Thi≤ assignmen⌠ wil∞ familiarizσ yo⌡ witΦ somσ simplσ experiment≤ iε ì
spreadshee⌠ evaluation«
Memor∙ capacit∙ i≤ ß limitinτ facto≥ iε man∙ spreadshee⌠ application≤ ì
anΣ somσ program≤ arσ morσ efficien⌠ thaε others« Tr∙ thσ followinτ ì
test≤ witΦ 123:
1. Usσ thσ COP┘ commanΣ t∩ seσ ho≈ man∙ cell≤ caε bσ filleΣ witΦ thσ ì
áááálabe∞ HOH╧ beforσ runninτ ou⌠ oµ memory« (Tr∙ t∩ fil∞ thσ entirσ ì
ááááspreadshee⌠ witΦ thσ label¼ anΣ seσ wheε i⌠ run≤ ou⌠ oµ memory).
2. Usσ thσ COP┘ commanΣ t∩ seσ ho≈ man∙ cell≤ caε bσ filleΣ witΦ thσ ì
ááááformulß 10+2░ beforσ runninτ ou⌠ oµ memory.
Computation speed is another limiting factor.
3. Pu⌠ ß numbe≥ iε cel∞ A▒ anΣ usσ thσ COP┘ commanΣ t∩ placσ thσ ì
ááááformulß 2*$A$▒ iε 100░ othe≥ cells« Ho≈ lonτ doe≤ i⌠ takσ t∩ d∩ ì
ááááthσ 100░ multiplication≤ wheε yo⌡ changσ thσ numbe≥ iε A1?
Disδ storagσ speeΣ anΣ capacit∙ als∩ var∙ froφ prograφ t∩ ì
program.
4. Ho≈ lonτ doe≤ i⌠ takσ t∩ savσ thσ multiplicatioε spreadshee⌠ yo⌡ ì
áááácreateΣ fo≥ tes⌠ │ oε disk?
5. Ho≈ lonτ doe≤ i⌠ takσ t∩ loaΣ thσ multiplicatioε spreadshee⌠ yo⌡ ì
áááácreateΣ fo≥ tes⌠ │ froφ disk?
6. Ho≈ mucΦ disδ spacσ doe≤ thσ multiplicatioε spreadshee⌠ yo⌡ ì
áááácreateΣ fo≥ tes⌠ │ require?