5. Excel
: MS Excel
Excel , . :
;
;
;
, ;
;
.
MS Excel ( ). , MS Excel.
MS Excel :
1. , ;
2. ;
3. ;
4. ;
5. .
.
. Excel Windows.
MS Excel. . , , . , .
( , ), . Excel , . , .
. Excel , . Excel . , Excel, Excel , .
. , , . , - . () . , Excel . Excel .
|
|
. . , Excel . . .
. . , , . , , , .
. , . , , . , , .
. Excel , , , , , Excel.xlb. , , Excel. , , Excel.
. - , .
MS Excel , . , . " ". () \ \ \ . \ . \ .
. , .
- , MS Excel . . , , .. , , . . Excel . MS Excel , . . MS Excel . - , , . , , . .
|
|
, , , .
(. 19):
( );
( );
( );
( ).
:
, ,
CTRL+
HOME
CTRL+HOME
CTRL+END , ( )
PAGE DOWN
PAGE UP
ALT+PAGE DOWN
ALT+PAGE UP
CTRL+PAGE DOWN
CTRL+PAGE UP
CTRL+F6 CTRL+TAB
CTRL+SHIFT+F6 CTRL+SHIFT+TAB
F6 ,
SHIFT+F6 ,
CTRL+BACKSPACE
F5
SHIFT+F5
SHIFT+F4 ( )
TAB
. Excel.
, . 19. . .
19
. 1.
1
1,3,4,6,3 | 1,1,1,1,0 | 1,2,2,4 | 0,0,4,0 | 1=25 | 1,2,1,2,0 | 1,0,0,1 | 3,2,1,4,0 | 3,0,0,1 | 12,1 | 1,1 | ||||
2,1,3,2,4 | 2,1,1,2,0 | 2,1,1,3 | 5,0,0,0 | 1=13 | 2,2,1,3,0 | 2,0,0,1 | 1,2,1,5,0 | 1,0,0,1 | 6,2 | 1,2 | ||||
3,6,1,5,1 | 1,1,1,3,0 | 3,2,3,1 | 0,0,4,0 | 11=24,6 | 3,2,1,4,0 | 3,0,0,1 | 4,2,1,6,0 | 2,0,0,1 | 12,3 | 1,3 | ||||
4,1,2,1,2 | 303,1,4,0 | 1,3,3,1 | 5,0,0,0 | 2=14 | 1,2,1,5,0 | 3,0,0,1 | 3,2,2,1,0 | 3,0,0,1 | 6,4 | 1,4 | ||||
2,2,3,3,2 | 3,1,2,4,0 | 1,3,2,2 | 0,0,4,0 | 9=27 | 4,2,1,6,0 | 1,0,0,1 | 1,2,2,2,0 | 1,0,0,1 | 11,5 | 5,5 | ||||
4,4,1,4,1 | 2,1,1,4,0 | 4,4,3,3 | 5,0,0,0 | 3=15 | 3,2,2,1,0 | 2,0,0,1 | 4,2,2,3,0 | 2,0,0,1 | 6,6 | 4,6 | ||||
1,5,4,6,3 | 1,1,2,1,0 | 4,4,3,3 | 0,0,4,0 | 7=20,5 | 1,2,2,2,0 | 3,0,0,1 | 3,2,2,4,0 | 3,0,0,1 | 6,7 | 1,7 | ||||
3,3,2,2,4 | 4,1,2,2,0 | 4,2,3,4 | 5,0,0,0 | 4=16 | 4,2,2,3,0 | 1,0,0,1 | 1,2,2,5,0 | 1,0,0,1 | 12,7 | 2,1 | ||||
2,6,1,5,3 | 1,1,2,3,0 | 2,2,1,4 | 0,0,4,0 | 5=18,7 | 3,2,2,4,0 | 2,0,0,1 | 3,2,2,6,0 | 2,0,0,1 | 7,2 | 2,2 | ||||
3,1,2,1,1 | 3,1,2,4,0 | 1,2,2,1 | 5,0,0,0 | 3=14,67 | 1,2,2,5,0 | 3,0,0,1 | 12,3,1,0 | 3,0,0,1 | 7,3 | 2,3 | ||||
4,2,2,3,2 | 1,1,2,5,0 | 1,1,1,1 | 0,0,4,0 | 6=22,3 | 3,2,2,6,0 | 1,0,0,1 | 1,2,3,2,0 | 1,0,0,1 | 11,4 | 5,4 | ||||
1,4,3,4,4 | 4,1,2,6,0 | 1,3,2,4 | 5,0,0,0 | 2=15,6 | 12,3,1,0 | 2,0,0,1 | 3,2,3,3,0 | 2,0,0,1 | 7,5 | 2,5 | ||||
2,1,4,6,1 | 1,1,3,1,0 | 4,3,2,1 | 0,0,4,0 | 8=15 | 1,2,3,2,0 | 3,0,0,1 | 1,2,3,4,0 | 3,0,0,1 | 7,6 | 2,6 | ||||
3,5,1,2,3 | 3,1,3,2,0 | 4,2,3,1 | 5,0,0,0 | 2=14,99 | 3,2,3,3,0 | 1,0,0,1 | 2,2,3,5,0 | 1,0,0,1 | 11,7 | 4,7 | ||||
4,6,3,5,4 | 1,1,3,3,0 | 4,1,1,3 | 0,0,4,0 | 10=9 | 1,2,3,4,0 | 2,0,0,1 | 1,2,3,6,0 | 2,0,0,1 | 8,1 | 3,1 | ||||
2,3,3,5,2 | 2,1,3,4,0 | 4,2,2,2 | 5,0,0,0 | 1=13,13 | 2,2,3,5,0 | 3,0,0,1 | 1,2,4,1,0 | 3,0,0,1 | 8,2 | 3,2 | ||||
3,2,2,1,2 | 1,1,3,5,0 | 3,4,2,2 | 0,0,4,0 | 4=10,4 | 1,2,3,6,0 | 1,0,0,1 | 2,2,4,2,0 | 1,0,0,1 | 12,3 | 5,3 | ||||
1,1,3,4,2 | 4,1,3,6,0 | 3,4,2,3 | 5,0,0,0 | 4=18 | 1,2,4,1,0 | 2,0,0,1 | 2,2,1,3,0 | 2,0,0,1 | 8,4 | 3,4 | ||||
4,2,3,4,1 | 1,1,4,1,0 | 4,4,1,3 | 0,0,4,0 | 3=12,7 | 2,2,4,2,0 | 3,0,0,1 | 3,2,1,4,0 | 3,0,0,1 | 8,5 | 3,5 | ||||
3,1,1,6,3 | 1,1,4,2,0 | 4,4,1,2 | 5,0,0,0 | 2=20 | 1,2,4,3,0 | 2,0,0,1 | 1,4,1,5,0 | 1,0,0,1 | 11,6 | 3,6 |
|
|
. 2 , 3 , 4 , 5 . . 1 : i- i , j- j- , 1<=i<=n, n- , 1<=j<=m, m- .
(. 2).
2
Arial | |||||
Courier | 8,5 | ||||
Courier New | |||||
Times New Roman | 9,5 | ||||
- | |||||
:
(. 2), , ,
(. 3),
(. 5).
, , , . (. 3, ), (. 3, ).
|
|
3
Alt+Enter | 90 | |||
90 | ||||
1 | ||||
[1] |
(. 2, ) (. 3, ), (. 5).
(. 4).
4
- | ||
- | ||
- | ||
- | ||
- | ||
- | ||
5
- | |
- | |
- |
. 20. 20 :
:
3,1,1,6,3:
- Courier New,
-8,
- ,
- ,
- .
:
:
1,1,4,2,0:
- Arial,
-8,
,
- ,
- .
4,4,1,2:
,
,
,
90 .
5,0,0,0:
1. .
2=20:
2. 20 .
:
1,2,4,3,0:
- Arial,
8,5,
,
- ,
- .
2,0,0,1:
,
,
,
.
:
1,4,1,5,0:
- Arial,
9,5,
,
- ,
- .
1,0,0,1:
,
,
,
.
:
5: .
1: .
4: .
:
11, 6:
1. 11 . 4,
2. -6 -.
3, 6:
3. 3 . 4,
4. 6 -.
. : ( http://standarts.guap.ru), , , . , / / . , .
6. ? ?
7. Excel?
8. ?
9. ? ?
10. ?
11. MS Excel?
12. MS Excel?
13. MS Excel?
14. ?
|
|
15. MS Excel?