, . . , , . , .
: 1 R1C1. , .
, (. 2.4):
, , , . . , , ;
( ). , ;
, . , , .
<F4> .
1. 1
( ) | ||
5 | $$5 | 5 |
2: F5 | $$2:$$5 | F 2 5 |
D: D | $D:$D | D |
3:3 | $3: $3 | 3 |
2:6 | $2: $6 | 2 6 |
1:3, 3:3, 5:5 | $1:$3, $3:$3, $5:$5 | 1, 3, 5 |
: , :, : | $:$, $:$, $:$ | , , |
2:D5, F2: 4 | $$2:$D$5, $F$2:$$4 | 2 D5 F2 4 |
, . , , , . . 2 Excel.
2. Excel
( | |
) | |
* | |
/ | |
+ | |
- | |
= | |
< | |
<= | |
> | |
>= | |
% |
, . &, , .
|
|
, . , :
= "" & , :
1 500 .,
1500000 .
MS Excel ( , , , , , ). ( ) .
MS Excel , , . MS Excel , . , , :
= ()
, , , . . , ( ).
MS Excel , | .
( )
, . , . .
. . :
=(1, (5, 6))
MS Excel 7 .