Microsoft Excel , . , , , (. ), . Microsoft Excel (=). , . , , , .
, (, , , ). : , . . , ( , ). , . Microsoft Excel . 11.1.
. , . , .. , Microsoft Excel , . 11.2. , .
. 11.1
|
| ||||
+ | =2+3 | = | =1 = 1 | ||
- | =5-1 | > | =1 > 1 | ||
- | =-7 | < | =1 < 1 | ||
* | =7*3 | >= | =1>=1 | ||
/ | =7/2 | <= | =1<=1 | ||
% | =50+90% | <> | =1 <>B1 | ||
^ | = 7^2 |
| |||
| |||||
& |
| =" "&"" ( " ") |
. 11.2
1 | , , | (. ) |
2 | () | |
3 | - | "" |
4 | % | |
5 | ^ | |
6 | * / | |
7 | +, - & | , |
8 | =, <, >, <=, >=, <> |
, Microsoft Excel, .
Microsoft Excel
. , . . , ( ).
|
|
10, Microsoft Excel : A1 R1C1 ( ). A1, , . ( !), , , . , , . , =B2, , , B 2. B2 Microsoft Excel .
( , . 13) ( ) : (). , , ; ( ).
, , .. , .
, , . , .
A1 . 11.3.
. 11.3
A 10 | A10 |
: , 10-20 | A10:A20 |
: 15, B-E. | B15:E15 |
: -E, 10-20 | A10:E20 |
5 | 5:5 |
5 10 | 5:10 |
H | H:H |
H J | H:J |
: B5:C15, F5:G15 | B5:C15;F5:G15 |
, , B3:F7 A6:G8 ( B6:F7): | B3:F7 A6:G8 |
( ) . ! ( ). ( , A5:B8 ):
=(1:3!A5:B8)
, , , . :
=[2.xls]1!A8
: 2.xls ( ) , .