3.1 1. (..9) .
. . . :
1. B4:G4 Σ () . H4 . . =(B4:G4), .
2. 4 H5:H7.
3. .
4. 4 =H4*J4 ( = * ).
1. , . 2. ####### , (2 ).
5. K5:K7.
6. M4 = I4*J4 ( = * ) M5:M7.
7. N4 =K4-L4+M4( =-+ ).
8. N5:N7.
9. J4:J7 , , :
J4 =,
,
D2,
, . J4 = !D2,
J5:J7.
, . . :
( ), A1, B2, C3, . , $A$1, $D$12, . , . : 1) F4 $; 2) $ ; 3) .
:
1. B13 B14: B13,
(. . 1, . 8), , Enter, B14.
. , Enter.
2. L4:L7 : L4, =, K4, *, B13, , , L4 =K4*, L5:L7.
|
|
3. K4:K7 _: K4:K7, _, Enter. K8 : K8, Σ (), , , = (_).
. , , , . :
1. B9.
2. fx. , .
3. B4:B7. 1 . .
4. (+) C9:G9, .
.
.
, 400 . . .
. . . , , ; , , .
1. I4.
2. fx.
3. , .
4. H4>= ( ).
5. __ H4.
6. __ 0.
7. OK, I4 =(H4>=;H4;0).
8. I5:I7.
. , , .
450 .
(. 4)
, .
4. .
:
1. G2, G3, G4 _, _, _.
2. D2 : =(C2<>"";(C2<>"";_;_);_)
. < > ; >= . (C2, _ . .) , 1 .
|
|
3. .
4. .
5. D2:D5 .
6. D5 ( ) ( ).
. .
7. (. . 5)
5. .
3.2 1. : (); (); , , ().
3.2.1 :
1. MS Excel.
2. (. 6).
A | B | C | D | E | F | G | H | |
- | ||||||||
"" | ||||||||
"" | ||||||||
"" | ||||||||
"" | ||||||||
"" | ||||||||
"" | ||||||||
" " | ||||||||
6
3. =((C3:F3);0). (G3:G9).
4.
=(G3<60;1;(G3<70;2;(G3<85;3;(G3<94;4;5)))). (3:9);
5. : =((C3:C9);0) D10:10.
6. : =(C(C3:C9);0) D11:11.
7. : =((C3:C9);0) D12:12.
8. 7.
9. .
"" | |||||||
"" | |||||||
"" | |||||||
"" | |||||||
"" | |||||||
"" | |||||||
" " | |||||||
. 7.
|
|
4 : IBM PC, MS Excel.
5. : . , . . .
6 :
1. Excel.
2. .
3. .
4. .
5. .
6. . .
7. ?
8. , , ?
9. (); ()?