.


:




:

































 

 

 

 





.

. , , .

 

, , (=), 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). . "", .

 





:


: 2015-10-19; !; : 737 |


:

:

, .
==> ...

791 - | 762 -


© 2015-2024 lektsii.org - -

: 0.051 .