.


:




:

































 

 

 

 


.

Excel

, Excel, , . =. , Excel. : = (7 - 4) * 2.

Excel , :

;

, ;

(), (*) (/), - (+) ().

, .

MS Excel.

Excel , . :

< ><( 1;...; N)>.

, .

. ,

=(1;2;4)

Excel, 1,2 4. , . , =(1:;2:4)

, . :

=(1:;2;4:7).

, (), . , =((16);5(())).

  =(*) - , , . : 1, > 0; 0, = 0; -1,-<0
  =8() - , ,
  =(*,;...;*) <= 30; ,
  =(,;.. )
  =(;) *>=0
  * =(;) ( * )
  =() >= 0. ,
  =(*) [ 1 ]
  =(;;) , x-ent[x /]. <,
  =(*,;...;*) <= 29. \ , . : *;>0
  =(*...;*)

  =LN > 0, <= 0 #!
  =LOG10(x) > 0, <= 0 #!
  =(*;) > 0, <= 0 #! = 10
  =(*)
  =(;)
         

. Excel
  =() 14
    =()
    =()
  Sinx =SIN(jc) -
  Cos =COS(jc) -
  Tgx =TAN(x)
  Arctg x =ATAN(jt) - / 2 / 2
  Arcsin x =ASIN(x) : -1 <=*<= 1. -7t / 2 / 2
  Arccos x =8() : -1 <=<= 1. 0
  Arctg =ATAN2(x;y) , (0,0) (, ). z - < z < , -. 0; , #/0!
         

Excel : =SINH(*), =COSH(x), =TANH(x), =ASINH(*), =ACOSH(*), =ATANH(;c).

2.4.

  =(*;) = 0 - ; > 0 - ( = -2, ); < 0 ( = 2, ). < 5 (), >= 5 ()
  =(;) ,
  =(;) ,
  =ר(*) . > 0 - ; < 0 -
  =ר() . > 0 - ; < 0 -
  , =(;) , . * . #!
  , =(*;) , . . #!
  =()
  =(*,) . ,


<== | ==>
Microsoft Excel | 1
:


: 2016-09-06; !; : 646 |


:

:

: , , , , .
==> ...

1439 - | 1317 -


© 2015-2024 lektsii.org - -

: 0.012 .