1
Microsoft Excel
. () Microsoft Excel.
.
1. ., . . .: , 1971.
2. .. . .: , 1986.
3. .. . : , 1979.
4. .., .., .. . . . : , 1995.
5. .. Excel. .: BHV, 1997.
6. . . .: , 1985.
7. ., . . .: , , 1997.
3. . .
.
1. :
a) :
,
(),
,
;
b) :
,
,
;
c) :
,
;
d) ( " "):
,
;
e) ( " "):
,
,
.
2. :
a) ( " " );
b) ( " " );
c) ( " ").
. , , Microsoft Excel .
Microsoft Excel, .
:
(1.1) |
(1.1) .1.1.
.1.1. (1.1) ( F6)
.1.1 Excel. , , , , . , , (1.1) B3 (), C3 (), D3 (), E3 (), B6 ( 130,5), C6 ( 20), D6 ( 56), E6 ( 87,8), H10 ( 756), H11 ( 450), H12 ( 89) ..
|
|
F6, , , . (1.1)
. | (1.2) |
Excel (. .1.1), (1.2) , (B3, C3, D3, E3), , (B6, C6, D6, E6),
. | (1.3) |
(1.3) F6 "Enter"
=(B$3:E$3;B6:E6), | (1.4) |
$ 3 , Excel 3 ;
: , , , (, B6:E6 B6, C6, D6 E6). 0 ( ) (.1.2).
.1.2. (1.1)
( F6)
1.1. Excel " ", "" " " . , , (1.4) :
F6;
" ", " 1 2";
"" "";
"" ;
"" " 1" B$3:E$3, " 2" B6:E6 (.1.3);
" 1" " 2" "" (. .1.3), F6 , , 0 ( ).
.1.3. " "
(1.1) , (B3, C3, D3, E3), , (B10, C10, D10, E10 1- ; B11, C11, D11, E11 2- B12, C12, D12, E12 3- ). , , .1.1.
1.1
, (1.1)
Excel | |
=(B$3:E$3;B10:E10) | |
=(B$3:E$3;B11:E11) | |
=(B$3:E$3;B12:E12) |
|
|
.1.1, , (1.1), (1.4) F6 . , . . :
F6 F6 ( "Ctrl-Insert");
, F10, F11 F12, ( "Shift-Insert") ( , );
F10, F11 F12 0 ( ) (. .1.2).