.
MS Excel,
Microsoft Excel
1 Excel.
:
. . - () , . , , .
.
. ( [Esc]). [Enter] . " = " ( fx) .
1 MS Excel.
. () Microsoft (MS) Excel , , , , Visual Basic. 3 . ( ) ( " "), .
. . . 256 6553 6 ( Excel 16384) , 16 777 216 . , . (, , .).
, .
(, ) , . , , .
. , . , 4 .
( ) . , , , . , , , =4*B2*2!C3. " B2" , , "2!C3" 3 2.
|
|
|
(, 1). , ( ). , .
. , , $ , , $D$12, A$8, $B9. "$" .
() , . , . () , . . . Tab, Shift+Tab, Enter.
, . . - . ( [Enter], [Tab] ) . , , .
[Esc]
(, ) - Excel 2000, . 255 , VBA- , . , , , .
. , - , . , .. .
. , , Excel 2000 .
3.1.3.1 .
. ( ), , . , : Sheet1, Sheet2 ..
|
|
|
, , Sheet2. . . , , .
() . . .
3.1.3.2. .
Insert. :
- ;
- ( );
-
- .
. , Sheet17 . , , Chart1 .. ( Excel 4.0) Macro1, - Dialog1 .. Visual Basic, Module1. , ( ) , . , .
3.1.3.3 .
, , . Move or Copy . Move or Copy OK, . Create a Copy, , . , , Sheet1(2).
. , [Shift]. Move or Copy, .
3.1.3.4 .
, , . , Rename Rename Sheet. . Name , 31 , . OK, . : "[ ]"; ":"; "/"; "\".
3.1.3.5 .
. () . Format Row Column. . Column Width, , . . , 10 , Column Width 10. AutoFit Selection Column .
|
|
|
. . . , , , , . , . ( ), () () .
, . Excel 2000 , . , .
Excel 2000 , , . . ( ), .
3.1.4.1 .
() . , . ( ) , , ( ). , . , , [Shift] , .
(), . (), , , .
3.1.4.2 .
, , Undo Edit [Ctrl-Z]. , 11- .
Redo. , .. [Ctrl-Z] 11- .
- Repeat Edit. [F4] 12- .
|
|
|
3.1.4.3 .
, , Copy Edit. . , , [Enter]. . , , , , .
. [Ctrl-C] 8- .
, Cut Edit. 7- (), - [Ctrl-X].
3.1.4.4 .
, . . Edit Clear, :
All - ;
Formats - ;
Contents - ;
Notes - .
Clear Contents . . [Del]. , [Ctrl-Z], .
3.1.4.5 .
, . Format Cells, Cell Format. Format Cells. Number, . Category , . Format Codes: . Code: . Format Cells Sample:, , .
$ () ( ). % () ( ).
3.1.4.6 .
Excel , (4-, 5-, 6-). . Format Cells, Cell Format. Format Cells. Alignment. Horizontal : (Left), (Center) (Right). , .
. .
3.1.4.7 .
, . Format Cells, Cell Format. Format Cells Font. Font:, . , Windows.
Size () . Excel 10 . Font Style: (Regular), (Italic), (Bold) (Bold Italic). Underline ( ). Effects , (Strikethrough) (Superscript) (Subscript) .
|
|
|
(1-, 2-, 3-) : ( B), ( I), ( U ).
. , , .
, , (=), Excel 2000 . , , .
. : + (); - (); * (); / ().
, . . .
, Excel 2000 , . , Excel 2000 , .
3.1.5.1 .
Excel 2000 ( ), ( ). , (=).
, 1 100, 1 - 20. 1, 1 (=1/1) [Enter].
, . , .
3.1.5.2 .
.
| B | C | D | E | |
| $17.80 | $5.60 | |||
| $3.80 | $5.20 | |||
| $1.56 | $12.48 | |||
| $63.28 | ||||
| 15% | $9.49 |
( ), , D - , - , . 16 . : =12+13+14. 0,15, , 17: =16*0,15.
, (, 19) , 0,15. : =(12+13+14)*0,15. , 16 17. SUM(), : =Sum(E12:E14)*0,15.
3.1.5.3 .
, . , [F2] . ( ) , , .
3.1.5.4 .
Excel 2000 , . , , .
, , . , 3 Sheet2 : =Sheet2!B3. , () . . , ( [Ctrl-C]) , . Paste Special Edit Paste Link.
3.1.5.5. .
, . , , . .
Insert Name Define. Define Name . 255 . . (1 ..). , .
, . (), , , Create Insert Name. ( ) OK.
Define Name, , Excel () .
Refers to Define Name . , , .
. , , . , .
, (. . 2) "" 11, 12 13, , : =Sum(.
"". Excel . [Enter], .
, Excel . Excel 2000 , " ".
, . MS Excel 2000 - , .
.
Excel. . , , . .
