, . , , Excel . . , . () $. , $3 , $5 , $D$10 , .
( ), , ..
4.
1
( ) . .
(.)= ($)* ($/.)
(. ).
| 1$= | 29,0. | |
| ($) | () | |
A2-2 :
2
2 ($)
C2 (.)
1 "1$=", 1 29,0 ( ).
A3-A10; B3-B10 . B3-B10 : .
. ( 
).
. 3 : =3*1. ( <Enter>) : 580.
( 3), , . , .
| 1$= | 29,0. | |
| ($) | () | |
| 580,00. | ||
| #! | ||
| 23 200,00. | ||
| #! | ||
| 1 392 000,00. | ||
| #! | ||
| 125 280 000,00. | ||
| #! |
#!, . , #! (, ) ( ). ? 4 , . 4 : =4*2. 2 " (.)", ( ) #! 5-10 . , 1 ( ), . 3, =3*1 1 . $. $1 . < Enter >. 3 . (4:10), , .
|
|
|
.xls .
2.
C .
:
1. A1:1 " ".
2. 2 " ", 2 20 ( ).
3. A3:3 ().
4. A4:A8; B4:B8 .
5. 4 : =B4*2 (= 1 * - ).
6. 2 : $2 ( : =B4*$2.
7. 4 5:9.
8. 10 : = (4:9)
| 1 () | () | |
.xls .
3.
- .
:
, , , .
:
= () ()
= *
.
| /- | ||||
| (-) | (, ) | |||
| 26.12.00 | ||||
| 30.01.01 | 82,50 | |||
| 25.02.01 | 110,00 | |||
| 23.03.01 | 110,00 | |||
| 27.04.01 | 82,50 | |||
| 29.05.01 | 82,50 | |||
| 23.06.01 | 55,00 | |||
| 22.07.01 | 27,50 | |||
| 30.08.01 | 55,00 | |||
| 30.09.01 | 55,00 | |||
| 29.10.01 | 82,50 | |||
| 28.11.01 | 110,00 | |||
| 23.12.01 | 165,00 | |||
| 1 017,50 |
.xls .
|
|
|
