, . , , . , 1 2 (. 2), 11 3. ( ) 4. , , , 2, 3. - 5, 3 ( ) 4 ( ).
| A | B | C | D | A | B | C | D | |||
| =A1*$B$8 | ||||||||||
| =B2*$B$8 | ||||||||||
| =A1+A2 | =$A3*$B$8 | |||||||||
| =A2+A3 | =$A4*$B$8 | |||||||||
| =B3+B4 | =A5*$B$8 | |||||||||
| =$A6*$B$8 | ||||||||||
. 2
, , , . F4. , , $. , F4 1 1, $$1, $1 $1. , .
(. 2), , , . 1 2 5. 1 , 2 , 5 . 5, , $ , ( 3). 4 6, .
.
:
|
|
|
1. , .
2. -, . (), () , ( ).
3. - . , -. () - -.
.
, Excel . : , .
. . , . Excel , . , . ENTER , , .
, . , , , .
. . . ( ) . .
( , ), . .
, , 1 1. , , , 1, 1 1, . , 1. , 1,2 .
, > > . , . Excel .
|
|
|
. , . . : , .
, ( ) . 1 =1+1. . .
.
1.
: Excel. , . , , , .
1. Excel (>>Microsoft Excel).
2. ( ).
3. .
4. > book.xls.
5. 1 .
6. , 2.
7. 1 .
8. 1 .
9. D1 .
10. 2 = 2*2.
11. 2 = 2*2.
12. D2 = 2 + 2 + 1.
13. 2, 2 D2.
14. , . , , D, .
15. , , .
16. , , D .
17. E1 .
18. 2 5.
19. F1 .
20. F2 = 2*2.
21. , F, .
22. , . , 2 .
23. ٸ F2, . 2 F4. , = 2*$E$2, ENTER.
24. F F2.
25. , F . book.xls.
2.
x [-2; 2 ] 0,2 k = 10. . . 3. " ".
|
|
|
.
1. book.xls. , .
| A | B | C | D | E | F | G | H | I | J | |
| n | x | k | Y1=x^2-1 | Y2=x^2+1 | Y=k* (Y1/Y2) | x0 | step | K | ||
| -2 | -2 | 0,2 | ||||||||
. 3.
2. ( 1, ,F1) ( H1, H2, I1, I2, J1, J2) . , .
3. , 1 21, 2 22.
4. - 2 2 0,2, 1 =2. , , I2.
5. k, k J2.
6. D 1=^2-1.
7. E 2=^2+1.
! ; 5.
8. F : y = k*(x^2-1)/(x^2+1).
! , ; 6.
9. .
10. = -5.
11. : step = 2.
12. : k = 1.
! .
13. : 0 = -2, step = 0.2, k =10.
14. .
, .
Exsel .
