V.1.
. 
, (. 34).
. 34.
Excel ( , , ).
() , ( ). : .
(, , )
(, , ). , .
. 17.
.
:
1. . 13 1 Excel. 8 _ 1, _ 2 .. 8- . 35 .
. : % .
2. _1 , ( 1 15) 4 .
. 35.
_1 ( ).
.
(%).
, ( ).
. .
3. 2 -5 (_2 - _5) :
2 5 000 . 2.
3 - 150 . .
4 - 100 300 ./2.
5 - , 2% .
2 .
4. _6 .
. 36.
|
|
|
Excel. : - 1000 .2 100 000 . .
5. _7 1 3 .
( ) , .
Excel , .
.
_6 , "" 1 . .
5. _8 . .
.
V.2.
. , . . , , .
( , , , ).
( Excel Microsoft Excel) . . . ( ). . : , , (. 37).
. 37. -
. , . , . , . . , . .
. , . , , . , . , , .
. , , , ( ). , .
|
|
|
, . , , , . .
. , , , , . , , .
. , . .
, , . , . , . , , , , .
, . , , , , , , . . , , .
, . .
, , . ( ), , . .
, . , . . , , . .
. 18.
, _18, . 9. .
:
|
|
|
1. . , .
2. , Microsoft Excel . .
3. , . .
4. , . .
5. : , , .
6. . . .
7. . . . .
8. . , , . .
9. (_18( 1), _18( 2) . .)
VI. EXCEL
. . Excel.
1.
- . .
1. Y= f(x), MS Equation (, , MS Equation).
2. f(x) [1:10] 0,5. , , .
3. Y . Y .
4. Y= f(x) . , , , .
| 1. | 
| 22. | 
|
| 2. | 
| 23. | 
|
| 3. | 
| 24. | 
|
| 4. | 
| 25. | 
|
| 5. | 
| 26. | 
|
| 6. | 
| 27. | 
|
| 7. | 
| 28. | 
|
| 8. | 
| 29. | 
|
| 9. | 
| 30. | 
|
| 10. | 
| 31. | 
|
| 11. | 
| 32. | 
|
| 12. | 
| 33. | 
|
| 13. | 
| 34. |
|
| 14. | 
| 35. | 
|
| 15. | 
| 36. | 
|
| 16. | 
| 37. | 
|
| 17. | 
| 38. | 
|
| 18. | 
| 39. | 
|
| 19. | 
| 40. |
|
| 20. |
| 41. |
|
| 21. |
| 42. | 
|
2.
- , .
1
- .
. = / + . 25,4. / :
| / | = | . / * - . - . |
: / 150$, - 50% /, - 100%. . .
| 30,00. | |||
| .. | .. | .. | |
| $121,50 | $142,30 | $155,20 | |
| $122,50 | $143,30 | $156,20 | |
| $123,50 | $144,30 | $157,20 | |
| $124,50 | $145,30 | $158,20 | |
| $126,50 | $146,30 | $159,20 | |
| $127,50 | $147,30 | $160,20 | |
| $128,50 | $148,30 | $161,20 | |
| $129,50 | $149,30 | $162,20 | |
| - . , | |||
2
|
|
|
. , - . :
| = | - | - | - |
. .
. . . = . . . +
:
| = | (.) | * | 100% |
, ( ).
| : (-), (+) | (.) | |||
| % | ||||
| $869 | $7 | |||
| $197 | -$1 | |||
| $324 | -$15 | |||
| . | $32 | -$1 | ||
| $654 | -$6 | |||
| $258 | -$2 | |||
| $15 | $8 | |||
| - | ||||
| $136 | -$15 | |||
| . |
3
: =(*)/(100*12).
, . : $150, , $180, - , .
.
4
(..) .
. . , . .
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| .. | |||||||||
| (.) | ||
| 5,0% | ||
| 5,5% | ||
| 6,0% |
5
=(/)*(/).
| . | . () | - . () | () | . . () | . () | |
1, , - 2.
|
|
|
6
(.).
15% .
: 1 . .., 15% 1 ., - 10%.
= + + .
= - .
