. 㳺 .
1. 쳺 ?
2. ?
346
3. , .
4. , .
5. () .
6. .
7. , .
8. ? .
9. ?
10. ?
11. ?
12. -?
13. MS Office.
14. -.
. , :
, . 19.
2002-2004 .
, , ' , , 2000 . ( ) . 20.
, .20;
, .21 ( G11).
19
ϲȪ 20022004 * | ||||
D | ||||
ѳ | ||||
. 15. ij 20022004
20
ϲȪ 20022004
F | G | |
2002-2004 | ||
̳ | ||
' | ||
' | ||
ʳ |
|
|
() , , .
, . (, , ,..., Z) (, ,..., IV), (1, 2..., 65536). , , , 1 ( ) .
21
ϲȪ 2002
F | G | |
г | ||
' | ||
̳ ' | ||
' | ||
' | ||
ʳ |
: , , . , , , , , , .
. .
:
1. MS Excel.
2. .
2.1. , :
;
Format > Cells;
Border,
, , ..
.
2.2. :
( )
.
2.3. :
;
Format > Cells;
Font;
, , , ;
;
.
2.4. :
;
Format > Cells;
Number;
, , ' , ;
;
;
: (2002), Ctrl , , + ' 볭 , B3:D3, Ctrl;
|
|
4 ('01.01.2004'), 4:15, Edit > Fill > Series > Date > Month Format > Cells > Number Custom > Type > mmmm.
2.5. :
( );
Format > Cells;
Alignment;
, ;
.
3.
3.1. :
(, 4);
(=);
:
> ;
> ( );
> (;);
^ (,).
3.2. :
; ; , (Enter) (Edit), Point;
Point ;
♦ (Enter);
♦ ( Ready, Enter, Edit, Point).
♦ 㳺 Point.
3.3. ;
♦ Insert > Function ;
♦ Function Category (Statistical);
♦ Function Name Average;
♦ .
♦ ;
♦ ;
♦ .
3.4. :
♦ G4:G8 (.20) , 4:15.
♦ G4 =MAX(B4:D15);
♦ G5 =MIN(B4:D15);
♦ G6 =SUM(B4:D15);
♦ G7 =AVERAGE(B4:D15);
♦ G8 =COUNTIF(B4:D15;<2000).
3.5.
:
G5:G8:
♦ Insert > Name > Define
Gil ;
♦ 4.15 _2002;. ♦ 4:15 _2003;
♦ D4:D15 _2004,
♦ G12
:
=IF(piK = 2002; (_2002); = 2003; (_2003); IF ( = 2004; (_2004); )));
♦ G12
G13:G16;
Windows:
|
|
6
-ò
. )' , -
1. .
2. ?
3. IP-? IP-. -.
4. '? .
5. ?
6. ?
7. ?
8. ?
9. , .
. 볺
-. 11. . 12. -? 13. Web-.
/
1. Web- . Web-, , .22.
2. Web- . (.23) .
3. ³ MS Word'y. He : , ', , , .
4. Web- .
5. Web-.
22
в ֲ
Web-, | ||
ϳ 3 | job.avanport.com | |
ϳ | auto.yahoo.com, auto.bigmir.net | |
, | finance.com.ua | |
᳭ | finance.com.ua finance.rambler.ru | |
' ' | tdb.com.ua | |
- | lviv.ua | |
. . - | lviv.ua | |
rambler.ru | ||
- | yahoo.com |
. 22
Web-, | ||
_4- - . , - | yahoo.com | |
' - (, , ) | realestate.yahoo.com | |
11 ֳ ( ) | rambler.ru/map | |
, '. ' Pentium IV | price.ru | |
IBM | quote.yahoo.com | |
ij -ij | education.yahoo.com | |
. () . | bus.com.ua | |
. | ilona.com.ua | |
- . | bambook.com, dostavka.ru |
23
|
|