1.
. , . .
| A | B | C | D | E | F | G | H | |
| =B3++B7 | ||||||||
| . . | =B9/5 |
book.xls " ".
.
1. Excel (>>Microsoft Excel).
2. , , , .
3. 1 .
4. 3 , , 7, .
5. , .
6. 5 = 3 + 4 + 5 + 6 + 7.
7. 9, D9, E9, F9.
8. 6 = 6 / 5.
9. 10, D10, E10, F10.
10. .
2.
, book.xls . " ". . 10 % . .
| D | E | ||||
| 1089,56 | 1003,58 | =($c$7 - b2) * 0,1 | |||
| 2005,01 | 1003,58 | ||||
| 1089,56 | 2006,68 | ||||
| 1089,56 | 1089,56 | ||||
| 7456,89 |
3.
, book.xls " ( )". " ". , 
|
|
|
i i- (
)
xi i- ()
-- .
.
| A | B | C | D | E | F | G | |
| xi | |||||||
| 1 | 2 | 3 | |||||
| .
|
4.
, , , (, 2005 18% 2004 ). , . book.xls " ".
. 18% . ( ). ( 5%). , .
| A | B | C | D | E | F | |
| , . | 10 000 | =(1+$B$10)*B3 | ... | ... | =(1+$B$10)*E3 | |
| =(1+$B$11)*B4 | ... | ... | =(1+$B$11)*E4 | |||
| =3* B4 | =3 * C4 | ... | ... | =F3+F4 | ||
| 15 000 | =(1+$B$11)*B6 | ... | ... | =(1+$B$11)*E6 | ||
| =B5-B6 | =C5-C6 | ... | ... | =F5-F6 | ||
| 0,18 | ||||||
| 0,05 |
5.
. 1000 . 550 .
book.xls "".
, .
|
|
|
| A | B | C | D | E | F | |
| C | ||||||
| = $B$8 * B3 | =C3 + E3 | |||||
| =F3++ F6 | ||||||
6.
. book.xls " ".
| A | B | C | D | E | F | G | |
| . . | % | . . | % | . . | % | ||
| 100,41 | =B4/$B$6 | 48,43 | =D4/$D$6 | =B4 + D4 | =F4/$F$6 | ||
| 154,64 | 206,62 | ||||||
| 255,05 | 255,05 | ||||||
C4, C5,C6, D4, D5, D6, F4, F5, F6, G4, G5, G6 2.
7.
A1 , . 2 A1, 1 . A1 =(1). 3:5 , .
| A | B | C | |
| : | =(1)*1 | ||
| : | |||
| : | |||
| : | |||
8.
3 2 . 3, 6, 9,..., 24 , .
