. . Microsoft Excel . , .
, () ,
→ . (. 1), : 1) - ; 2) : . - ; 3) , ( ); 4) , ( ). Enter.
Enter.
( ), - . (. 2) , ( ), (. 2) , . ( ), , - .
, .. Excel .
.
. , 3, , , =1* ( 1 5, ). , ,
- ʻ ;
, , .
11. :
.
|
|
1. .
2. 5 . , 120, () -110, () -128. 130 . . ().
8. 14 15 14:15 .
9. 28, 29, 30, 31, 32, 33, 34 35 -
10. 26, 27, 28, 29, 30, 31, 32, 34, 35 , (, ), 16:25, - , - , 26 ܻ 27 , , .
11. 26:35, F.
12. 16, , :
) (4=120) 4=120, 4 , . 16:25. . 16:F25 26:F35. . , . 16:F25 .
) (1;2;), 4>, 4<, 14 15 - . 16:25. . 16:F25 26:F35. . , . 16:F25 .
) (1;2;), 4<, 4>, 14 15 - . 16:25. . 16:F25 26:F35. . , . 16:F25 .
) (_;__;__), 4=120, , . - . 16:25. . 16:F25 26:F35. . , . 16:F25 .
|
|
) (_;__;__), (4>; 4<), , . - . 16:25. . 16:F25 26:F35. . , . 16:F25 .
) (_;__;__), 4>130, , . - . 16:25. . 16:F25 26:F35. . , . 16:F25 .
)
=(B4>120;; (B4=120;;)).
- 4- 4,
, , , .. - .
16:25. . 16:F25 26:F35. . , . 16:F25 .
)
=((B4<;B4>);;(B4>;;)).
- 4- 4,
- , , , , , , .. - .
16:25. . 16:F25 26:F35. . , . 16:F25 .
16 ... 16:F25. 16:F25 ... ... 4:13, ... ... 4:13, ... ... 4:13.
B | C | D | E | F | |
.
10. .
11. ,
11.2. :
- .
- .
11.3. :
- .
- .