home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Simtel MSDOS 1992 December
/
simtel1292_SIMTEL_1292_Walnut_Creek.iso
/
msdos
/
lotus123
/
123train.arc
/
FIRST.AST
< prev
next >
Wrap
Text File
|
1980-01-01
|
2KB
|
65 lines
.mt2
.mb2
.po8
A Spreadhseet Assignment
Thi≤ assignmen⌠ wil∞ givσ yo⌡ ß littlσ practicσ witΦ spreadsheets« I⌠ ì
won'⌠ makσ yo⌡ aε expert¼ bu⌠ i⌠ wil∞ givσ yo⌡ ß tastσ oµ spreadshee⌠ ì
processing.
Star⌠ b∙ executinτ 123¼ ou≥ spreadshee⌠ program« Thσ prograφ i≤ oε ì
thσ harΣ disδ iε thσ spreadshee⌠ subdirectory¼ s∩ yo⌡ wil∞ havσ t∩ ì
begiε witΦ thσ DO╙ command:
CD C:\123 (CD is the command to change directories)
Then execute 123 by typing the proram name:
123
Wheε thσ prograφ begin≤ execution¼ i⌠ wil∞ displa∙ ß blanδ spreadshee⌠ ì
oε thσ screen« Yo⌡ shoulΣ theε ente≥ thσ followinτ spreadsheet¼ usinτ ì
thσ appropriatσ formula≤ fo≥ thσ Incomσ Total¼ Expensσ Total¼ anΣ ì
Balance« Remembe≥ tha⌠ ß formulß mus⌠ no⌠ begiε ß lette≥ anΣ ì
don'⌠ forge⌠ thσ label≤ t∩ makσ i⌠ looδ good.
A B C
áááááááááá▒ TITLE║ Studen⌠ Budget
áááááááááá▓ NAME║ you≥ namσ goe≤ here
áááááááááá3
áááááááááá┤ Income
áááááááááá╡ JoΓ 500
áááááááááá╢ Parent≤ 500
áááááááááá╖ Tota∞ 1000
áááááááááá8
áááááááááá╣ Expense
áááááááááá1░ Ren⌠ 300
áááááááááá1▒ Ca≥ 200
áááááááááá1▓ FooΣ 200
áááááááááá1│ Fuε 100
áááááááááá1┤ Tota∞ 800
áááááááááá15
áááááááááá1╢ Balancσ 200
2. Verif∙ tha⌠ i⌠ i≤ workinτ properl∙ b∙ changinτ thσ value≤ oµ thσ ì
ááááJob¼ Parents¼ Rent¼ Car¼ Food¼ anΣ Fuε cell≤ (nothinτ t∩ turε in¼ ì
áááájus⌠ d∩ it).
3. Prin⌠ ou⌠ thσ spreadshee⌠ usinτ thσ PrtSπ commanΣ (turε iε thσ ì
ááááprintout).
4. Jus⌠ givσ thσ qui⌠ commanΣ /╤ wheε yo⌡ finish¼ answerinτ "yesó ì
ááááwheε i⌠ ask≤ iµ yo⌡ reall∙ wan⌠ t∩ quit« Don'⌠ bothe≥ savinτ you≥ ì
ááááspreadsheet.
5. What formula did you use for:
Total Income ___________________________
Total Expense ___________________________
Balance ___________________________