MS Excel 1
:
MS Excel. . , ..
1.
, ( ). (. 1).
.1. B3
2. ij
ij . ij . B2:D6 (. 2). (2).
.2. ij B2:D6
, Ctrl (. 3)
. 3. ij A1:B2 B4:B6.
3.
. =. :
=1+2 ( , 1, , 2)
=5+4 ( 5 4)
ϳ = 1 , + 2.
, , . , , . (. 4).
. 4. 4 , 1 2. 4
4.
.
/ , (. 5).
. 5.
, / . , .
ij, , , , :
, (. 6)
. 6.
, . 2. 2. 1, 3. . (. 7).
. 7.
, / . , (. 8).
|
|
. 8.
, , , (. 9).
. 9.
, 1 2 1 2 .
, 1 2 2 3 .
, , .
:
=A1+$A$2
2 . , 2 F4.
, 1 1, 2 (. 10).
. 10. ,
5.
MS Excel , , .
, . , . , , , . :
=(1:3) , 1, 2 3
=(1:3) , 1:3
(, ), (. 11).
. 11.
MS Excel . , Insert/, Chart/(, ), Chart Wizard/ ( ). Chart type/ () Standart Types/ (), Custom Types (). Chart sub-type/ () .
MS Excel : Column charts (ó), Bar charts (˳ ), Line charts (), Pie charts ( ), XY (Scatter) charts ( ), Area charts (ij ), Doughnut charts (ʳ ) .
, , , , . , .
(Data Series/ ) , , , , . . .
(Series in/ ) , : (rows/), (columns/). Data Range/ Range/ Source Data/ ( ). ³ , .
|
|
(Chart Area), (Plot Area).
(Data Point/ ) - .
(Marker/) (, , , ). , Format Data Series/ ( ) , View/ () Marker/ () Custom/ () (Style/ ), (Foreground/), (Background/), (Size/), (Shadow/).
(Legend/) , . , .
(Category/) . , . Legend/ () Chart Options/ (( ). Legend/ () Chart/ ((ij). <Delete> Legend/ () Chart/ (ij).
: Bottom/, ; Corner/ ; Top/, ; Left/, ; Right/, ; Placement/ () Legend/ () , Chart Options/ ( ) .
(Tick mark/) , , . , Chart Options/ ( ) , Title/ () Chart Title/ , Category(X) Axis/ (), Value (Y) Axis/ () X Y , Legend/ () Show legend/ ( ).
, ' , ', Drawing (). Gridlines/ (˳ ) Chart Options/
( ) , (Major/) (Minor/) .
' Format/ (), Format, Select object/ , (, ') Format/ () '.
MS Excel (X) (Y), ' (X), (Y) (Z). Axes () Chart Options/ ( ), Chart, Chart Options/, (ij, ).
|
|
, . Patterns/ () Format Axis/ ( ), Format Axis/ ( ). (Inside/), (Outside/) , (Cross/ ). ̳ (Tick mark labels/ ) (Next to axis/ ), (Low/), (High/), (None/).
Scale () Format Axis ( ) (X) (Y), (Minimum/ , Maximum/ ), (Major Unit/ , Minor Unit/ ).
(Data Labels/ ), , (X). Data Labels (ϳ ) Chart Options ( ). , Format Data Series/ ( ) , Data Labels/ (ϳ ) Data Labels/ (ϳ ) Show Label/ () Show legend key next to Label/ ( ).
, ' Patterns/ (). , , , Patterns/ () Format Data Series/ ( ), Format, Selected Data Series/, (, ).
, , , Font () Format ().
, , Alignment/ () Format/ ().
Number/ () Format Axis/ ( ), Format Axis/ ( ).
' Format AuloShape/ ( ), Format, Selected Object/, (, ').
ᒺ Chart, 3-D View/, (ij, ᒺ ). (Elevation/), (Rotation/), (Perspective/), (Z) (X) (Height % of Base/ % ), 90 (Right Angle Axis/).__
1
1.
|
|
1 , . , .
2 .
1, 2, 3, 4 25; -10; 12,25; 0,001.
1 .
2 .
2.
D1:D20 1 20.
1:20 5.
F10:F20 .
G1:G12 .
3. 2 :
:
;
C2, D2, E2, F2 , ;
( "?") ;
A22 F22 , .
4. F2:F22 , 2.
, => => => => => 2.
:
"..." - -
"?" -
:
' 1:F1. " "
' .
' : A2:A3, B2:B3, C2:F2.
"% " ( B7:F7) . , "", "", "", "".
- ( ).
:
³ = -
% = /
" " :
:
=(3:F3) -
" " "% " : /
" " " " . , . ij .
.
"", "".
"" "".
" " " " "" C4:F5. "", 4 , , F5.
""
"" " " ( ). . "".
3. " ". , , . .
4. :
5. 15 . ³ ( 2 14) .
6. "" , 2 . :
"", "", "", " ".
7. ̳ "" "³" "" "", "³" "" - "". .
8. "". "", " ". .
9. ( "", "").
.