( ):
, , .
- , , . , .
, , 2 3. , , . , . , D5 , , 6.
, , , . , , $. , $$1 .
( ). , . : $1, $1,: = (1+$1)/ $1
1) , ,
2) , =,
3) Enter. .
, , .
:
1) , Excel , . #.
2) Excel .
F2. . . Enter.
1. & () , . (). & - , , ,
. 1 (60), 2 ( 10).
3 = 1 / 2 & _.
: 6_.
2. , , ..
.: 1 01, 2 02.
4 : = & A1 & & A2
:
|
|
|
01 02.
2. . .
, . . .
1. .
1. .
2. (1, 2, 3) . →→ ,
3. (1, 1, D1, E1, F1, G1). →→ , .
4. 2 (2, 2), (D2, E2) (F2, G2). .
5. 3, 3,D3,.......,G3 →→ → .
6. 13 .
7. 14 . (14,14)
→→→ → .
(D14,E14) (F14,G14).
10. , 14, :
→→→ →, : .
11. . (1:G3) :
→→ .
12. . .
| 2001 | 2002 | 2003 | ||||
| 1-9 | 10-11 | 1-9 | 10-11 | 1-9 | 10-11 | |
| 2980 | 1800 | 2700 | 1350 | 2350 | 1200 | |
| 2500 | 900 | 2350 | 850 | 2000 | 900 | |
| 1200 | 450 | 1100 | 280 | 1100 | 180 | |
| 2100 | 500 | 1900 | 400 | 2000 | 270 | |
| 420 | 100 | 470 | 170 | 530 | 110 | |
| - | 740 | 130 | 660 | 115 | 750 | 90 |
| - | 345 | 140 | 350 | 120 | 370 | 100 |
| - | 230 | 70 | 250 | 80 | 270 | 90 |
| - | 290 | 90 | 280 | 70 | 300 | 80 |
2. .
13. 13, (4:G13) . .
14. 14:
1) 14 =13+13, Enter;
2) D14 =D13+E13, Enter;
3) F14 =F13+G13, Enter.
