.
. , , .
, , (=), Excel . , , .
. : + (); - (); * (); / ().
, . . .
, Excel , . , Excel , .
.
Excel ( ), ( ). , (=).
, 1 100, 1 - 20. 1, 1 (=1/1) [Enter].
, . , .
.
, . , [F2] . ( ) , , .
.
Excel , . , , .
, , . , 3 Sheet2 : =Sheet2!B3. , () . . , ( [Ctrl-C]) , . Paste Special Edit Paste Link.
|
|
.
, . , , . .
Insert Name Define. Define Name . 255 . . (1 ..). , .
, . (), , , Create Insert Name. ( ) OK.
Define Name, , Excel () .
Refers to Define Name . , , .
. , , . , .
, "" 11, 12 13, , : =Sum(.
"". Excel . [Enter], .
.
, Excel . Excel , " ".
, . MS Excel 5.0 - , .
|
|
.
Excel. . , , . .
.
, , . (ChartWizard), 17- .
, . , . , , , . , Insert Chart As New Sheet.
, . , , . , .
, Next . . () , (.. ), . Finish, .
.
. 5.1. , .
Format Chart Type. .
. Chart. . . , , , .
.
, . Titles Insert. , . , Chart Title, Value (Y) Axis Category (X) Axis. .
Value (Y) Axis , Y. . , . , . , .
.
Insert , . , Picture, (BMP, PCX ..). . , . .
|
|
, , . [Enter]. , , .
Drawing, . Toolbars View.
.
, , Excel . , . . , , . , (). Microsoft Drag & Drop Drag & Plot.
, New Data Insert. , . , . OK, . , Undo Edit.
.
. , Excel 200 , .
, . . .
, , ; . , , . , . . .
.
, . 14- ( fx) .
, - , . , All .
|
|
, . . . , Next.
. , , () . , , , . .
, Back, . , Value , . Finish, .
, . .
.
, . Editing Function.
, . , , , . Finish.
, , , . , . , . ( X, "" fx).
, , . . , . "" , .
.
, , 13- .
"SUM", , . Excel "" , "".
, . , [Ctrl]. , .
. , , - ( , International Windows). . "", .