...................................................................................................................................... 9
I. Excel
1. Excel
1.1. Excel
................................................................................................... 11
................................................................... 12
................................................................... 12
........................................................................................................ 13
......................................................................................... 14
.................................................................................................... 15
.................................................................................................. 16
............................................................................................... 17
...................................................................................................... 17
1.2. Excel
..................................................................................................... 18
.............................................................................. 20
................................................................................... 21
........................................................................... 22
.......................................................................... 25
........................................................................................ 27
.................................................................................... 28
..................................................................................... 31
................................................................. 36
1.4. Excel
....................................................................... 39
.................................................................................. 40
....................................................................... 41
......................................................................................... 42
..................................................................... 42
................................................................................. 43
|
|
2.
......................................................................................................... 44
......................................................................................... 45
..................................................................................... 46
................................................................................. 46
.................................................................................... 47
...................................................................................... 48
........................................................................................ 49
............................................................................................ 51
................................................................................................ 52
................................................................................................... 52
......................................................................................... 53
.................................................................... 55
.................................................................................... 57
..................................................................................... 58
........................................................................................... 60
............................................................................................ 61
........................................................................................... 62
............................................................................................ 62
.................................................................. 63
............................................................................. 63
................................................................................ 64
....................................................................................................... 65
...................................................................................................... 66
3.
..................................................................................... 67
...................................................................... 67
............................................................. 67
|
|
....................................................................................... 68
............................................................................... 68
........................................................................................... 69
.................................................................................... 70
, ....................................................... 70
.............................................................................. 71
........................................................................ 72
........................................................................... 73
............................................................................... 73
......................................................................................... 74
............................................................................................ 74
.......................................................... 74
................................................................................. 75
........................................................... 76
............................................................................. 77
.................................................................................. 78
.................................................................................................. 78
.............................................................................. 78
................................................................................. 79
........................................................................... 81
................................................................ 82
....................................................................... 82
........................................................................... 82
4.
................................................................................. 83
............................................................................................ 83
............................................................................................. 83
....................................................................................... 84
................................................... 86
............................................................................................... 87
................................................................................................. 88
4.3.
.............................................................................. 88
........................................................................................ 89
|
|
.............................................................................................. 90
................................................................................... 90
............................................................................................... 90
5.
...................................................................... 91
....................................................................... 91
.......................................................... 93
................................................................................. 94
........................................................................... 95
................................................................................... 95
................................................................................. 95
............................................................................................ 96
............................................................................................. 96
.................................................................................... 96
...................................................................... 97
................................................................................. 97
.................................................................................................... 98
........................................................................................................... 100
..................................................................................................... 101
..................................................................... 101
.............................................. 102
............................................................................ 104
................................................................................. 106
......................................... 108
.................................................................... 112
.................................................................... 113
........................................................................................... 115
....................................................................... 115
................................................................ 116
....................................................................... 116
....................................................... 117
|
|
............................................................................. 118
........................................................................................ 118
................ 118
......................................................................... 120
.............................................. 120
................................................................... 122
............................................................................. 122
-........................................................................................ 125
.................................................................. 126
............................................................................... 127
.................................... 127
................................................ 129
...................................... 134
........................................................................................... 137
.................. 138
II.
6.