ֲ Ͳ
Ͳ
²Ͳ ²
Ҳί Ҳ
ϒ Ͳ
2006 1
MS Excel ( ).
1.
a=4,b=2, x 5 10 0.5.( =7 <0 .)
2
a=3,1; b=1,1; c=7,6; x =-11,5,6,12,3,10.( =12 =0 .)
3
a=2,12; b=2; x -5 8,5 1,5.(0<= <5 x>8 .)
4
a=1,1; b=11; x =1,5,6,11,-3,34.( <2 =34 .)
5
a=3,1; b=3; x =1,5,10,12,-3,34.( =5 <0 .)
6
a=3,2; x =-1,5,8,12,3,6,7.( >=8 =0 .)
7
Y1=
a=1,2; c=3,34; x =-11,3,0.5,7,8,30,6.( >=18 =0 .)
8
a=3,1; b=1,1; c=5,6; x =-11,3,0.5,7,8,30,6.( >15 =12 .)
9
a=2; b=1; x 3 15 3.( =15 .)
10
a=3; b=11; x=2,5,-4,1,-1,8. ( =5 x=1 .)
11
a=3,1; b=3; x=1,5,4,12,3,34. ( =4 x=1 .)
12
a=2,2; b=1,2; x -1 12 1. ( <=1 x>=10 .)
13
a=12,1; c=2; x -3 12 1,5. ( =3 x=5 .)
14
a=3,1; b=2; c=9,9 x=1,5,6,12,3,34. ( <2 x=5 .)
15
a=2,1; b=2,5; x=15,-6,10,3,4,5. ( >12 x=4 .)
16
a=3,1; b=5,9; x=1,5,6,12,3,34. ( >11 <5 .)
17
a=2,1; b=3,9; x =-11,5,16,12,-3,11,24. ( =11 =24 .)
18
a=3,1; b=5,9; x =-1,13,0.5,6,12,3,27. ( =6 >20 .)
19
a=0,1; b=1,9; x =-11,5,6,14,3,12,4. ( =4 >=10 .)
20
a=5,1; c=1,2; x =1,5,-6,14,23,12,40. ( =3 >21 .)
21
a=0,215; b=11,9; x =-10,1,16,14,3,2,-4. ( <2 =14 .)
22
> 21 =7
a=1.2, b=-0,9, x= -13,15,6,1,3,7,-4,26.
|
|
23. :
> 12 =4
a=10.15, b=11.9, x= 1,-5,2,14,3,5,4.
2
MS Excel ( ).
1. " " MS Excel. , .
ʳ - 10.
2. " " MS Excel. , .
ʳ - 10.
3. " - " MS Excel. , . .
ʳ - 10.
-
4. " " MS Excel. , . - : ( / ____ * __). ʳ .
ʳ - 10.
³
5. " " MS Excel. " " " ", .
ʳ - 10.
³
6. " " MS Excel. 1 , , . , - 1 .
ʳ - 10.
³
:...
7. ' " " MS Excel. , . ; - 1. (ʳ - 10).
³
8. " " MS Excel. , "" 12- . : (/100) * . (ʳ - 10).
³
|
|
9. " " MS Excel. , . : ( * ) + - ()
ʳ - 10.
10. " " MS Excel. , 7- . .
ʳ - 10.
³
11. " " MS Excel. , 6- .
ʳ - 10.
³
12. " " MS Excel. , . : ( /100) * .
ʳ - 10.
³
13. ' " '" MS Excel. , .
ʳ - 10.
'
14. " " MS Excel. , , "ճ" "". 360 . : .
ʳ 10.
15. " " MS Excel. , .
: (( / 20) * 100) / .
ʳ - 10.
16. " " MS Excel. , 6- .
.
ʳ - 10.
³
17. " " MS Excel. , . : ( / 100) * .
ʳ - 10.
³
18. " " MS Excel. , , . ʳ - 10.
³
19. " " MS Excel. , .. : - . г : ( / ) * 100. ʳ - 10.
|
|
20. " " MS Excel. , . ³ . . .
ʳ - 10.
21. " " MS Excel. , "2", , , .
ʳ - 10.
22. " " MS Excel. , .
:
(-C) * (1 + R/100) * ʲLK, -<0;
* (1 + R/100) - ) ʲLK, -C>=0
ʳ - 10.
23. " " MS Excel. , .
ʳ - 10.
3
1. , . 1, 2, 3.
³ | |
KVi | Vi |
³ | |
Գ | |
.1
³ | |||||
KRi | KVi | Ri | KDi | Oi | INi |
85,00 . | |||||
120,00 . | 5,20 . | ||||
1 500,00 . | |||||
950,00 . | 5,20 . | ||||
90,00 . | |||||
80,00 . |
. 2
KRi | |||||||
Ni |
.3
4. , .
5. , . 4. , , , , .
. | . | . | % | ||||
KRi | Ai | PPi | PFi | SFi | PRFi | Ui | PVi |
. 4
|
|
:
- Ai=40%*Ni;
- PPi Ni :
- PFi=2%*Ni;
- PRFi=1%* Ni;
- SFi=0,5%* Ni.
5. (Ui=Ai+PPi+PFi+SFi+PRFi). .
6. , . 5 , . ϳ , (SS)
³ | |||
KRi | Vi | Ri | SSi |
SS |
. 5
7. , , , . .
8. .
4
_1.xls ( ) (147 ) . . . ǒ .
. 6
.
.
.
5
1. - .
2. MS Excel.
3. .
4. .
5. .