4 1 4 (1) (2) (3) (4)
1 4 2 (1) (B4:B6) (2) (B12:B14) (3) 1 (D4:H4) D5:H243 (4) 240 20 (B8:B10) (5) 240 (B8) 0 1
4 3 2 2.1 2 Excel 2 (A1:A14 D3:H3 B4,B5,B6) B5 0.035
4 4 2.2 3 1 1 B12: =B5+1 B13: =B12 (1/12) 12 B11 12 B14: =B13-1 B13 B14 B13 1
2.3 1 4 5 4 1 4 1 := + := D4 1 1 E4: =B4 1 F4: =E4*$B$14 ( ) B14 B14 G4: =$B$6 B6 B6 B6 H4: =E4+F4-G4 +
2.4 2 4 6 5 2 D5: =D4+1 1 E5: =H4 1 F4:H4 F5:H5 3 2 243 240 D5:H5 D6:H243
4 7 2.5 240 6 240 B8: =$H$243 240 : 20 B9: =SUM(G4:G243) : 240 G B10: =SUM(F4:F243) : F
2.6 4 8 dd ddd ddd dd ddd ddd dd ddd ddd dd ddd ddd dd ddd ddd d ddd ddd d d dd ddd ddd ddd ddd ddd 7 (1) D3:H243 (2) ( ) (3) (4) : :
4 9 2.7 240 0 8 240 0 (1) B4 (B5) (2) (B6) 240 (B8) (3) 240 0 240 240 : : 240 0
4 10 2.8 ( (1) What-If (2) : B8 B8 : 0 0 : B6 B6 144,285 240 0 2500 3.50% 144,285 20 (1200 : :
4 11 2.9 4-1 240 (1-1) 2000 1 (1-2) 2000 6 (1-3) 3000+ ) 1 +1 % (1-4) 1%, 100,000 240 (1-5) 2%, 100,000 240 (1-6) 100,000 1%,2%,...,10% 240
4 12 3 B7 6 B6 B7 3.1 (1) (2) (3) [OK] (4) (2) 3.2 B7 300000 30 6 2, 8, 14, 20, 26,... 6 12 5 5 12 6 2 6 2
3.3 4 13 9 mod mod(n,m) n m mod(11,6) 11 6=1...5 5 mod(,6) 2 =if (, G4 =IF(MOD(D4,6)=2,$B$7,$B$6) : G4 : G5:G243 9
3.4 4 14 240 0 240 0 3.5 4-2 240 (1) 3000 3.5% 10 (2) 5% 10 (10 + 3 100) 3.6 4-3 2 12 1 11, 23, 35,... 3.7 4-4 3 2000 3% B7) (B6) 2 B7 = B6*2
4 15 3.8 ( ) Excel 2.8 (1) (2) : B8 : 0 : B6 : :Excel : :
4 16 10 (1) B9
(2) (B6) (B7) (3) a (B6) 15 b (B7) (B6) 20 c (B7) (B6) d 240 0 4 17 10 2500 3.50% 110809 310809 3500 5.50% :
4 18 4 4-5 ( ) A6 1 60 61 1.5 if G4 G243 2%, 100,000 240 2.9 4-1
5 4-6 4 19 11 11 180 (15 ) (1) 11 (2) X Y (3) 0.3% 100 180 3000 (4) 100 1%,...,10% 180 3000 (5) (4) (6) 2 4 (1 12 1.5