-
( )
___________________
..
2004
681.513.2+621.382(076.5)
. . ..
..
/ - . - : , 2004. 24 .
, 060800.
- , 2004
.., 2004
1. 1. MS Excel. , ,
.....4
2. 2. MS Excel. , .....6
3. 3. MS Excel. ,
...7
4. 4. MS Excel.
( ) .9
5. 5. MS Excel. ..10
6. 6. MS Excel. ......13
充20
..21
22
1
, ,
: , , .
1. A1:E3 .
| A | B | C | D | E | |
| 1 | |||||
| Excel |
, B1:B3, C1:C3, D1:D3, E1:E3, .
/.
/.
//, - //.
2. A1 2 :
EXCEL
, .
|
|
|
ALT + ENTER.
/ .
3. 3 :
| / | .. | ||
| 1. | .. | 12.05.1982 | 7,0 |
| 2. | .. | 23.07.1981 | 8,0 |
| 3. | .. | 01.12.1982 | 7,5 |
| 7.5 |
1, 2 .
.
/ .
4. 4:
a) A1-A12 , ;
b) B1-G1 ;
c) A13-G13 .
( , ).
5. 5:
a) 1 125,6. C2, C3, 4, 5;
b) 1 , 2 , 3 , 4 , 5 .
/ () .
6. 6 :
a) A1:A10 1 10;
b) B1:D10 21 40;
c) 1:10 1 19;
d) 27 2, 4, 8, 16, (20 ).
// .
: xls.
2
,
: , .
1. :
; 
; 
,
x, y, z.
 |
x, y, z A3, B3 C3. A5, A6 A7 . , =1+A3+A3^2+A3^3. . 1.
. 1.
2. , .
) , "";
|
|
|
) .
//. .
, , , , , Enter.
: .xls.
3
