Excel
1
: 69, 85, 78, 85, 83, 81, 95, 88, 97, 92, 74, 83, 89, 77, 93.
1. 1 , 2:16 - .
2. 5 . 69 97 , 7 . 1 . 2:8 : 70, 75, 80, 85, 90, 95, 100.
3. : D1 , 1 , F1 .
4. . D2:D8, , , , 2:16, 2:8, Ctrl+Shift+Enter. D2:D8 .
5. D9 , .
6. . 2 =$D2/$D$9.
3:8. .
7. . F2 2. F3 =F2+E3. F4:F8. .
8. , 1.
A | B | C | D | E | F | |
0,067 | 0,067 | |||||
3 | 0,067 | 0,133 | ||||
0,133 | 0,267 | |||||
0,333 | 0,600 | |||||
0,133 | 0,733 | |||||
0,200 | 0,933 | |||||
0,067 | 1,000 | |||||
. 1.
9. . 1:F8, , , /2, . 2:8, . , , Y , . .
|
|
2.
. 2.
2
2 , .
1. 1 , 2:16 - .
2. 1 . 2:8 : 70, 75, 80, 85, 90, 95, 100.
3. , , Ok.
4. 2:16, 2:8, F1.
, Ok.
1.
1. 20 : 4, 4, 5, 3, 4, 5, 4, 5, 3, 5, 3, 3, 5, 4, 5, 4, 3, 5, 3, 5.
2. ( ) 20 : 181, 169, 178, 178, 171, 179, 172, 181, 179, 168, 174, 167, 169, 171, 179, 181, 181, 183, 172, 176.
3
, , : 26, 35, 29, 27, 33, 35, 30, 33, 31, 29.
1. 1:10 .
2. 11 , , .
3. 12 , .
4. 13 , . .
5. 14 , .
4
3 .
- 1:10 .
- , , Ok.
- 1:10, 11. , . Ok.
- .
, .
.
, . -1 1. 0.
.
|
|
.
. (/3): 12, 16, 15, 14, 10, 20, 16, 14, 18, 14, 15, 17, 23, 16. .