- Microsoft Excel.
, .
Excel : , , , , .
, = (). :
=f(argl,...),
u f ; argl ,... ( 30).
:
= ;
[fx] ;
.
:
1) (. 1);
2) ʻ, 2 2 (. 2);
3) ʻ. . .
. 8.1 ( 1 2):
.8.2.
1 | 2 | 3 | 4 |
ABS | , | = ABS(-123,89) = 123,89 | |
EXP | =2,71828182... | = () = 20,08553692 | |
LN | (>0) | = LN(1) = 0 = LN(2) = 0,693147 LN(100) = 4,60517 | |
LOG10 | = LOG10(100) = 2 = LOG10(0,1) = -1 | ||
LOG | . >0 #1; Excel 10 | = LOG(10) = 1 = LOG(8;2) = 3 = LOG(100; 2,71828...) = 4,60517 | |
(SUM) | 30 , , , , , | 54 (. 9.3) , 1:5, 1:. 5 15 | |
- (POWER) | =(5;2)=25 =(4;1/2)=2 =(4;-1/2)=0,5 =(6,25;1,5)= 15,625 | ||
(PRODUCT) | 30 | , , , , ; | 5 1:5 (. 9.4) |
- (SORT) | 0 | = (25) = 5 = KOPEHb(ABS(-9)) = 3 | |
(SUMIF) | , | , (. 9.5). >10 2:5. , 6, 60 (25+15+20). >10, , 6. 12 (5+3+4) | |
(SUMSQ) | , .. | , | 5 , 1:4 (. 9.6). 264 (4+0+16+225+9+1+0+9) |
|
|
D | E | ||||
1 | 3 | 4 | |||
2 | |||||
3 | 2 | ||||
4 | 5 | ||||
5 | 1 | =(1:5;1;1:4) | |||
6 | |||||
7 |
. 8.3.
D | E | ||||
1 | 1 | ||||
2 | 2 | ||||
3 | 3 | ||||
4 | >3 | ||||
5 | 6 | = (1:5) | |||
6 | |||||
7 |
. 8.4.
1 | ||
2 | 25 | 5 |
3 | 8 | 1,2 |
4 | 15 | 3 |
5 | 20 | 4 |
6 | =(2:5; >10) | =(2:5; >10;2:5) |
7 |
. 8.5.
1 | 2 | 3 |
2 | 0 | 1 |
3 | 4 | 0 |
4 | 15 | 3 |
5 | =(1:4) |
. 8.6.
(ODD) | = (2,36) 3 = (0,1) 1 = (-2,1) -3 | |
(ROUND) | = (4,15;1) 4,2 = (1,237;1) 1,2 = (1,5;0)2 = (42,5;-1) 40 | |
(ROUNDDOWN) | , , | - |
(ROUNDUP) | , , | - |
(TRUNC) | , , | = (8,365;1) 8,3 = TRUNC(-1,567) -1 |
(INT) | 1,5 = (1,5) = 1 123,567 = (123,567) =123 -5,5 = INT(-5,5) = -6 |
. 1:5 2:5 . C2:D5 (. 8.7).
D | ||||
1 | ||||
2 | 4,15 | 1 | 4,1 | 4,2 |
3 | 1,237 | 2 | 1,2 | 1,3 |
4 | 1,5 | 0 | 1 | 2 |
5 | 42,5 | -1 | 40 | 50 |
|
|
. 8.7.