( ) , . F4 : (, $C$1); (C$1); ($C1); (C1). , $A$1 F4, A$1. F4 , $A1 . .
A1. Excel A1, ( A IV, 256 ), ( 1 65536). . , . , D50 , D 50. , , (:), , . ( 24.1).
24.1.
A 10 | A10 |
10 20 | A10:A20 |
15 B E | B15:E15 |
5 | 5:5 |
5 10 | 5:10 |
H | H:H |
H J | H:J |
E 10 20 | A10:E20 |
R1C1. , , . R1C1 . R1C1 Excel R, , C, . R1C1 : R , . , R1C1 $A$1 A1. A1 , R[1]C[1] , , B2.
24.2. R1C1.
R1C1, ,
R1C1 .
24.2.
R[-2]C | , |
R[2]C[2] | , |
R2C2 | , |
R[-1] | , |
R |
,
|
|
1. , .
2. , .
3. , .
4. , . , .
5. .
6. Enter.
, :
1. , .
2. = ( ) .
3. Enter.