() Microsoft Excel.
. . Excel . , ; ; .
Microsoft Excel, .
I. :
1) :
,
,
,
;
2) :
,
,
;
3) :
,
;
4) ( " "):
,
;
5) ( " "):
,
,
.
II. :
1) ( " ");
2) ( " ");
3) ( " ").
:
(1.1) |
(1.1) 1.1.
1.1
1.1 Excel. , , , , . , , 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) |
, (B3, C3, D3, E3), , (B6, C6, D6, E6), :
|
|
. | (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. Excel " ", "" " " . , , (1.4) :
F6;
" ", " 1 2";
"" "";
"" ;
"" " 1" B$3:E$3, " 2" B6:E6;
" 1" " 2" "" ( 1.3), F6 , , 0 ( ).
1.3
" "