Excel
:
Excel;
Excel, ;
, , ;
;
.
. , .. . Excel . , , .
Excel , :
- (=) Excel;
- (, , , , );
- ( );
- , .
, . , . , . Excel.
Excel
Excel , , Excel. , . Excel . , f , - . , . . , , , p (). , , . Excel . , , , , .. , , . . 2.1.
2.1
Excel | |||
|x| | ABS(x) | x ( x) | |
arccos x | ACOS(x) | ||
arcsin x | ASIN{ x) | ||
arctg x | ATAN(x) | ||
cos x | COS(x) | x, | |
EXP(x) | x |
2.1
|
|
ln x | LN(x) | x | |
logax | LOG(x;a) | x a | |
lg x | LOG10(x) | x | |
sin x | SIN(x) | x, | |
tg x | TAN(x) | x, | |
(x) | |||
p | () | p | |
xa | (x;a) | x a |
. , , . . , , , .
( ) , . Excel . 2.2.
2.2
+ | =1+2 | |
- | =4-4 | |
* | =3*6 | |
/ | B3/5 | |
% | =10% ( 0,01) | |
^ | =2^3 ( 8) |
2.2
= | A5=0 | |
< | A5<1 | |
> | B3>100 | |
<= | 3<=2*A10 | |
>= | A10>=0 | |
< > | A10< >5 | |
: | =(1:10) | |
& | =& .. |
(). , , , , , . Excel:
1) =4-5,2+3,68 2) =2*5+12*6,2
: , . 2*5, 12*6,2, . . .
Excel:
- , ;
- ;
- .
Excel . 2.3.
2.3
- | |||
^ | |||
*, / | , | ||
+, - | , |
( ).
1. : =3+5*COS(B4)-2*A2:
COS(B4)
5*COS(B4)
2*A2
3+ 5*COS(B4)
3+5*COS(B4)-2*A2
2. =(3+A2^3/2)*3/5:
|
|
A2^3
A2^3/2
3+ A2^3/2
(3+ A2^3/2)*3
(3+ A2^3/2)*3/5
1. , , .
2. Excel , . .
3. , , #.
.
#/0! -
#!
#!
#?
#/ !
#!
. .
1. R h. R h . R=1 , h=3 . , , , Excel .
:
1. . ( ):
2. . :
.xls;
A1 ; (, A3, A4) ;
A6:A7 A10:A14 ; : 1 3 R h B6, B7;
MS Equation 3.0.