. Excel
: Excel. . (4 .)
Excel Microsoft Office. Excel Windows , .
Excel , , , . , , :
, ;
, , Windows;
( , ..);
Microsoft Office;
, , ;
, ;
"" ;
(, , , , , .);
, ;
Excel, Windows : [Clipboard], [ D ynamic D ata E xchange] (DDE), [ O bject L ink E mbedded] (OLE) ( );
. , Visual Basic;
(, , , , ..), ;
- [Slides-Show] , , ;
[Scenario Manager];
[Master Wizard] [Help].
Excel Windows.
Excel :
XLS (Sheet);
XLC (Chart);
|
|
XLW Excel 4.0 (WorkSheet);
XLM (Macro);
XLT (Template);
XLA (Add-Ins);
XLB (Tools Bar);
XLL (Library).
Excel. Windows, , .
Excel 2007 : , , , , (. . 1.1.)
, Word, , Excel [Worksheet], , .
. 1.1. Excel
:
. 16384: A, B, C,..., Z, AA,..., AZ, BA,..., BZ,..., XFD;
. 1048576 ;
. , 17 179 869 184 ;
. [Book] ;
. ;
, ;
. ;
, .., ( 1, 2,...) (Sheet1, Sheet2, Sheet3,...) "" "" , . , Windows. :
[Insert]. ;
[Delete]. ;
[Rename]. ;
/ [Move or Copy]. , ;
[Select All Sheets]. .
.
. (. . ) . , . :
-. (, ,..., IV), (1, 2,... ). , 1 , 1. ;
($), $A$1, F4. . , , ;
|
|
$A1 ( F4), A$1 ( F4). . , , - , , ;
-. , , . : R, , , . R1C1 Microsoft Excel R, , C, . , R1C1 , ( 1).
R1C1 . , . Visual Basic (VBA).).
R1C1, Microsoft Office , Excel, R1C1.
. Excel (. 1.1.).
1.1. Excel
/ | ||
, , , | , , , | |
() | Home | |
() | End | |
PgDn | ||
PgUp | ||
Ctrl + Home | ||
Ctrl + End | ||
() | Ctrl + | |
() | trl + | |
() | Ctrl + | |
() | Ctrl + | |
Ctrl + PgDn | ||
Ctrl + PgUp |
. , (. 1.2.).
.
, (), , . , .
, ! , , . 1.2., .
1.2. Excel
/ | "" | ||
Drag&Drop | Shift | ||
Drag&Drop | Shift | ||
, | Drag & Drop | , F8 , , | |
Enter | |||
1. . 2. Ctrl , . 3. Ctrl. 2-3 , | 1. . 2. Ctrl . 3. Shift, . 4. 2-4 , | ||
1. "" | Ctrl+A |
|
|
. ( [Del] ), [Copy] [Edit] ), ( [Cut] ), ( [Paste] ), ( Drag&Drop) .
( () ) () , , . (, : , , . .).
. . ( ) .
. , :
. ( ) , Drag&Drop , . , ;
Excel. [Format], [Column], [Width]. [Column Width]. . [Row] [Height].
[Standart] .
, , [AutoFitSelection] .
, , , . , , . .
|
|
. ( () ) , [Format Cells] , [Alignment], [Fill].
. , , . . , :
[Numbering]. :
[Category]. (, , , , , ..);
[Format Codes]. . , :
# ##0
# ##0,00
P.;_# ##\_P_.
, :
[Code]. ;
[Sample]. ;
[Alignment]. . :
[Horizontal]. : [General], [Left], [Right], [Fill], [Justify], [Center across selection];
[Vertical]. : [Top], [Center], [Bottom], [Justify];
[Orientation]. : ; ; , ; , ;
[Wrap]. ;
[Font]. ;
[Border]. () ;
[Pattern]. : , , , ..;
[Protection]. , . , .
.
, , .
. () . .
1. .
2. , .
3. "" Enter.
4. , . 13 .
: , . ., . (, , ) , Excel (. . 1.2.) .
. [Save] [Save as] [File].
. [Open] .
. . [View]. "" [Gridines] ("" ). OK, , . "" .
|
|
. () [Print] . ( [Print Setup]), ( [Page Setup]). [Print Preview]. :
[Next] , ;
[Previous] ;
[Zoom] ( ). , ;
[Print] ;
[Setup] ;
[Margins] , , Drag&Drop;
[Close] ;
[Help] .
. :
( ) | 30% | ( ) | |
.
1. C1 . :
2. Enter
3. A3 :
4. B3 :
5. B4 : ( )
6. E3 :
7. E4 : 30 %
8. G3 :
9. G4 : ( )
10. :
B6 600000; E9 61740;
B7 420000; E10 43218;
B8 294000; G6 420000;
B9 205800; G7 294000;
B10 144060; G8 205800;
E6 180000; G9 144060;
E7 126000; G10 100842.
E8 88200.
, . 1.2.
. 1.2
, . Excel . , Excel .
( B6) ( E4). :
i = ( )i * ,
( ) i = ( ) i i,
( ) i+1 = ( ) i .
B13 600000. E13
=B13*E4.
E13 180000. G13
= B13-E13.
420000. , , B14
= G13.
420000.
. , , , , . E13. E4 . . . , :
= B13*$E$4.
E13:G13. , , . B14. .
. , . 10% ( ).
A13:A14 1, 2. . . A13:A14 , , . A13:A17 , .
, . Excel, , .
. , .
.
, .
, .
, , .
, .
E13
= B13*($E$4+(A13-1)*0,1).
E13 E14: E17. , .
.1.3
. , (. ), (. ), .
. : , (. 7.1). , , .
7.1.
, , , .. .
, .. . , , . , b , (), . .
,
n ( n = 6).
:
1. . 7.8;
2. b D2 2.
,
. 7.8.
b y = + b (SLOPE) (INTERCEPT).
(SLOPE) , (INTERCEPT) .
:
(__; __)
(__; __)
__ ;
__ .
__ , , {1; 2; 3;...} , __.
:
,
,
.
D3 3 (. 7.9) b, ,
= (B2:B7;A2:A7)
=3(B2:B7;A2:A7)
. 7.9.
, , :
1. 2
=$D$3*A2+$E$3
2. 2, C3:C7 (. 7.10).
. 7.10. ,
(FORECAST), , .
:
(; __; __)
, ;
__ ;
__ . __ , {1; 2; 3;...} , _.
2
=(2;$B$2:$B$7;$A$2:$A$7).
F2 F3:F7 (. 7.11).
. 7.11.
(TREND) , . :
.
:
( ; _ _; ; )
__ ;
__ . __ , , {1; 2; 3;...} , __;
__ , . ;
, , , b 0. , b . , b 0.
, __ __ ( ) . __ , , __.
7
={($B$2:$B$7;$A$2:$A$7;A10:A12)}
( <Shift>+<Ctrl>+<Enter>) (. 7.12).
. 7.12.
(LINEST) { mn, , m1, b } .
:
(__; __; ; )
v __ ;
v __ . __ , , {1; 2; 3;...} , __;
v , , , b 0. , , b . , b 0;
v , , , . , . , .
. MS Excel , . (. 7.2).
7.2.
y = mx + b , b | |
y= c ln x + b c b | |
y = c6 x6 + + c1 x + b 6,..., 1 b | |
y = c xb b | |
= c e bx b | |
(). , , , |
. , , .
, , , .
, . :
1. 2:7 .
2. , → . .
3. . (. 7.13).
. 7.13.
4. (. 7.14). , , . , . (R^2), , .. . . 0,9 1, . , . 1, . Y , . , 0, , y = bx.
5. .
. 7.14.
. 7.15. 0.9723. , .
. 7.15.
,
= c ebx.
(GROWTH).
:
(__; __; __; )
__ . ;
__ . __ , , {1; 2; 3;...} , __;
__ , ;
, , , b 0. , b . , b 0 (. 7.16).
. 7.16.
, (LOGEST).
:
(__; __; ; )
__ . ;
__ . __ , , {1; 2; 3;...} , __;
__ , ;
, , , b 0. , b . , b 0;
, , , , . , . , .
, . .
. .
0.947 . , .
Excel 2007 (. 7.17) .
. 7.17.
(. 7.18).
. 7.18.
(), (. 7.19).
. 7.19.
. 7.20.
. 7.20.
(. 7.21).
. 7.21.