0
, :
, . | , . | , . |
. , , , . 3 - 4 . , , , , . (: 3,2 . 6 .). .
. , . , . , .
15 , .
. .
.
1. , , , .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , ., . , . Ȼ, , . - Ȼ.
5. .
6. .
7. : , , , , . .
8. , , . .
9. .
10. .
11. .
12. .
13. .
14. .
15. 7. 8.
|
|
16. (), () :
, . | , . | |||
/ * |
* .
1
, :
- - | , . | - |
. , , , ; - , , . 3 - 4 ( , 3 - 4 ). . . 10% 20%
. , . , . , .
15 , .
. .
.
1. , , . : , , .
2. Excel 2007 , .
3. , , ( ).
4. , , , . Ȼ, - Ȼ.
5. .
6. .
7. : , , , .
8. , .
9. . .
10. .
11. .
|
|
12. .
13. .
14. , .
15. 7. 8.
16. (), () :
2
, :
, . | , . | , . |
. , , , . 3 - 4 . , , , , . (: 320 . 700 .). , . , . , ..
. , . , . , .
15 , .
. .
.
1. , , . : , , .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , ., . Ȼ, , . - Ȼ.
5. .
6. .
7. : , , , , . .
8. , , . .
9. . .
10. .
11. .
12. .
13. .
14. .
15. 7. 8.
|
|
16. (), () :
, . | |||
3
, :
, . | , . | , . |
- . , , , . 3 - 4 . : , , , . . , 200 . 450 . , . , . , ..
. , . , . , .
15 , .
. .
.
1. , , , ., .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , . , ., . , . Ȼ, , . - Ȼ.
5. , ..
6. .
7. : , , , , . .
8. , , . .
9. . .
10. .
11. .
12. .
13. , . .
14. .
15. 7. 8.
16. (), () :
, . | |||
4
|
|
, :
, . | , . | , . |
. , , , . 3 - 4 . , , , , . . , 10 . 20. . .
. , . , . , .
15 , .
. .
.
1. , , , ., , .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , . , ., . , . Ȼ, , . - Ȼ.
5. , ..
6. .
7. : , , , . .
8. , , . , .
9. .
10. .
11. .
12. .
13. , . .
14. .
15. 7. 8.
16. (), () :
, . | ||
5
, :
, . | , . . | , . . |
(: 1, 2, 3). 3 - 4 . , , , , . . , 2 . . 6,5 . . .
. , 1- 2- . , . , .
15 , .
. .
.
1. , , , . .. , .
|
|
2. Excel 2007 , . ., .
3. , , ( ).
4. , , , . ., . Ȼ, , . . - Ȼ.
5. .
6. .
7. : , , , . . .
8. , , . . .
9. . .
10. .
11. .
12. .
13. .
14. .
15. 7. 8.
16. (), () :
1 | 2 | |||
, . | , . | |||
6
, :
, . | , . | , . | , . |
. , , , . 3 - 4 . , , , , . (, 12 . 24 .). -, . , .. .
. , . , . , .
15 , .
. .
.
1. , , , ., , .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , ., . Ȼ, , . - Ȼ.
5. , ..
6. .
7. : , , , , . .
8. , , . , .
9. .
10. .
11. .
12. .
13. , .. .
14. .
15. 7. 8.
16. (), () :
, . | |||
7
, .
, . | , . | , . |
. , , , . , -. -, -. . , 12 . 25 . , , . , ..
. , . , . , .
15 , .
. .
.
1. , , , . .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , . , . , . Ȼ, , . - Ȼ.
5. , ..
6. .
7. : , , , . .
8. , . .
9. . .
10. .
11. , .
12. , . .
13. .
14. .
15. 7. 8.
16. (), () :
- | - | |||
8
, :
, . | , . |
. , , , . 3 - 4 . , , , , . . , 20 . 300 . , . , ..
. , . , . , .
15 , .
. .
.
1. , , , ., .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , , ., . Ȼ, , . - Ȼ.
5. .
6. .
7. : , , , , . .
8. , , . .
9. . .
10. , . .
11. .
12. .
13. .
14. .
15. 7. 8.
16. (), () :
9
, :
, . | , . |
. , 1, 2, 3. 3 - 4 . , , , , . . , 200 . 300 . , . , ..
. , . , . , .
15 , .
. .
.
1. , , , ., .
2. Excel 2007 , ., .
3. , , ( ).
4. , , , ., . Ȼ, , . - Ȼ.
5. , ..
6. .
7. : , , , , . .
8. , , .
9. .
10. , . .
11. .
12. .
13. .
14. .
15. 7. 8.
16. (), () :
1 | 2 | |||
[9]
, . , Excel 2007. .
Excel, , .
(Absolute reference) , , . $A$1 1. $A1 . A$1 - . , .
(AutoComplete) , , .
(Formula AutoComplete) Excel, , , .
(AutoFill) .
(AutoSum) , .
(AutoFormat) - , , , .
(Active workbook) . .
(Active cell) .
(Active worksheet) . .
- (What-if analysis) . (Scenario Manager) (Data Input), Excel, .
(Argument) , (Function). , , . , , , , .
(Database) , () () (). .
(Running Frame) - , . , ESC.
Office (Office Clipboard) 24 Office. , Office, (Windows Clipboard).
(Redo) , (Undo).
(Header) , . .
(Precedent cell) (), .
(Nested function) , .
(Embedded chart) , Excel, .
(External link) - Excel .
(Selection) . , , .
(Pointing) .
(Expression) - , , , , .
(Calculated field) - , . , .
(Computed column) - Excel , . , .
(calculated item) - , . , .
(Group) - , .
(Command group) , .
(PivotTable data) - , .
(Chart) - . .
(Dialog box) , , . .
(Range) . , .
(External data range) , , Excel, .
(Live Preview) - - .
(Column heading) - , .
(Locked cell) ( ).
(Dependent cell) , .
(Print titles) - / , .
(Value) , . , .
(Error value) , #, , .
(Protected) - , , .
(Protected workbook) , .
(Protected worksheet) , , .
(ID) - , . , () , . (, *).
(Data source) - , . , , , .
(Source data) - , . Excel, .
(Source areas) - , . , , Lotus 1-2-3.
(Totals) - , . .
(Legend keys) - , , ( ) . . .
(Workbook) Excel. .
(Option button) . .
(Gallery) , .
(Split button) , . , ( ) .
(Ultimate area) - , . , , . .
(onstant) - ( ) . .
(Contextual tab) , (, , ).
(Contextual menu) - , , , .
(Ccriterion of Comparison) - , .
(Legend) - , .
(Ribbon) Excel 2007, , , .
(Gridlines) , . . .
(Cheet) - . , .
(Chart sheet) , . .
(An array) - , , . ; , .
(Data marker) , , . .
(Fill handle) , . .
Office (Office Menu) , Excel.
(Add-in) , Excel .
(Noncontiguous range) , , . Ctrl.
(Footer) - , . .
(Pane) , .
(Diagram Pane) - .
(Paste area) - , Microsoft Office .
(Data area) - , .
(Task pane) , , , / Office.
(Value area) - , . , .
(Copy area) - -, . , , .
(Print Area) , . , .
(Scope of the PivotTable lis) - , . .
(Criteria pane) - , , , .
(Update PivotTable report) - . , .
(Merget cells) , , . .
(Restrictions) - , , , .
(Watch Window) , , .
(Operator) , . , .
(Range Finder) , , . .
(Axis) - , , . Y , . X , .
(Dialog launcher) , , .
(Undo) (Undo) Ctrl + Z.
(Relative reference) . ( ) .
(PivotTable report) , .
(PivotChart report) - , , . , , , .
(Quick Access toolbar) , .
(Password) - . , , .
(Radio Button) , , . .
(Recalculate) , , .
(Drag) .
(Drag-and-drop) , . , .
(Goal seek) - . , , , .
(Data labe) - , .
(KeyTip) - , , , , .
(Margin) , .
(Field) , , .
(Name Box) - , . , . , , .
(Field values) - , , .
(Field drop-down list) - , , .
(Provides a PivotTable report) - , . , , . , , .
(Column field) - , . , , .
(Scroll bar) , () .
(Sort order) - . , . .
(Cell comment) , .
(Operator precedence) .
(Data validation) , .
(PivotTable subtotals) - , .
(Worksheet) , . . .
(Page break) , , .
(Drop-down list box) , . , .
(Enhanced ScreenTip) , . , .
(Page Layout View mode) , .
(Auditing) .
(Data series) , ; , , .
(Link formula) , .
C (Associated PivotTable report) - , . . .
- (Smart Tag) , , , . .
(Mixed reference) ($A1), (A$1). , , ,