.


:




:

































 

 

 

 


MS Excel ( ).




ֲ Ͳ

Ͳ

 

²Ͳ ²

Ҳί Ҳ

ϒ Ͳ

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. .





:


: 2016-11-18; !; : 1065 |


:

:

: , .
==> ...

1343 - | 945 -


© 2015-2024 lektsii.org - -

: 0.064 .