: .
. MS Excel , .
:
=(; 1; 2)
, , . , 1, , 2. 1 2 , Excel, .
, . .
2 , :
2
| = | |
| > | |
| < | |
| >= | |
| <= | |
| <> |
( ),
( ).
, . , , , . , B4 1 100, (1<B4; B4<100) , (4=0; 4=101) .
.
1. . 1 .
2. (. 9)
| A | B | ||
| 1 | |||
| 2 | |||
| : |
. 9
3. 4 = (1>2; 1; 2). Enter. 4 .
4. .
1.
1. , .
2. , . 10 ( - ):
. 10
3. 4 , 4 4 , . ! .
4. 5 , 5 5. .
5. , 6 , 6 , . ! .
|
|
|
6. , 7,
 |
- 1, 7 < 0;
0, 7 = 0;
7/7, 7 > 0.
7. .
2.
= -2; -1,5; 0; 3,7.
1. , .
2. 1 ջ, 1 ӻ.
3. 2-5 .
4. 2
= (2<=0; ATAN(A2*A2-1); LN(A2*A2+1)). Enter.
5. 2 3-5.
1
1. . 1.
2. , . 3:
3
| y=f(x) | ||
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
| |
| 
|
2
y=f(x), [-4; 8] h = 0,2. . 3 .
, 2.
