, :
³ (. ).
, , .
' '. , , ' . , ', .
, Microsoft Excel:
. : , , .
, , Z$100 R1C1.
. , : . _.
' 255 .
' , Microsoft Excel . , ' , ' ƻ, ' .
(. 2.10).
2.10
ϳ ʻ. ' , .
2.3.3
- , .
, .
, , .
=SUM(E6:E11) 6, 7, 8, 9, 10 11.
=SUM(E6;E11) 6 11.
:
1. ij (:).
2. , (;)
, 
.
, 
, .
2.3.4
. , , . :
,
,
.
B4 25. D5, E5 F5 (. 2.11).
|
|
|
Microsoft Excel , Funcs.xls (\MicrosoftOffice\Office)...
 |
2.11
, . . (=), , .
2.3.5
, . Microsoft Excel : , , .
(, , , 䳿 ). (. 2.2)
. (. 2.3).
2.2
| + ( ) | 3+3 | |
| ( ) | ³ | 31 |
| 1 | ||
| * () | 3*3 | |
| / ( ) | ij | 3/3 |
| % ( ) | ³ | 20% |
| ^ () | 3^2 ( 3*3) |
2.3
| = ( ) | A1=B1 | |
| > ( ) | A1>B1 | |
| < ( ) | A1<B1 | |
| >= ( ) | A1>=B1 | |
| <= ( ) | A1<=B1 | |
| <> ( ) | A1<>B1 |
& ' (.. 2.4).
2.4
| & () | ' . | "ϳ" & "": "ϳ " |
(.. 2.5).
. . , , , . , , , . , , . =B15*5 B15 5. B15.
, , .
2.5
| : () | , . | B5:B15 |
| , () | ', ' . | (B5:B15,D5:D15) |
| () | , . | (B5:B15 A7:D7) |
B7 .
|
|
|
