1. I.
  2. I. .
  3. II . .
  4. II. ֲ
  5. II.
  6. II.
  7. II.
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 (. 8.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 (. 8.4)
(SORT) 0 = (25) = 5 = KOPEH (ABS (-9)) = 3
(SUMIF) ϳ , , - (. 8.5). > 10 2: 5. , 6, 60 (25 + 15 + 20). > 10, , 6. 12 (5 + 3 + 4)
(SUMSQ) , . . , 5 , 1: 4 (. 8.6). 264 (4 + 0 + 16 + 225 + 9 + 1 + 0 + 9)
D E
= (1: 5; 1; 1: 4)

. 8.3.

D E
> 3
= (1: 5)

. 8.4.

1,2
= ˲ (2: 5; "> 10") = ˲ (2: 5; "> 10"; 2: 5)

. 8.5.

= (1: 4)

. 8.6.



2. |

| . | | | 1. | 2. | 1. | 2. | 1. | 2. |

© um.co.ua -