.


:




:

































 

 

 

 





( ) , . 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.





:


: 2017-02-25; !; : 256 |


:

:

.
==> ...

1848 - | 1633 -


© 2015-2024 lektsii.org - -

: 0.01 .