. / . , .
:
(_;__;__)
_ , . , A10=100 . A10 100, . . .
__ , , _ . , _ , . _ , __ , 0. , . __ .
__ , , _ . , _ , . _ , __ ( __ ), . _ , __ ( __ ), 0. __ .
:
7 __ __ .
__ __ , .
, .
Excel , . , ר (. 7). , , , (. 7).
.
. 10.
ln (x 2) 0 7 1 , X>2, 0
:
(. 24).
. 24. .10
X D3:D10 1.
|
|
|
E3 , :
=(D3>2; LN(D3-2); 2)
E10.
. 11.
, . 1.. 3% , 1 5 . - 5%, 5 .- 12%.
:
(. 25).
. 25. .11
F5 ,
= (F5<1000; 3%; (F5>5000; 12%; 5%))
III.4.
, , 01.01.1990 . , .
. ( ):
() - ; () - ; () - ; () - ; 360 ( ; ) + 12 30 .
. 12.
.
:
D5 . F5 , , .. .
F5
= ( ()) (D5)
, , EXCEL . F5 .
G5
= ( ( ())> (D5);F5;F5-1)
III.5.
, . , . . , , , CTRL+SHIFT+ENTER.
. 13.
: (ETC) (. 26). .
19% . (ETC). , 9- , () 3,53.
:
1. . 1 Excel.
2. ets 1 A1:B16 (. 26).
3. (C) ETS ( ). C4:C14 = A4:A14 * B4:B14. : =A4:A14*B4:B14. , Ctrl+Shift+Enter.
|
|
|
. 26. : (ETC)
4. 4:14 ets, 4:14 , , ets OK. 4:14 ets.
5. _13 C A1:C14. .
6. ! 1 Excel.
7. D . , .
8. 1 ( Ctrl+F6- ; , ). , .
9. : =(3;1.xls!ets;3;0).
[1.xls]ets!ets, .. 1.xls. ets, ets; est , . .
10. . (, , =19 OK).
11. () . : =D3:D14*. E2 . D E (.. -) (. II.1).
12. .xls 1.xls. . .xls. . (, - - ).
13. .xls 1.xls , , . Excel.
III.6. ,
. 14.
a, b, . 
,
p 
, 
.
:
1. , . 27 B6 =(2+3+4)/2.
| A | B | C | |
| a | |||
| b | |||
| c | |||
| p | |||
| S |
. 27.
2. B2, B3, B4, B6. A2:B6, , , . , . , B2, B2, a. B4 c, , , c_. , c r Excel (c - column - , r - row - ). Excel .
3. B8 = (p*(pa)*(pb)*(pc_)), . ,
=(B6*(B6B2)*(B6B3)*(B6B2)), .
|
|
|
4. . . 2:A8 .
a, 2. S = 3.799671 ( , B). B8 
- , 3.800. 
Ctr+Z . , , (Ctr+1), , : . , .
5. . B8 - S. B8 S, Enter. D10 F10 r R, E10 G10 (. ). , . 
- . , A8, 
"" E10. (. 28).
| A | B | C | D | E | F | G | |
| a | |||||||
| b | |||||||
| c | |||||||
| p | 5.5 | ||||||
| S | 3.800 | ||||||
| r | 0.691 | R | 2.632 |
. 28. .14
6. . G10 , , . , , G10. . . .
. ( , , ; , , ) . , G10, 
‑ . , c Excel.
a, 10. #! , (). , 10, 4, 5 . . . G10 , , . , . , .
7. . p*(pa)*(pb)*(pc_) . , S, R r. , B8 !, E10 G10 .
B8 B7. B7, . =p*(pa)*(pb)*(pc_). S B7. 8, , , S $B$7 $B$8.
|
|
|
B8
=(B7>0;(B7);" !"). E10 =(B7>0;S/p;""). G10 R.
8. 6- 7- , . 6 7 ( 2,.13). , 5- 8- .
9. . ( ), .
( 2, .3), Ctr+1, , .
B2:B4 ( ). , , . B2:B4 Excel. B2:B4. : , , .
10. . B2:B4 , . : , : - , : - 0. ( ) B2:B4 Excel.
11. , . . . , 4. , .
12. . , a R=3 G10 , : 3 : B2, a ( , $B$2). . .
13. , /, MS Excel.
8
=(((p*(pa)*(pb)*(pc_)));;(p*(pa)*(pb)*(pc_))), , .
9 = ((8); C8/; ). G9 . .
IV.
S l , , .
, 
.
. 15.
Y=f(x) [-3:3] ∆=0,25, .. =2+1. Y=f(x). , , .
:
1. , Y=f(x). , . , . 1 X, 1 Y.
. 2 -3. -2,75. , 2: 3 ( 2, . 7).
2. . 2 : = 2*2 + 1. 2:26.
A1:B26 . ( 1 4): (. 29). .
|
|
|
, , ..
. 29.
. 16.
. 9 .
_9, _16.
:
( ), ;
( ), ;
, ;
, , - .
:
1. . . 4:16, : , . X (), - .
. ( 1 4): (. 29). . , . , .
( 2 4): , : - (. 30). . , .
. 30.
: , X (): , (): ; . . , ( ). , .
( , ). .
, , .
2. .
, 4:16 4:16, ( ) ( ). Ctrl.
:
ü .
ü . ( ) . ( ) ( ). . .
ü ,
. ,
,
, , ( )
. 31
. 31.
3. .
, 4:16 4:16, ( Ctrl). , . 32.
4. .
4:F16, , : , - .
:
ü , / 2. , .
ü . , . 33.
. 32.
. 33.
V. MS EXCEL
, , . ( ) , () ().
:
1.
2. ,
3.
4.
5.
6.
