, , . .
- " , ". .
( 1). , , , .
, , , . (. . 25).
. . : " ". . , , ( $$1). , , , , .
, - $.
F4, .
($) , (, $$2), F4 ($2 $2 - ).
11. " /" Excel
, , , , , .
. . , ( ).
12. Excel
13. / Excel
/: 1. . 2. . 3. - , , .
Excel
Excel
1. ( , );
2. [1] ;
3. ;
|
|
4. ().
Microsoft Excel - , , Microsoft 1985 . Microsoft Excel - , , , , Internet. Microsoft Excel Microsoft, . , . , , , .
Excel
.
(. , . Visual Basic (VBA).).
. , . ; .
, , .
( . , F5 CTRL+A, . , , ALT+, , .) , . CTRL+ ( ) CTRL+SHIFT+ ( ), . , @ #.
. Microsoft Excel , , .
, .
Microsoft Excel, .
, .
OK.
, , . , . , Microsoft Excel , .
, .
.
Excel.
( A 0 9) ( A 9 0)
|
|
.
.
()
, .
, .
.
, .
OK.
()
, .
.
.
OK.
.
, .
OK.
,
. .
, .
.
.
OK.
, , .
Excel
(CTRL+1)
: , , , , , , , .
: , , (), , .
: , , , , .
: , , , .
: , ,
: , .
Excel
MS Excel . . . / .
, . Excel .
. , . MS Excel () . ( ) .
Excel . / . .
Excel
, . (=). , 2 3 5.
=5+2*3
: =128+345
(. , . , , .) (. ( ) . , 210 . .).
=128+345 128 345
=5^2 5
1. , .
2. = ( ).
3. .
4. ENTER.
|
|
, : =A1+23
( . , , . . A1.) (. , , , . , , , , , !C20:C30.). , , , . , B2 , =C2.
=C2 C2
=2!B2 B2 2
=-
1. , .
2. ( . Microsoft Excel, . , .) = ( ).
3. .
o , , , . , , , .
o , F3, .
4. ENTER.
, : =(A1:B4)
(. , , . , , .).
=(A:A) A
=(A1:B4)
1. , .
2. , ( . Microsoft Excel, . , .).
3. , . , , (, ), .
4. (. , . , , . , , , , .). , . .
5. ENTER.
: =((F2:F5)>50; (G2:G5);0)
. (G2:G5), (F2:F5) 50. 0.
|
|
1. , .
2. , ( . Microsoft Excel, . , .).
3. , . , (, ) , .
4. (. , . , , . , , , , .).
o , , . .
o , . , (G2:G5) __.
o , , . , .
Excel
Excel . , , . , , . , Excel.
, . , , . . , Excel , .
, , .
;. Excel , . . , , .
, , , , . , . . , , . Excel .
. , .
Excel : , , DDE/ , , , , , . , : , .
: , , .
, (, , , ).
, .
Excel
Microsoft Excel, , . Subtotals () Data ().
|
|
Subtotals ( ) :
, , , At each change in ( ). , .
, , Use function ().
, , , Add subtotal to ( ).
Replace current subtotals ( ), .
Page break between groups ( ).
Summary below data ( ).
Remove All ( ) .
Excel
, .
< - - > (menu Data - Filter - AutoFilter).
! < - - > (menu Data - List - Create List) Ctrl+L, .
<> . .
-, . Excel , . , .
-, (, ; ).
-, , <:>.
.
, =(), , . :
* , , <> <*>;
* , 2000 ., < > 2000.
. . , . 20 . .
, , :
:
: . .
, . < - - > (menu Data - Filter - AutoFilter) .
Excel
Excel .
.
1. . Excel .
2. . .
3. ʔ. , .
.
, .
, .
25. " /" Excel
26. " /" Excel
27. " /" Excel
28.30. "/" Excel
29. "/" Excel
31. "/" Excel
:
, .
Format () AutoFormat ().
.
, .
Options () , .
32. "/ " Excel
, , . , , 0 1000 , . , Microsoft Excel , .
Condition (), , Format (). , Add ( ): .