" ", "", Excel , , , .
3 " ":
1. > "" > "...";
2. > > " ";
3. > "Ctrl+1".
:
""
. ;
""
, ;
(, ..);
:
;
;
();
.
! , , . , 1,23456. 4 . 1,2346. 100 000 123 456, 123 460! , .
""
, "" ( ), . , " " > " " > " ".
""
, "" ( : ). "" . , "", "$", , "". ( ), "$" "-" . , - .
""
(. ), " " . , .
""
(. ), " " . , .
|
|
""
"" 100 "%". .
""
"" Excel . , "1,2" ( , ) "1 1/5" ( , ).
""
"" ( ) ( ) . , "299 792 458" ( ) "3,E+08". "+" , , "08" . .
""
, , , . . , , "", "1.2.3", Excel .
1- " ' " ( "" ) . " ' " .
""
"" "". "" : " ", " + 4", " ", " ". " " 10- . . .
"( )"
(, "", ".", "/" ..), . . "Enter". "" "". . (: ; , "" .)
[]
!!! , . : Office 2007 .
Excel, , , : , , .
" ", :
"" > " ..."
3- . , " >>". "", , , . , , Excel .
|
|
, , .
="" , Excel , "0".
!!! ! ="" "=(C14;2)=0", "0" .
, . , .
->
"(;)" . "C14" ( ), Excel "" . ( , ""), "C14".
!!! "Delete" ! " " "...", "" > "" > "".
[]
() .
, , , , . :
1 1 (, , );
;
Excel ( , , , );
;
.
, , , :
, - , .
[]
[]
Microsoft Excel . Excel 256 (2 8 ) 65536 (2 16 ) ( Excel 2007 16384 (2 14 ) 1048576 (2 20 ) ). , , : A1, C16. , : A1:C5.
[]
Microsoft Excel:
;
R1C1 ( R row (), C column ()).
R1C1 > > > R1C1
A1 =B3 (B3 ), R1C1 =R[2]C[1]. R1C1 . R (row) (, , R[-2] ). C 1 ( C[-1] ). , .
|
|
A1 =$B$3 ($B$3 ), R1C1 =R3C2. , , ( ).
[] ( )
Excel 3- :
(: A1);
(: $A$1);
(: $A1 A$1, , ).
$ , Excel . , , .
"=", , Excel "=" . "", ( ) , "=" ( ). , 3- 2 . Enter , , . , 3 2 . , , , F2. , . "û 8 . : , û 2 . , 2 . , . , , , Excel ( ).
, , , Excel . , . .
, $ , $A$1. F4, Excel $. F4, A$1, $A1, . .
. . . , =A$1. A$1 A 1. , A1, . , , Excel . , , , ($1), (A, B, C...).
|
|
[]
/ , , . , , .
! .
, (. . ) Enter. . . ( "Ctrl").
:
"F3", :
: "=(tablica_1);"
(: ) - ///. Excel 2007 - / /.
[] Microsoft Excel
[]
Excel - . Excel . Excel , "=". "1+1", Excel . , "=1+1" Enter, - 2. Enter , , , F2 Ctrl+. , . , F2 , , Enter.
( . .), , , , . , ( . .). .
[]
, . =, Excel , ="" , .
[]
, ( ), . =, . Excel .
, Excel . . : =A1+D1, Enter, . , A1 D1 . , , , . . , , .
[]
Excel . 2 . , * . , Excel .
. : + ( ), - ( ) % ( 100).
[]
+ (: =1+1);
- (: =1-1);
* (: =2*3);
/ (: =1/3);
^ (: =2^10);
|
|
% (: =3 % 0,03; =37*8 % 8 % 37). %, 100.
[]
">" ;
"<" ;
">=" , ;
"<=" , ;
"=" ( );
"<>" ( ).
[] 2-
& () . , A1 , A2 . A3 =A1 & A2. A3 . , . , : =A1 & " " & A2. "", : =(A1;" ";A2).
[]
: (). . (A1:A15);
; ( ). ((A1:A15;B1:B15));
(). . (B7:D7 C6:C8).
[]
Excel .
(, =2*(2+5), 14) (, , ). (, =3>5, ܻ) 2 : ܻ ( , , ).
[] Microsoft Excel
Microsoft Excel . , . (), - .
Excel :
;
(, , );
();
();
.
ܻ
: ;
: ;
: ( , , Excel !);
: , , . , Excel . ܻ , , Excel ܻ 0, , −1 . ;
: .
: =(2;10). Enter, 1024. 2 10 (), 1024 .
, ():
[]
, Excel , . .
Excel:
_([_1; _2; ; _N])
, , .
. , () 3,1415, () . , , , Excel !
. sin(), cos() . .
, . ;.
, (, ), , , ( ).
[]
, , , (. . ). , , , . .
:
=;
;
/ ;
;
;
;
. .
, , .
[] ""
. Microsoft :
( , 30 ). .
: , ;
( , 30 ). ;
ר( , 30 ). ( , );
( , 30 ). ;
( , 30 ). .
:
1. , ( );
2. "";
3. . Excel =, , , , ( );
4. . Excel ;
5. , , , Ctrl, . Excel , ;
6. , Enter;
F4 F3 .
[]
[] .
, , . , : "", , , . .
3 :
1. ;
2. " ..." ;
3. "" > "";
[]
:
, . "" .
[]
:
[]
. 7- ( Office 2007 64). , ( , , ). , , . " ":
Excel ( ). ( "") (""), :
[]
"", , "". "" , , .
[]
( ) ( ). "+", ;
( ) . ;
[]
;
, "F4" , , ( );
"F3", ( );
- , . ;
"Tab" ( ), "Shift+Tab" ;
, Fx, ;
, "=(J1:J3)/(K1:K3)", , "", , "/", , "". ;
, . Tab, . Excel ( );
, "" "", "0" "", "" ( 1).
[]
[]
[] ,
:
(1; 2;...; 30) (1; 2;...; 30)
1 30 ( Office 2007 255) / . , / . "".
[]
(1; 2;...; 30)
( ) 1 30 ( Office 2007 255) ( , ). ""
[]
(; )
(""), , ("").
[]
=(1; 2;...; 30)
1 30 ( Office 2007 255) . ( ), .
[] ר
ר(1; 2;...; 30)
ר 1 30 ( Office 2007 255) , . , .
[]
()
pi = 3,1415...
[]
(1; 2;...; 30)
1 30 ( Office 2007 255) . , .
[] ר
[]
, , . , , ,
:
(; ; [_])
: , , .
: , . , " " (, " >=100 " , 100). (, "" , "") (, 300 , 300).
_: , , . , ( ). , , "" .
[] ר
. , , ר , . (">10", A1:A10), , 10. ר(">10", A1:A10), , 10.
:
ר(; )
: , , . .
: , . .
, "".
[] , ,
[]
: