() Microsoft Excel.
, , Microsoft Excel .
1.3. ֲ Microsoft Excel в [5]
Microsoft Excel, 䳿.
1. :
a) :
,
(),
,
;
b) :
,
,
;
c) :
,
;
d) ( " "):
,
;
e) ( " "):
,
,
.
2. :
a) ( " " );
b) ( " " );
c) ( " ").
1.3.1.
:
(1.1) |
1.3.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:E 6 (.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).
. , (.1.4 1.5).
.1.4. F6
.1.5. F12
3
䳿 " ", "" (. 1.6):
" ";
$F$6 ¾ ;
, " ".
.1.6. ³ " " (1.1)
" " " " $B$3:$E$3. " " .
, (. .1.1).
"", ' " " (. 1.7).
" " $B$3:$E$3. , .
.
"" , $B$4:$E$4. .
.1.7. (1.1)
, , =
"" " ".
" " , $F$10. , .
³ (1.1) , =.
"" , $H$10.
: $F$11>=$H$11, $F$12<=$H$12.
ϳ OK.
³ " " (1.1) . 1.6.
, , "" "" (. . 1.6).
1.3.1.2. г
" ". "" " " (. 1.8).
.1.8. ,
|
|
" " ( ), . , 32 767 ( 9 ).
" " . , 32 767.
"³ " , . 0 1. , . , , .
" " . .
"" .
"˳ " -.
ϳ "OK".
" " "".
ϳ ' " " , . 1.9, 1.10 1.11.
.1.9.
.1.10.
.1.11.
, . 1.10 1.11, , , Excel , Excel , (. .1.3.5).
" " , Excel - , , . "³ " . , 0,000001 0,00001 ..
" " : "", "", "". (. .3.3). ( , ) "OK". ϳ ' (.1.12).
.1.12. (1.1)
, (1.1) . .
, ( ) (.1.13).
" " ( """ "), "" , ', " " (.1.14):
|
|
- " " , $B$3:$E$3;
- "" ;
- " OK" .
.1.13. г (1.1)
.1.14. (1.1)
.1.13 (1.1), .
Excel . .
, (.1.2).
1.2
, . /. | 1- | 2- | 3- | , . |
1- | ||||
2- | ||||
3- | ||||
4- | ||||
, . |
ֳ
(1.5) |
, , , (1.5) .1.15, 1.16, 1.17 .1.3.
.1.15. (1.5)
( F15)
1.3
(1.5)
' | Excel |
C3:E6 | |
F15 | =(C3:E6;C12:E15) |
F3, F4, F5, F6 | =(C3:E3) =(C4:E4) =(C5:E5) =(C6:E6) |
7, D7, E7 | =(C3:C6) =(D3:D6) =(E3:E6) |
H8, G9 | =(H3:H6) =(C9:E9) |
.1.16. (1.5)
.1.17. (1.5)
( F15)
1.3.4.
, : 0 1. , , . .1.18 .
.1.18. г
(. .1.3.2) :
"" (. .1.18);
" " , (. 1.19).
.1.19.
" " , . 1.18, . 1.20.
.1.20. ³ " " , . 1.18
1.3.5.
, , Excel. , , .1.4.
1.4 , Excel | ̳ Excel | ³ " " | ³ " " | ³ " " " " | , ³ " " "" | ³ " " "" | ³ " " "" | ³ " " "" | ³ " " "" | ³ " " | |||
(+, ) , ? | ? | ? . , (. . 1.4, 1.5). | ? | ? | ? | (<=, >=, =)? | ? | ? | ( ) | ( )? | (. .1.3. 1.2) | ||
1.4. ² Ҳ
|
|
1. MS Excel?
2. ?
3. $ MS Excel?
4. MS Excel ; :?
5. ?
6. MS Excel ?
7. , ?
8. , , ?
9. " ".
10. , , " "?
11. MS Excel : ; ; ?
12. , " ".
13. MS Excel ?
14. MS Excel ?
15. MS Excel ?
1.5. в
MS Excel, , (. 1.5).
1.5
1