Microsoft Excel
Excel 4.1 . . . . . .
4.1
.. | . . | ||||||||||
. . | 11.1 | 14.1 | 20.1 | 25.1 | |||||||
. . | 11.1 | 14.1 | 20.1 | 25.1 | |||||||
. . | 11.1 | 14.1 | 20.1 | 25.1 | |||||||
. . | 11.1 | 14.1 | 20.1 | 25.1 | |||||||
. . | 11.1 | 14.1 | 30.1 | 5.2 | |||||||
. . | 11.1 | 14.1 | 20.1 | 25.1 | |||||||
: |
. : , . , 25 %. , 50 %. , .
, .
.
, .
1 MS Excel.
2 .
3 A1:L11. : (. 4.1). ( ; ).
4.1
4 A1:L1. (. 4.2), .
4.2
5 2:4; B2:I2; 3:3; D3:E3; F3:G3; H3:I3; J2:J4; K2:K4; J11:K11.
6 , .
|
|
7 (. 4.3) A1:L1; A2:A4; B2:I2; J2:J4; K2:K4; L2.
4.3
8 , , (. 4.4):
4.4
9 5:10; 5:10; G5:G10; I5:I10 . . (. 4.5).
4.5
10 L3 L5:L11 . (. 4.6).
4.6
11 . . (. 4.7). .
4.7
12 , . Times New Roman; ; 14 (. 4.8).
4.8
13 B11; D11; F11; H11; J5:J10; K5:K10 : . 2 (. 4.9).
4.9
(. 4.10):
4.10
1 J5 .
2 . (), (. 4.11).
4.11
, CTRL B5;D5;F5;H5 (. 4.12).
4.12
(. 4.13) .
4.13
3 , 6:10.
4 B11 ( () 5:10). D11; F11; H11.
5 K5 .
6 . (. 4.14) (), .
4.14
, CTRL, B5; D5; F5; H5 (. 4.15).
4.15
(. 4.16) .
4.16
7 , J6: J10.
8 , .
9 : ( (B5 > 3; D5 > 3; F5 > 3; H5 > 3) ; K5 < 18; L3, , 5 = 18; L3, 25 %; 5 = 19; L3 50 %; L3 ; ( ) .
|
|
10 (. 4.17) Excel, :
= ( (B5 > 3;D5 > 3; F5 > 3; H5 > 3); (K5 < 18; $L$3; (K5 = 18; $L$3 * 25 % + $L$3; (K5 = 19; $L$3 * 50 % + $L$3; $L$3 * 2))); )
4.17
11 L5 . = $L$3 , L3, (. 4.18), , , (. 4.19).
4.18
4.19
12 L5 L6:L10.
13 L11 : =(L5:L10).
, 4.20:
4.20
.
1: . , (. 4.21). .
4.21
2: 5: 10. (. 4.22).
4.22
(. 4.23) , 2 5: 10.
4.23
.
3: , (. 4.24) .
4.24
(. 4.25) .
4.25
(. 4.26) ( ).
4.26
(. 4.27) .
4.27
.
4 . (. 4.28).
4.28
. (. 4.29)
4.29
: (. 4.30).
4.30
( ) (. 4.31, 4.32).
4.31
4.32
(. 4.33) .
4.33