(. 1.1).
1.1
, , , ¯ | |
Ctrl | |
Ctrl | |
Ctrl | |
Ctrl ¯ | |
Ctrl Home | |
Tab | |
Shift Tab | |
Enter | |
Shift Enter | |
Ctrl PgUp | |
Ctrl PgDn | |
Ctrl End | . |
(. 1.2).
1.2
, , | , Shift , , | |
Ctrl + | ||
, Ctrl Shift ¯ |
.
MS Excel , . MS Excel , . . , ( , ).
.
, , . , , .
MS Excel . , , ( ꅖ ). , , .
- HTML - .
|
|
MS Excel.
:
1. ( : Microsoft Excel ). . , (, ) ( : Microsoft Excel ). : Microsoft Excel .
2. .
3. .
1. MS Excel.
1.1. ( Microsoft Excel).
1.2. MS Excel (. . 1.1) .
1.3. MS Excel (. 1.3):
1.3
1.3
( ) | |
( ) | |
( ) | |
( ) |
. 1.3 | |
( ) | |
( ) | |
( () ) | |
, ( ) | |
( ) | |
( ) ( ) | |
( ) | |
, A IV ( ) |
1.4. , ( ), , , ( ), ( ).
1.5. ( . " " , , , , , , , .
|
|
1.6.. (. 1.4).
1.4
1.6
, | ||
, | ||
, | ||
Visual Basic | , | |
, | ||
, | ||
, | ||
, | ||
, | ||
, | ||
, | ||
, | ||
- | , |
2. .
2.1. (. 1.5). , Enter, ShiftEnter, Tab, ShiftTab. .
1.5
2.1
5- | ||
3- 7- | ||
.1.5 | ||
D F | ||
B4:D7 | ||
B3, E12 F6:G7 | ||
B, C, D | ||
A3:B4, D, 9 | ||
, | ||
, |
3. ,
.
3.1. , ( ).
3.2. ( ).
3.3. 1:D10 . () ( OK). ( ).
3.4. 20:D30 . , ( ). 1:D20 ( , Del ).
( , , , ). , ( ). , Microsoft Office Excel (, (MS DOS).
3.6. 10 ( ).