, . :
1. ( ), .
2. , .. , , .
3. .
4. .
5. .
. . MS Excel , . .
.
, , . Excel.
, . Excel : , , .
. 1 , Excel.
1
+ | ||
* | ||
/ | ||
% | ||
^ |
. . : = ( ), > ( ), < ( ), >= ( ), <= ( ), <> ( ).
() &.
, .
, , 1:5, , , 1:5.
:
: () , , 2:10, , , 2:10;
; ( ) , , , =(2:A10;C2:C10);
() , , , (B2:D10 C4:C6).
, , , .
|
|
( ) Excel.
, .
, , A3, D4. , , , [2].
$, , $A$4, $A$2, , , .
$, , $A3, B$2, . : , .
Excel , , .
, . , . . , , , , , .
Excel , . , . Excel 5.1. , .
1 Excel
, | |
, | |
, | |
. : | |
, . - . |
|
|
, Visual Basic For Applications. .
, , 10 . , Excel .