'. Excel ', ( Word, Paint .)/ ' , '. Windows-95, Excel. Excel /. . (. 1) '. ϳ , ' . , Windows, ' . ' /.
, ', . /. , , , , .
Excel , . .
' . ' , , , , . ' , , , '.
ij. Excel 䳺 15 . . , ,
. ij . . 2.
, - . Excel , .
. 1.
, . 2, , . , 3 (, , ), 2 (ѳ, ). , 2 (ѳ, ), 3 (, , ). ij , . 1.
. 2.
. ij .
, . . , , . ' 1 5. ' ( ).
|
|
// . ., , . 1 5. , ( . . 3).
. 1
n
n
n
n
n
n- ( 1 Y , 2 X )
n-
- n-
n-
n
1 5
, , . . . . .
ϳ ., 2 5. 15 ( ). 3 5 .
4 5 . , . , , . , ,
. 3.
. , , ( , , , ).
, . 3 6:7 , , 5:7, 4:7 , . . , ( ).
|
|
. 4.
³ 5 5 , , X . ϳ .
( ) ( ).
. 5 , . 3. . (. 13.20.). .
. Excel . . , , . [Ý] [ß]. , [Ü] ] [Þ] .
' ' ' ( ). (, , , ). . , . , .
, , , , () , . , .
. , . Zap, :
No Yes Contents
(ͳ ).
No , READY. Yes , . Contents , .
. , . 1. D1 " ", D3 "", 5 "", 5:5 , F5 " ", 13 " ", 14 " ", 7:11 , 7:11 . F7:F11 . SUM , ( F7 SUM (B7:E7), F8 SUM(B8:E8) ..). 14:14 . AV , ( Ѳ 4 AV(C7:C11), D14 AV (D7:D11) ..). 7:11, 14:14 F7:F11.
|
|
D F G
1
3
5 - ճ Գ
6
7 5 5 5 4 19
8 3 4 3 2 12
9 4 4 5 5 18
10 2 2 3 3 10
11 3 5 4 2 14 12
13
14 3.4 4 4 3.2
.
20 1 Width: 9 Memory: 79 Last Col/Row:G37
1> READY Fl:Help F3:Names Ctrl-Break:Cancel
. 1
. Load. Zap, . , , ' , Zap .
ϳ Load FILE
Enter File Name
( ' ).
' , , ' (Load, Save, Output). ' , .
:
[Enter], ' ;
[F2], , ';
[F3] FILE.
, l.
ϳ ' Load:
All Values Consolidate Part Names Graphs
( ' ij)
dz All, Values, Consolidate.
All (, , , ).
Values , .
Consolidate ' ( , ). , .
Save. , l. , , , , Global .). , , COPY TYPE, . CAL- , Load . , Output, .
ϳ Save FILE :
Enter File Name
( ' )
ij , Load. ϳ , . ' , :
|
|
Change Backup Owerwrite
( )
, Change. '.
Backup CAL . , . , Backup : .
Overwrite .
ϳ Change, , Overwrite ( , ) ' :
All Values Part
( )
All : , , , , .
Values , .
Part , , . ϳ Part All Values ( ). ϳ :
From? Enter range
(? ),
. , POINT. ϳ .
. Output (. output ). . ϳ ' : Printer () Fil(). Printer . File . , . , MS DOS, ' . Load. ϳ File ', :
Enter File Name
( ' )
ij Save. , PRN. , 䳿 , Save.
ϳ Printer File ( ) ' :
Range Go Console Line Page Options Zap Align Quit
(ij )
Range , . Point . All.
Go . , Output.
Console , . .
Line , Page .
Options ( ). ; ( 66 ), ( 80 ), ( 4 ), ( 2 ), ( 2 ) .
Zap . - ( Options).
Align , .
|
|
Quit Output. , , , , .