3
MS EXCEL
: ; ; ; Microsoft Excel.
Microsoft Excel
Microsoft Excel , . (=), Excel , , . , . - , .
, (.. ). , Excel.
:
- ;
- ;
- ;
- .
1.1.1 . ( ) . , 09.10.2008, 210 . . (, =30+70+110), .
1.1.2 . , . , . Microsoft Excel :
- ;
- ;
- ;
- .
. , , , . . . 1.1 , Microsoft Excel.
1.1
| () | |
| + ( ) | (3+3) |
| ( ) | (31) (1) |
| * () | (3*3) |
| / ( ) | (3/3) |
| % ( ) | (20%) |
| ^ () | (3^2) |
. . : , . . 1.2 , Microsoft Excel.
1.2
| () | |
| = ( ) | (A1=B1) |
| > ( ) | (A1>B1) |
| < ( ) | (A1<B1) |
| >= ( ) | (A1>=B1) |
| <= ( ) | (A1<=B1) |
| <> ( ) | (A1<>B1) |
|
|
|
. (&) . , ""&"".
. , . 1.3.
1.3
| () | |
| : () | . (B5:B15) |
| ; ( ) | . ((B5:B15;D5:D15)) |
| () | , (B7:D7 C6:C8) |
1.1.3 . Microsoft Excel , . , , . , . .
A1. Microsoft Excel A1, ( A IV, 256 ), ( 1 65536). . , . , B2 , B 2. . 1.4.
1.4 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 |
. =(!B1:B10) B1:B10 .
, (!) .
. , A1, , , , . , , . . .
. , $A$1, , . , , . . , .
. , . $A1, $B1 .. A$1, B$1 .. , , , . ,
|
|
|
. . , . Microsoft Excel , , . , =(2:13!B5) , B5 2 13 .
, : , , , ר, ר, , , , , , , , , , , , .
. , , . { } Ctrl+Shift+Enter.
(), , . , . , C10 =B5:B15*5, 5 B10, B10 C10 .
( ) :
1) Þ Þ ;
2) ;
3) , (=) Backspace;
4) (=) ;
5) , , , Shift, ;
6) , .
R1C1. , , . R1C1 . R1C1 Microsoft Excel R, , C, (. 1.5).
1.5 R1C1
| R[-2]C | , |
| R[2]C[2] | , |
| R2C2 | , |
| R[-1] | , |
| R |
Excel R1C1. , , , Excel R1C1, A1. R1C1 Þ , R1C1.
1.1.4 . , , , . , . , A10. :
|
|
|
- . Excel , . , , : _, . , .
- (. 1.6).
1.6
| Microsoft Excel. | |
| . | |
| . | |
| 360 | 360- . |
| , . | |
| , . | |
| . | |
| . | |
| . | |
| . | |
| . | |
| . | |
| . | |
| . | |
| . | |
| . | |
| , , . | |
| , . | |
| . | |
| , . |
- . . , Microsoft Office .
- .
- .
- (. 1.7).
1.7
| , . | |
| . | , Excel. |
| . | |
| , . | |
| , , #/. | |
| , . | |
| ר | , . |
| , . | |
| , #/ ( ). | |
| , , . | |
| , . | |
| ר | , . |
| , . | |
| , . | |
| , . | |
| #/. | |
| . |
|
|
|
- (. 1.8).
1.8
| , . | |
| . | |
| . | |
| . | |
| , . | |
| . |
- .
- (. 1.9).
1.9
| ABS | ( ) . |
| ACOS | . |
| ACOSH | . |
| ASIN | . |
| ASINH | . |
| ATAN | . |
| ATAN2 | x y. |
| ATANH | . |
| COS | . |
| COSH | . |
| . | |
| ר | . |
| EXP | e, . |
| . | |
| . | |
| . | |
| . | |
| . | |
| LN | . |
| LOG | . |
| LOG10 | . |
| , . | |
| ( ). | |
| , . | |
| . | |
| , . | |
| ר | . |
| . | |
| . | |
| . | |
| . | |
| . | |
| 0 1. | |
| . | |
| . | |
| . | |
| . | |
| . | |
| SIN | . |
| SINH | . |
| . | |
| . | |
| TAN | . |
| TANH | . |
| . |
- .
- (. 1.10).
1.10
| ASC | () ( ). |
| , (). | |
| . | |
| . | |
| . | |
| . | |
| , . | |
| . | |
| ( ). | |
| . | |
| JIS | () ( ). |
| . | |
| . | |
| . | |
| , . | |
| PHONETIC | () . |
| . | |
| . | |
| . | |
| . | |
| ( ). | |
| . | |
| . | |
| . | |
| . | |
| . | |
| . |
|
|
|
