.
. → → , , , .
( , , ).
1. .
, . ϳ Format Cells, Cell Format. - ' Format Cells. Number, . Category , . Format Codes: . Code: ' .
Format Cells Sample:, , .
ϳ $ () ( ). ϳ % () ( ).
2. .
Excel , (4-, 5-, 6-). . Format Cells,
Cell Format. - ' Format Cells.
Alignment. ϳ Horizontal : (Left),
(Center) (Right). , .
. .
3. .
, . ϳ 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 ).
. .
, , .
, , . , - .
, Enter. .
'.
, .
, Delete
. , 볻, - .
() .
, , . , . ?? .
. .
. .
, , . .
, . , , .
|
|
. , .
. , .
1. .
- .
2. .
,
, , . 56- , .
,
, , .
3. .
ϳ .
, .
, ,
ͳ. .
, , , .
, , . , ' , , .
, . , . , ͳ
.
4. .
. . . , , ' . , - ³, . ³ .
( , ' , , ).
1. .
MS Excel , 8,43 . . , , . . . , .
MS Excel , . , .
|
|
.
2. ' .
ѳ . , , . Excel , , . ' , . ' . . , , .
3. .
- , .. Excel . , . - .
, , . ϳ
- .
, , ' .
. .
1. .
䳺 . ,
, .
, ,
, : . ϳ . ³ , , , .
, . ϳ Delete. '
. "OK". , , ʻ. , , .
2. .
,
. Excel - , , , , , . , , . ϳ . , , , , . , .
|
|
. . , .
. , , .
, , (=), Excel . ϳ , , .
.
: + (); - (); * ();/().
, . - .
.
, Excel , . , Excel , .
1. .
Excel
( ),
( ). ,
=.
, 1, 100, 1
- 20. 1, 1 (= 1/1) Enter.
, . ϳ , .
2. .
.
| | B | C | D | E |
| 10 | | | ֲ | |
| 11 | | 2 | $ 17.80 | $ 35.60 |
| 12 | | 4 | $ 3.80 | $ 15.20 |
| | | | | |
| 13 | ϳ | 8 | $ | $ 12.48 |
| | | | 1.56 | |
| 14 | | | | |
| 15 | | | | |
| 16 | | | | $ 63.28 |
| 17 | 15% | | | $ 9.49 |
.1.
, ( ), , 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. .
, . , F2 . ( ) , , .
Excel. : , , .
MS Excel , . .
:
= (_; __; __)
|
|
.
, - .
ֳ : =,, =, . 30 :
= (_1; _2;.....; _30)
= (_1; _2;.....; _30)
, , .
ij. , .
, Excel . ' Excel , .
, . MS Excel 5.0 ' - , .
.
Excel. . , , . .
1. .
, , . " , 17- .
,
. , . , , , . , Insert Chart As New Sheet.
ϳ , ' . , , . , .
,
Next . , . (') ' , ( ), . Finish, ' .
2. .
Format ' Chart Type. , .
. , Chart. ' . . , , , .
3. ?? '.
Insert , . ,
Picture,
(BMP, PCX ..). ϳ . ' , . .
, , . Enter. ' , , .
Drawing, . Toolbars View.
4. .
, , Excel .
, . . , , . , (). Microsoft Drag & Drop Drag & Plot.
, New Data Insert. , . , . OK, . , Undo Edit.
.
Save As
File. , Options. ' Save Options. Protection Password": , . ' . ϳ Save Options Confirm Password, . Write Reservation Password, ' , Read Only. ,