,,,
. .. ()
Microsoft Excel
..
Microsoft Excel. , . Microsoft Excel. . . Microsoft Excel. : , ( ), , .
- .
1. ............................................................................................. 6
1.1. ......................................................................... 6
1.2. Microsoft EXCEL....................................................................... 6
1.2.1. ......................................................................................... 7
1.2.2. Microsoft Excel.......................................................................................... 7
1.2.3. ............................................................... 9
1.3. ............................................................................................................. 9
1.3.1. Microsoft Office................................................................................. 11
1.3.2. ................................................................................................................... 11
1.3.3. ................................................................................... 11
1.3.4. Exel..................................................................................... 12
1.4. ............................................................................................ 12
2. ............................................................................ 13
2.1. ......................................................................... 13
2.2. .................................................................................... 13
2.2.1. ............................................................................... 13
2.2.2. .................................................................................................. 15
2.2.3. ................................................................................................... 15
2.2.4. ...................................................................................................................... 16
2.3. Excel............................................................................................................... 17
2.4. ...................................................................... 22
2.5. .......................................................................................... 24
2.5.1. ............................................................................................ 24
2.6. ...................................................................................................... 28
3. Excel. ................ 31
3.1. ................................................................................................................... 31
3.2. ........................................................................ 31
3.3. . . 33
3.4. .................................................................................................................... 34
3.4.1. .................................................................................................... 34
3.4.2. .......................................................................................................... 35
3.4.3. ...................................................................................................... 36
4. ................................................................... 39
4.1. .......................................................................................................................... 39
4.1.1. ............................................................................................................... 39
4.1.2. ........................................................................................................ 40
4.2. ......................................................................................... 42
4.2.1. ........................................................................................................ 42
4.2.2. ............................................................................................ 42
4.2.3. ..................................................................................... 47
5. Excel............ 48
5.1.1. ............................................................................................. 49
5.2. ................................................................................. 49
5.3. ............................................................................................ 50
5.4. .................................................................................... 51
5.5. ........................................................................... 52
5.6. ................................................................. 53
5.6.1. ........................................................................ 55
5.6.2. ................................................................... 57
6. .................... 60
6.1. ............................................................................................................. 60
6.2. .............................................................................................. 60
6.3. ............................................................................................. 61
6.4. .............................................................................................. 63
6.5. ................................................................................................. 63
6.6. ............................................................................... 64
6.6.1. Excel 95..................................................................................................................... 64
6.6.2. Excel 97..................................................................................................................... 64
7. ( ) 66
7.1. Excel 95 Excel 97.................................. 66
7.1.1. Web-........................................................................................ 66
7.1.2. Web-................................................................................. 66
7.1.3. Microsoft Excel 97 ............................. 66
7.1.4. .................................................. 67
7.1.5. ........................ 67
7.1.6. "" ...................................................... 68
7.1.7. ....................................................................... 68
7.1.8. ( ).... 68
7.1.9. ....................................................... 68
7.1.10. ........................................... 68
7.1.11. .. 68
8. ............................................................ 69
8.1. ....................................................... 69
8.1.1. ...................................................................................... 69
8.1.2. .................................................................................................. 70
8.2. EXCEL............................................................................ 73
8.2.1. ..................................................................................... 73
8.2.2. ............................................................................... 74
........................................................................ 75
, Microsoft Excel. , Excel , , Microsoft Windows.
Microsoft Excel 95 97. Microsoft Excel 97 Microsoft Excel 2000.
, + (), , Ctrl+A : , , , , . . Ctrl+A : Ctrl, , , . , , Alt, F , , .
: , , : | .
: V5.
: Windows, Microsoft Excel (, , ), | Windows.
1.( ) , , . , 90% .
, . , , Lotus 1-2-3, - :
( , );
[1] ;
;
().
SuperCalc Quattro Pro. Microsoft Windows - Microsoft Excel.
Microsoft Excel ‑ , , Microsoft 1985 . Microsoft Excel ‑ , , , , Internet. Microsoft Excel Microsoft, . , . , , , .
;
;
;
;
Internet Intranet-.
, ( );
. Microsoft Excel 15 , . , , , . "" .. , Excel , ;
;
;
;
;
, ;
;
. Excel Windows , .
( , , );
( , , - , , "" .).
. , .. , . Microsoft Excel . , , . , Microsoft Excel .
Microsoft Excel . . Microsoft Word, ,
. Microsoft Excel Web- Internet. Microsoft Excel , Web- , Microsoft Excel. : HTML, Microsoft Excel , ;
Internet Assistant HTML Web-. Microsoft Excel HTML-, Web-, . Microsoft Excel;
Web Queries. Microsoft Excel 97 , Web-. Internet .
1.2.3. |
|
|
486 . - (CD-ROM) 3,5"-. VGA ( ) ( Super VGA, 256 ) Microsoft IntelliMouse(tm), Microsoft Mouse |
|
Microsoft Windows 95/98 Microsoft Windows NT 3.51 Service Pack 5 Microsoft Windows NT 4.0 Service Pack 1 |
|
Windows 95/98: 8 MB (12 MB WordMail); Windows NT: 16 MB ; |
|
35-40 MB |
. . .
, . (: * 1*2), .
.
, .
( , ). , , .
Excel 97 .
URL Intranet. Excel HTML HTTP- FTP- Excel 97 " ".
"online" - URL Excel HTTP- FTP- Intranet. , Intranet
HTML- Excel 97 HTML , (*.xls). , , .
Visual Basic (VBE) VBE Visual Basic 5.0. , , , ,
.
, " ". , , .
(HTML) , Excel, HTML- , Intranet. GIF .
Excel Excel , , Excel. Excel Viewer , Excel, , , , , Excel.
Microsoft Excel Microsoft Office, , , .
Excel Microsoft Word. Windows, Microsoft, . , , . , , , , , , .
Excel ( Microsoft Office), (Object Linking and Embedding, OLE 2.)
Microsoft Excel , . (). :
, ;
, ;
, ( , ).
Web-, HTML- Microsoft Excel.
, .
, , .
, Excel .
Microsoft Excel , .
. , , , . Microsoft Excel . , , , .., . , (.. ) , .
, , , . .
, ( ) ( ).
Excel ....
Microsoft Excel Microsoft Visual Basic (Visual Basic for Applications, VBA). VBA . , Excel , .
Microsoft Excel , Excel, , Lotus 1-2-3.
Excel, , , . Excel , . (, , , ) Excel , .
2., 1, 2, 3 .. 16384, A, B, C .. , Z AA, AB, AC .. IV. , , . B5.
. 1. Excel
. . 9 5. - 4 A1 4 C7 C3, C3 =A1+C7 C3 8. 3 Excel. .
- , , Excel . , , .
- MS Excel, . .xls.
Excel, , . Windows, Excel.
: Excel , . - ( ). , , 1. Windows, - , .
1. .
2. .
3.
4. .
5. .
6. .
7.
8. ( Excel).
9. .
10. .
11. () .
12. .
13. .
. 2.
Excel, Windows, . Excel. .
, . . , , , . , , , CAPS LOCK, SCROLL LOCK NUM LOCK.
Excel 1, 16 . , .
: , , , , , .
Excel . . .
.
Esc .
? . , . , , Excel , .
, , ?. , .
Excel | .
ࠠ - - (, , )
. 3.
1- (.. ) ).
2- ( , , () , , ).
3- , , .
4- , , .
5- ( ). , ()
. : , . . , - - - . , , : A2:D4.
. 4.
. 5.
( ) , .
, ; .
, . , BUDGET.XLS BUDGET.XLS:2.
( ) , . , , , .
. 6. |
. |
( ) , . , , , .
, , . , .
. 7. |
. |
. 8. |
. |
. 9. |
. |
. 10. |
. |
. , . .
. 11.
. , . , . , , . , .
. , .
( )
. 12.
. . ; .
, .
. , . .
, . , , . , .
. , .
: .
. . , .
1, 2, 3, ...9 ( ) . . .
, , . .
. . , .
, F2, . , .
. CTRL+Z ESC. , .
. Microsoft Excel, . . , ENTER. .
. . , ENTER. . . .
1 .
1
2.90 | ||||||||||
5.20 | ||||||||||
6.80 | ||||||||||
/ | - | - | ||||||||
() | ($) | |||||||||
1 | Frutis | 2.00 | 200 | |||||||
2 | SUMP | 2.32 | 80 | |||||||
3 | Forum | 1.98 | 165 | |||||||
4 | Like | 1.86 | 320 | |||||||
5 | UFO | 2.05 | 120 | |||||||
6 | Frutis | 4.00 | 90 | |||||||
7 | SUMP | 3.65 | 100 | |||||||
8 | Forum | 4.05 | 65 | |||||||
9 | Like | 4.66 | 22 | |||||||
25 | UFO | 6.60 | 55 | |||||||
Windows :
.
. Windows.
.
. Excel :
, , .
. .
. .
. - , | . | .
. | .
(. ).
.
Microsoft Excel : .
Excel , . :
Microsoft |
Visual Basic
|
Excel . , . : . .
Microsoft Excel . , , , , . , . ( | ... | ...).
. 13.
:
. .
, . , , , .
:
, .
, . . . , . , , . . : , .
, .
, :
, .
, , . , . , , OK .
. - ; - ; - . | |
; . | |
4 . | |
; - . | |
. | |
. | |
. - . . | |
. . | |
. - . |
, .
, . | |
: , , . | |
: , . . | |
. , - . . , |
Excel . . . | . , .
Excel (. .). . ( ). , .
Excel () . ( ) .
, Excel , , , , , . .
. 14.
, . 255 . , , .
.
-, -, , , , .
, , , .
. 15.
, Excel, , , .
. , , - . , , .
. 16.
, , , , . , , .
| . .
, , . , . , .
, . .
, . , .
, .
, .
3. Excel.Excel . Excel . , , , , , . , , . , , , - , , .
Excel , =. , , , . , .
, , , .
, : ax2+bx+c=0. A2 A3 :
=(-B1+(B1*B1-4*A1*C1))/2/A1
=(-B1-(B1*B1-4*A1*C1))/2/A1
A1, B1 C1
a, b , .
a=1, b=-5 =6 ( ,
A1, B1 C1
1, 5 -6), A2 A3,
, 2 ‑3.
A1 -1,
-6 1.
. , . , , .
, , , . . .
- , , , . , | | ... :
, , , , .
, =- , =F6-D6.
, , , .
, . .
, . , , . , .
Excel . .
, , :
.
, =$F$12, $F$12 .
, , .
, , .
, , , . , , , , . .
. $. , $. $, .
, D7 $D7, 7. D$7 , D. $D$7, D7. G3:L9, : G, 3, L 9, $.
$, , $ . , .
, .
, 1. :
($): - $, D1.
: = *
: = *
: = -
:
2
A | B | C | D | E | F | G | H | I | |||
1 | 3.62 | ||||||||||
2 | 2.90 | ||||||||||
3 | 5.20 | ||||||||||
4 | 6.80 | ||||||||||
5 | / | () | ($) | - | - | ||||||
6 | 1 | Frutis | 2 | =D6/kurs | 200 | =D6*F6 | =F6*I$2 | =H6-G6 | |||
7 | 2 | SUMP | 2.32 | =D7/kurs | 80 | =D7*F7 | =F7*I$2 | =H7-G7 | |||
8 | 3 | Forum | 1.98 | =D8/kurs | 165 | =D8*F8 | =F8*I$2 | =H8-G8 | |||
30 | 25 | UFO | 6.05 | =D30/kurs | 120 | =D30*F10 | =F30*I$4 | =H30-G30 | |||
D1 kurs, $. ( 3.62, -), 1.
, , : : I$2 - , "" . .
Excel . , , . , , . , Excel.
, . , , . . , Excel , .
, , .
蠠 ;. Excel , . . , , .
, , , , . , . . , , . Excel .
. , .
Excel : , , DDE/ , , , , , . , : , .
: , , .
, (, , , ).
, .
Excel . , : , , .
. , .
Excel . , Excel , .
Excel 400 . . Excel . , .
. 17.
| . , .
() ( ) () ( ) , 2.
.
3
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
5 |
/ | -- | () | ($) | - | . | |||
6 |
1 | - | Frutis | 2 | =D6/kurs | 200 | =D6*F6 | =F6*I$2 | =H6-G6 |
7 |
2 | - | SUMP | 2.32 | =D7/kurs | 80 | =D7*F7 | =F7*I$2 | =H7-G7 |
8 |
3 | - | Forum | 1.98 | =D8/kurs | 165 | =D8*F8 | =F8*I$2 | =H8-G8 |
9 |
4 | - | Like | 1.86 | =D9/kurs | 320 | =D9*F9 | =F9*I$2 | =H9-G9 |
10 |
5 | - | UFO | 2.05 | =D10/kurs | 120 | =D10*F10 | =F10*I$2 | =H10-G10 |
11 |
: | = (D6:D10) | : | = (F6:F10) | = (G6:G10) | = (H6:H10) | = (I6:I10) | ||
12 |
6 | - | Frutis | 4 | =D12/kurs | 90 |
=D12* |
=F12*I$3 | =H12-G12 |
|
|||||||||
25 |
: | : | = (F6:F22) | = (G6:G22) | = (H6:H22) | = (I6:I22) |
:
4
$= | 1.3 | |||||||||
2.90 | ||||||||||
5.20 | ||||||||||
6.80 | ||||||||||
/ | ' () | ' ($) | ||||||||
1 | Frutis | 2.00 | $ 1.54 | 200 | 400.00 | 580.00 | 180.00 | |||
2 | SUMP | 2.32 | $ 1.78 | 80 | 185.60 | 232.00 | 46.40 | |||
3 | Forum | 1.98 | $ 1.52 | 165 | 326.70 | 478.50 | 151.80 | |||
4 | Like | 1.86 | $ 1.43 | 320 | 595.20 | 928.00 | 332.80 | |||
5 | UFO | 2.05 | $ 1.58 | 120 | 246.00 | 348.00 | 102.00 | |||
: | 2.04 | : | 885 | 1 753.50 | 2 566.50 | 813.00 | ||||
24 | Like | 5.99 | $ 4.61 | 60 | 359.40 | 408.00 | 48.60 | |||
25 | UFO | 6.60 | $ 5.08 | 55 | 363.00 | 374.00 | 11.00 | |||
: | 6.04 | : | 315 | 1 861.55 | 2 142.00 | 280.45 | ||||
: | : | 1517 | 4 865.02 | 6 356.90 | 1 491.88 | |||||
, .
4.Excel (). , . , .
, .
| | . , .
. 18.
, , .
, , OK.
, , , . , : , , .
. . , , .3, .4, .5. .
, , . , . . .
. , , , ( ) ( ). .
, .
. ( ) . , . .
. 19.
, . | .
, . , , - , . , , .
. 20.
( ).
, .
. 21.
, ENTER. , - , , .
.
. . . . , , .
Microsoft Excel Windows . . , .
. 22.
| .
. , 4 , 0 .
. , .
XY- .
, , XY- .
Excel , , . .
Excel , , , .
3 4. . . , ( ). . . .
:
,
: $B$5:$C$23; $I$5:$I$23, , [2]
. 23.
, : , - .
Excel ( , )
, : , - .
. 24. |
" " ( )
1- .
. 25. 2
2- "" 3 : "" - " " ( ) "" - ( ) " " - - ( , . , ).
- " " ""
. 26. 3
: () .
‑ . , "", :
. 27.
:
.
, .
.
.
, .
.
, .
.
. , , XY-. .
, Excel .
. | .
5. [3] Excel, , , , , , , . .
Excel , . . Microsoft Excel , . .
Excel . , , .
. . .
Excel . . | .
, .
Excel , , - .
, . , Microsoft Excel . , , Microsoft Access, dBase Microsoft FoxPro.
:
. , , , , ..
, .
.
, . , .
, - .
, . ( | ) , Excel .
. . - | .
| , .
. Excel , , . .
, , , . , .
. 28.
, . , . Excel , . , . , . .
. . Excel , . .
, | .
. . . . . . . Excel .
| .
:
, ( , )
. , .
.
| , . . .
. . . .
. 29.
, , .
, , . , .
, . :
,
( )
, , . , . .
Excel . : . C .
. 30.
. 31.
.
| .
. | , . Excel .
| :
,
, :
,
, .
: .(_; )
_ - 1 11, , .
|
|
1 | |
2 | ר |
3 | ר |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | |
11 |
- , .
, , . .
- : , , , ().
, : , -, () . . ($) , , . ( $ ), .
| ... | :
. 32.
, , . ‑ (" /"; "";..." ") ( ‑ , ).
1. : .
2.
3. : : " ", " ", "", " ".
4. : .
5. :
5
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
5 |
/ | --. | ' () | ' ($) | - | . | |||
6 |
1 | - | Frutis | 2 |
=D6/ |
200 | =D6*F6 | =F6*I$2 | =H6-G6 |
7 |
2 | - | SUMP | 2.32 |
=D7/ |
80 | =D7*F7 | =F7*I$2 | =H7-G7 |
8 |
3 | - | Forum | 1.98 |
=D8/ |
165 | =D8*F8 | =F8*I$2 | =H8-G8 |
9 |
4 | - | Like | 1.86 |
=D9/ |
320 | =D9*F9 | =F9*I$2 | =H9-G9 |
10 |
5 | - | UFO | 2.05 |
=D10/ |
120 |
=D10* |
=F10*I$2 | =H10-G10 |
11 |
: |
=E. (1;D6: |
: |
=. (9;F6: |
=. (9;G6: |
=. (9;H6: |
=. (9;I6: |
||
12 |
6 | - | Frutis | 4 |
=D12/ |
90 | =D12*F12 | =F12*I$3 | =H12-G12 |
|
|||||||||
25 |
: | : |
=. (9;F6: |
=. (9;G6: |
=. (9;H6: |
=. (9;I6: |
:
6
$= | 1.3 | |||||||||
2.90 | ||||||||||
5.20 | ||||||||||
6.80 | ||||||||||
/ | ' () | ' ($) | ||||||||
1 | Frutis | 2.00 | $ 1.54 | 200 | 400.00 | 580.00 | 180.00 | |||
2 | SUMP | 2.32 | $ 1.78 | 80 | 185.60 | 232.00 | 46.40 | |||
3 | Forum | 1.98 | $ 1.52 | 165 | 326.70 | 478.50 | 151.80 | |||
4 | Like | 1.86 | $ 1.43 | 320 | 595.20 | 928.00 | 332.80 | |||
5 | UFO | 2.05 | $ 1.58 | 120 | 246.00 | 348.00 | 102.00 | |||
: | 2.04 | : | 885 | 1 753.50 | 2 566.50 | 813.00 | ||||
24 | - | Like | 5.99 | $ 4.61 | 60 | 359.40 | 408.00 | 48.60 | ||
25 | - | UFO | 6.60 | $ 5.08 | 55 | 363.00 | 374.00 | 11.00 | ||
: | 6.04 | : | 315 | 1 861.55 | 2 142.00 | 280.45 | ||||
: | : | 1 517 | 4 865.02 | 6 356.90 | 1 491.88 | |||||
. , : . :
7
|
B |
C |
D |
E |
F |
G |
H |
||
4 |
=' '!B6 | =' '!B18 | =' '!B12 | - | - | - | |||
5 |
=' '!C12 | =' '!D6 | =' '!D12 | =' '!D18 | =(C$5:C$9) | =(D$5:D$9) |
=(E$5: |
||
6 |
=' '!C13 | =' '!D7 | =' '!D13 | =' '!D19 | =(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
7 |
=' '!C14 | =' '!D8 | =' '!D14 | = '!D20 | =(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
8 |
=' '!C15 | =' '!D9 | =' '!D15 | =' '!D21 | =(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
9 |
=' '!C16 | =' '!D10 | =' '!D16 | =' '!D22 | =(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
10 |
. | =(C5:C9) | =(D5:D9) | =(E5:E9) | |||||
11 |
. | =(C5:C10) | =(D5:D10) | =(E5:E10) |
8
|
F |
G |
H |
||
3 |
|||||
4 |
|||||
5 |
=(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
6 |
=(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
7 |
=(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
8 |
=(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
9 |
=(C$5:C$9) | =(D$5:D$9) | =(E$5:E$9) | ||
:
9
Frutis | 2.00 | 4.00 | 6.25 | 2.04 | 4.07 | 6.04 |
SUMP | 2.32 | 3.65 | 5.32 | 2.04 | 4.07 | 6.04 |
Forum | 1.98 | 4.05 | 6.03 | 2.04 | 4.07 | 6.04 |
Like | 1.86 | 4.66 | 5.99 | 2.04 | 4.07 | 6.04 |
UFO | 2.05 | 3.98 | 6.60 | 2.04 | 4.07 | 6.04 |
. | 2.32 | 4.66 | 6.60 | |||
. | 1.86 | 3.65 | 5.32 |
: , . .
, :
. 33.
, . , , .
6.Excel , .
| ... .
. 34.
Excel f(x)=a. - () , f(x), | .... , f(x), : | a, () . , () , ....
, , .
: , , , , , , .
. 35. Excel
, , . Excel , | .... ( ). "...", .
. 36.
:
1. ;
2. , .
3.
4.
. 37.
, . .
, , .
, , . ...
: | , - ( " ") (: I13;I19;I25;I31;I38).
.
- Excel. Visual Basic ( ) "#", . . .
Sub
()
'
' 15.08.99 (bm)
Sheets("
").Select
ActiveWindow.SelectedSheets.Delete
Range("A1").Select
ActiveSheet.Scenarios.CreateSummary ReportType:=xlStandardSummary, _
ResultCells:=Range("I13,I19,I25,I31,I38")
End Sub
, - Excel .
:
1. , .
2. | | ...
3. : , Visual Basic. . !
4. , .
5. " ". .
| ... - - . , ( "", : | | ...).
( , ) "" . " ". ( : ). , , "". . Excel:
" " . , , .
. Caption .
. Visual Basic . :
Private
Sub CommandButton1_Click()
Call
End Sub
"" - , .
Excel - . . .
7. ( )HTML- Microsoft Excel, :
1. , , Web-.
2. | HTML.
3. Web-.
HTML, Web-. | , Web- .
Web-, Web Office 97 Microsoft Office 97.
Internet, Web-, Web Excel 97. | | Web-. Web-. . Get More Web Queries http://www.microsoft.com/officefreestuff/excel.
Excel 97 , Excel 95, Excel 97 . :
1. | .
2. : ... Microsoft Excel 97 5.0/95.
3. .
Excel , :
1. | .
2. .
3. Excel Microsoft Excel 97 5.0/95.
4. .
:
1. .
2. .
3. F2, .
4. (=).
5. , , .
6. Enter.
Microsoft Excel 97, , .
:
1. , . Ctrl, .
2. | .
3. .
4. | . , , .
:
1. , Ctrl+Shift+.
2. | . .
3. , . Ctrl, .
4. | . .
5. | . , , .
Excel ( 12.343 12.34), "" Excel .
. "" .
Alt+Enter.
. . ( , ..). .
. | | .
- ( '001), .
. '\'.
(, ), Excel ##. - , .
8.Microsoft Excel , ( ), .
|
|
SHIFT |
CTRL |
CTRL+ |
ALT+ SHIFT |
F1 |
? | ||||
F2 |
|||||
F3 |
|||||
F4 |
|||||
F5 |
( ) | ( ) | |||
F6 |
|||||
F7 |
( ) | ( ) | |||
F8 |
( ) | ||||
F9 |
|||||
F10 |
|||||
F11 |
|||||
F12 |
( ) | ( ) | ( ) | ( ) |
|
|
|
|
ENTER | |
ESC | |
F4 Ctrl+Y | |
ALT+ENTER | |
CTRL+ALT+TAB | |
BACKSPACE | |
DELETE | |
CTRL+DELETE | |
, , | |
HOME | |
SHIFT+F2 | |
CTRL+SHIFT+F3 | |
CTRL+ | |
CTRL+ | |
CTRL+ENTER | |
, | ENTER |
, | SHIFT+ENTER |
, | TAB |
, | SHIFT+TAB |
= | |
F2 | |
BACKSPACE | |
F3 | |
CTRL+F3 | |
F9 CTRL+= | |
SHIFT+F9 | |
ALT+ = | |
CTRL+; | |
CTRL+SHIFT+: | |
ESC | |
ENTER | |
ALT+ENTER | |
CTRL+ALT+TAB | |
CTRL+SHIFT+" | |
CTRL+`( ) | |
CTRL+' () | |
CTRL+SHIFT+ENTER | |
2 , | CTRL+ |
, | CTRL+SHIFT+ |
ALT+ | |
|
|
( ) | ALT+' () |
( ) | CTRL+1 |
CTRL+SHIFT+~ | |
( ) | CTRL+SHIFT+$ |
CTRL+SHIFT+% | |
CTRL+SHIFT+^ | |
, | CTRL+SHIFT+# |
A.M. P.M. | CTRL+SHIFT+@ |
CTRL+SHIFT+! | |
CTRL+SHIFT+& | |
CTRL+SHIFT+_ | |
CTRL+ | |
CTRL+ | |
CTRL+ | |
CTRL+5 | |
CTRL+9 | |
CTRL+SHIFT+( | |
CTRL+0 () | |
CTRL+SHIFT+) |
, . . Microsoft Excel.
COS() SIN() - .
ACOS() ASIN() - arccos arcsin
TAN(), ATAN() - tg arctg
ATAN2() - arctg x y.
() - .
() - .
() - p
LN(), LOG10() LOG() - , .
EXP() () -
COSH(), SINH() TANH() - ,
ACOSH(), ASINH() ATANH() - ,
(), (), (), (), (), ר(), (), (), (), (),- .
Excel :
1.
2. : , , ,
, . , :
1. ;
2. - Shift+Ctrl+Enter;
3.
() () , . . (), .
Excel . ( 5 , 5 , 5 ..) , (). Excel .
1. . Excel 97 ( ). - : BHV, 1997. - 480 .
2. . Microsoft Windows 95. - Neunkirchen: Buhl-Data-Service Microsoft Corporation, 1995.
3. . Microsoft Word 97. - : , 1998. - 960 .
4. RU.EXCEL ( - 1997 ) Collected by Kirienko Andrew, 2:5020/239.21@fidonet
5. - ( ). - .: . ., 1990. - 335 .
6. http://www.microsoft.ru/main.html
7. http://www.microsoft.com/officefreestuff/excel
8. http://nsvrv.ziet.zhitomir.ua/bmu/Sppp/index.html
9. http://members.aol.com/gjlinker/projects/oraxcel
10. http://www.infoart.ru:8000/it/book/russ_red/excel5/content.htm
11. http://www.infoart.ru:8000/it/book/russ_red/excel5/intro.htm
[1] .
[2] - , CTRL .
[3] , , .
. .. () Microsoft Excel
Copyright (c) 2024 Stud-Baza.ru , , , .