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