.


:




:

































 

 

 

 


Microsoft Excel




Microsoft Excel , . . , , . . 12.1.

. 12.1

SIN =SIN() ( )
COS =COS() ( )
TAN =TAN() ( )
ASIN =ASIN()
ACOS =ACOS()
ATAN =ATAN()
SINH =SINH ()
COSH =COSH()
TANH =TANH()
ASINH =ASINH()
ACOSH =ACOSH()
ATANH =ATANH()
=()
= ()
=(;) . . (. )
EXP =() ( ),
LN =LN()
LOG =LOG(;)
LOG10 =LOG10()
=() (15 )
=(;)
=()
ABS =ABS() ( )
=() (-1 , 0 1 )
=()
=(;_)
ר =ר()
ר =ר()
=(;)
=(;) ( )
=(;_)
=(;_)
=(;_-)
=(;) ,
=(;)
=(;)
=(_1;_2;)
=(_1;2;)
=()
=(1;2;)
=(;;_) , . ,
=(_; _1;_1; _2;_2;) , , . ,
=(1;2;)
=(1;2;)
=(_x;_y)
=(_x;_y)
=(_x;_y)
= (1; 2;)
=()
= ()
=(_1;_2)
=() 0 1
=(_;_)
=(;_) , ,

Microsoft Excel. , , , . .

( ) . . 12.2

. 12.2

=(1;2;...) () *,***
=(1;2;...) ( n - , n ‒ )
=(1;2;...) (, , )
=(1;2;) ***
=(1;2;) ***
=(1;2;) *
=(1;2;)
=() .
. =.(1;2;...) **,***
. =.(1;2;...) **,***
. =.(1;2;...) **,***
. =.(1;2;...) **,***
=(1;2;...)
=(_;_)

* , , , , . , (. . 12.1);

** n -1, ‒ n, n ‒ ;

*** , , . , 0, 1. . . , . . ‒ .

. , , , .

. ( ) .

. 12.3 .

. 12.3

=(01;2) ; 1, , 0 ‒ .
(;) 1, , 0,
=(_ ;_)
.ABS =.ABS(_)
. =.(_) ( )
. =.(_)
. =.(_)
=(;_ ;_)

. . 12.4.

. 12.4

"g" "J"
(slug) "sg" "e"
(.) "lbm" "c"
U ( ) "u" "cal"
(.) "ozm" - "eV"

- "HPh"
"m" - "Wh"
"mi" - "fib"
"Nmi" ( ) "BTU"
"in" "HP"
"ft" "W"
"yd"

"ang" "T"
(1/72 ) "pica" "ga"

"yr" "C"
"day" "F"
"hr" ""
"mn"

"sec"

"tsp"
"Pa" "tbs"
"atm" "oz"
"mmHg" "pt"

"uk_pt"
"N" "qt"
"dyn" "gal"
"Ibf" "l"

(. 12.5; ‒ ).

. 12.5

(1018) E (106) M (0,1) d (10-9) n
(1015) P (103) k (0,01) c (10-12) p
(1012) T (100) h (10-3) m (10-15) f
(109) G (10) e (10-6) u (10-18) a

. 12.3, , (, ). , , . Microsoft Excel.





:


: 2018-10-18; !; : 611 |


:

:

,
==> ...

1690 - | 1630 -


© 2015-2024 lektsii.org - -

: 0.022 .