Excel
, . Excel , , . Excel 8 . , , .11.1.
11.1
( ) | |
####### | , |
#! | - ( ) . - , , . |
#/0! | (, =1/0) , 0 . |
#? | - , . - . - . - (:) - , . |
#/ | , .. . |
#! | , , . |
#! | - - , Excel |
#! | , |
Excel
, . , , Excel ( ) . , , .
1. .
, b, . :
- S:
S = Ö p (p a) (p b) (p c),
p :
p = | a + b +c |
2 |
- r:
r = | S |
p |
- R:
R = | abc |
4S |
:
1. .xlsx.
2. , .11.
3. 2: 4 (. 11.1).
. 11.1.
, 4. , c r Excel : c (column) , r (row) . Excel _.
4. 8 .
|
|
5. , 10. #! , 10, 4, 5 . .
6. , , S, R r, R r .
7. 7 . (). , S, R r. , 8 !, 10 12 (. 11.2).
.11.2. ()
2. .
1. R = 3. , -, .
2. , , ( ), ACOS(). (.11.3).
A = | arccos | b2 + c2 a2 |
2bc |
.11.3.
3. , , (). , (. 11.4).
. 11.4.
4. R : pR2 2pR. () Excel , .11.5.
.11.5.
5. , (. 11.6) : Ö(2-1)^2+(Y2-Y2)^2. .
. 11.6.
6.
R = | 1 | ||||
1 | + | 1 | + | 1 | |
R1 | R2 | R3 |