, . , . . , Þ (Format Þ Ceels) < Ctrl + 1>. .
:
* . . :
;
;
;
ᒺ . , . Excel 97.
: , , , , . .
. , .
, , . . .
. . (Borders) .
Excel . . Þ (Tools Options) (View) ѳ (Gridines).
* . (Fill Color) , (Font Color) .
ϳ Excel 97:
, . , Þ (Data Þ Validation) , . , , , .
|
|
. Þ . Գ 䳔 (Fixed Decimal) , . , Excel , .
. Excel :
< Ctrl +; >.
< Ctrl + Shift +; >.
, . , , , , . Excel :
, , , < Ctrl + Enter >;
, ;
Excel , , . , (Pick from List) , , ;
(AutoCjrrect) . Excel .
:
< Enter > , Þ (Tools Þ Options) (Edit) (Move Selection after Enter);
- (, , , ¯);
< Enter > . < Enter > . < Shift + Enter >. < Enter > < Tab >.
< Alt + Enter > Þ . .
. , , 0, , , / (), < Enter >. Excel .
, . , , ( ). - Þ (Data Þ Form). , .
|
|
Excel, ( ). , . . Þ 糓 (Sheets in New Workbook).
䳿: (), , .
. . . , Excel :
< Ctrl + PgUp > , .;
< Ctrl + PgDn > , .
. Excel :
Þ (Insert Þ Worksheet).
< Shift + F11 >.
, , (Insert). (Insert), (Worksheet).
, , < Ctrl + Y > Þ (Edit Þ Repeat Insert Worksheet).
ϳ - .
. :
Þ (Edit Þ Delete Sheet).
, , (Delete).
, , . , < Ctrl >, , . . , , < Shift > .
. .
. 1, 2, (Sheet 1, Sheet 2, ). , :
Þ Þ (Format Þ Sheet Þ Rename).
.
(Rename).
31 . , , ] , : , / , \ , ? , * .
. Excel :
Þ / (Edit Þ Move or Copy Sheet).
.
. :
|
|
Þ / (Edit Þ Move or Copy Sheet) (Create a Copy).
, < Ctrl >, .
. Þ Þ (Format Þ Sheet Þ Hide) Þ Þ ³ (Format Þ Sheet Þ Unhide) .
ʳ . . ³ Þ (Window Þ New Window). Excel . Excel : , .
, (, ).
. . ³ Þ (Window Þ Split) , .
, ³ Þ (Window Þ Remove Split), , .
. , . , , ³ Þ (Window Þ Freeze Panes). ³ Þ (Window Þ reeze Panes).
. Excel (65 536 ´ 256 Excel 97), . ( ) , . .
, , . . :
Þ (Insert Þ Rows) Þ (Insert Þ Sells);
, , (Insert);
< Ctrl+ + >.
, Þ .
Þ (Insert Þ Sells), .
. , , :
* Þ (Edit Þ Delete);
, , (Delete);
< Ctrl+ - >.
.
|
|
, , :
* Þ ³ (Edit Þ Undo);
* < Ctrl + Z >;
* ³, .
. , . 8,43 ( Þ Þ ). , :
;
Þ Þ (Format Þ Column Þ Width) (Column Width);
, , , , ;
Þ Þ (Format Þ Column Þ Autofit Selection). ;
, .
. ( ). Excel , . , , . , ( < Alt + Enter >). :
;
, Þ Þ (Format Þ Row Þ Height) , , ;
, , , , .
. :
Þ Þ (Format Þ Row Þ Hide) Þ Þ (Format Þ Column Þ Hide);
: , ;
.
. , , Þ Þ ³ (Format Þ Row Þ Unhide) Þ Þ ³ (Format Þ Column Unhide).
Þ (Edit Þ Go To) < F5 >, - , .
(Cell) , , . , .
ij (range) . , , .
. , . :
, , ;
< Shift > ;
< F8 > . < F8 >;
Þ (Edit Þ Go To) < F5 >, (Go To) ʔ.
|
|
. , :
;
() ( ) , , , ();
() , < Ctrl >, ( );
(), < Ctri + > (< Shift + >);
(Select All), , < Ctri + Shift + >.
. . Excel , , , . (multiple selection). :
* < Ctri >, ();
* < F8 > < Shift >, < Shift + F8 >, , ;
* Þ , ;
* , , ( ), , < Shift > , < Ctrl >, .
. Þ (Special), (Go To Special). ( ), Excel .
. () , . , Þ (Insert Þ Comment) < Shift + F2 >. - , . . , .
: < Delete > Þ (Edit Þ Clear).
. . :
;
;
(!).
, ( ). .
, , :
a) ( ) ( ) .
b) , ( ), . ij , .
, Excel - , . , , Þ ³ (Edit Þ Undo Paste), < Ctrl + Z >, ³ .
Windows. , , , Windows. . Windows, - Windows -, .
:
. (Copy) (Paste). ( ) , ( ). .
. Þ (Edit Þ Copy), Þ (Edit Þ Paste).
. () , , (Copy). ( ) (Paste).
. < Ctrl + C >, < Ctrl + V >.
. (), ( ) , < Ctrl > , ( ).
. (). Excel . () :
à Þ Þ (Edit Þ Fill Þ Down) . < Ctrl + D >;
à Þ Þ (Edit Þ Fill Þ Right) . < Ctrl + R >;
à Þ Þ (Edit Þ Fill Þ Up) ;
à Þ Þ (Edit Þ Fill Þ Left) .
.
. , .
. Þ (Edit Þ Paste Special) (, , , .), , , . , . .
, , . .
Excel , . . , , , .
, _, ., \, ?. , , 255 .
:
* Þ Þ (Insert Þ Name Þ Define) . , . ʔ (Add), . = . ʔ < Enter > .
* , , < Enter > .
Excel
Excel ( ) , . , . , , ( , ). , . , ( ), , , . , , . , , , .
1 024 . , . . = . Excel .
Excel :
( + , - , * , / , ^ ). .
( & ). ᒺ .
( = , > , < , >= , <= , < > ). (true) (false).
:
I. ^ ;
II. * , / ;
III. + , - ;
IV. & ;
V. = , > , < , >= , <= , < > .
. . , , . , , , .
Excel ( )
Excel , . ( (SUM), (AVERAGE), (SQRT)), , , , . , . Excel VBA. Excel .