Васильев Научные вычисления в ms excel
DESCRIPTION
Научные вычисления в MS ExcelTRANSCRIPT
-
7/15/2019 MS Excel
1/514
!
" , ,
MS Excel,
. Excel
,
".
Microsoft
Excel, , VBA , ,
, , ,
Excel
..
-
7/15/2019 MS Excel
2/514
"
http://www.williamspublishing.com http://www.diaiektika.com
-
7/15/2019 MS Excel
3/514
MicrosoftExcel
-
7/15/2019 MS Excel
4/514
-
7/15/2019 MS Excel
5/514
MicrosoftExcel
..
"' - 2004
-
7/15/2019 MS Excel
6/514
32.973.26-018.2.7519 681.3.07
""
. ..
"" :[email protected], http://www.dialektika.com
, ..
19 Microsoft Excel. -- M. :
"", 2004. - 512 .: .ISBN 5-8459-0573-7 (.)
Excel -
- . - Excel, , , , , , . - Excel - . - Excel. Excel Maple. -, .
32.973.26-018.2.75
- .
, -, , "".
Copyright 2004 by Dialektika Computer Publishing.Al l r ights reserved including the right of reproduction in whole or in part in any form.
ISBN 5-8459-0573-7 (.) - "", 2004
-
7/15/2019 MS Excel
7/514
I. EXCEL 17
1. Excel 18 2. Excel 109
3. Excel 187
II. 291
4. 292
5. 391
6. Excel Maple 457
506
510
-
7/15/2019 MS Excel
8/514
11 Excel 11 12 14
15 ! 16
I. EXCEL 17,
1. Excel 18
18 18 Excel 20 24
26 27 File 28
Edit 30 View 33 Insert 35 Format 36 Tools 38 Data 40 Window 41 Help 42
44 44 Forma tting 46 47
49
49 51 53 54
55 56 75 88
97 97 103
-
7/15/2019 MS Excel
9/514
106 107
2. Excel 109 Excel 109
109 111 112 - 118 119
Excel 12 1 121 122
125 126 128 133
136 136 139 142
146 146 150 153
157 158 168 174
3. Excel 187
187 188 190 192
V B A 193 VB A 194 File 195 Edit 197 View 200 Insert 202 Format 203 Debug 206 Run 208 Tools 209M e m o A d d - I n s 210 Window 211
-
7/15/2019 MS Excel
10/514
Help 212 214 215 User Form 216
217
224 224
230 232
237 243
246
247 260
II. 291
4. 292
293
Excel 305 317
324
337 337 342 345 353
364
364 373
380 381
383
386
5. 391 392
392
396 402
403 Excel 404
405 416
416 419
8
-
7/15/2019 MS Excel
11/514
420 424
424 428 Descriptive Statistics 436 439 Moving Average 442 444
446
446 452 6. Excel Maple 457
Maple Excel Add-In 458 Maple 460
Maple 461 Maple 464
465 466 467
Maple Excel 470 470 472 475
Maple Excel 483 484 486 488
Maple Excel 490 Excel 490 Maple 492
493 493 495 497
499 502
506
510
510 511
-
7/15/2019 MS Excel
12/514
-
7/15/2019 MS Excel
13/514
Excel . -
. , - . -
.
: , -, , , -
, . - .
, , - , , , ,
" ". ,
. , -
, , -
. , , . ,
, , -
. , . , .
, , : -
( , -
). , , , .
. Excel Micro-soft Office. . ,
, -
- . , , -
( Microsoft Office), , , ( -
Word). , -
, , . , -
Excel . - , , . -
, . , . -
-
7/15/2019 MS Excel
14/514
, , , , - Excel, , . , - Excel , .
- - , ,
. - . , , Excel.
, , , - . Excel. , - , , - . - Excel . , -, , - . . ,
, , Microsoft Office, Excel. , . , Excel . . , , Excel Maple - . , - . . , - Excel .
, . -
Excel . 1 - . , . , ( ). , - Microsoft Office, .
2 , . , , - , .
12
-
7/15/2019 MS Excel
15/514
Excel 3. VB A ( Visual Basic for Applications), Excel - Microsoft Office . VBA, -
, . , Excel.
Excel . , 4 - : , ,
, , , . , Excel - , , (
), - . .
5 - , , Excel . , , -
- . , - .
, 6 - Excel Maple. - , , ,
. - ( , - Excel Maple), , .
, , -, VBA . , "" -. , - . , , , . , ( , ), .
: - , , .. - . , - , , - . , , Excel Maple. , Excel.
13
-
7/15/2019 MS Excel
16/514
Excel 2002
Microsoft Office XP. , , - -
Excel 2000. , - . , - Excel , ( ). , , , - (, , , ..).
. , - , , .
, , .. , - , , . , ( , ). - , , , , , , Excel. .
, , -
[email protected]. ua. - , . - , - .
, .
14
-
7/15/2019 MS Excel
17/514
-
"" . , .
- , -, ,
(Southampton). , . (Tim Sluckiri) , - .
-, . - , .-. , . , . , , - . . , . (last but not least), .
, .
-
7/15/2019 MS Excel
18/514
!, , .
, , - "". , .
. , Web- - . ,
, , , .
, , . - . :
E-mail: [email protected]: http://www.dialektika.com :
: 115419, , / 783: 03150, , / 152
-
7/15/2019 MS Excel
19/514
I
Excel
... Excel
Excel
Excel
-
7/15/2019 MS Excel
20/514
1
Excel ...
, , ,
. ,
-
, .
,
. , -. : ?
.
, , - . , - . , . ,
, .
. , , , . -
, , -
. . , .
-
7/15/2019 MS Excel
21/514
Microsoft Excel Microsoft Office. - , .
, -
, - . , , - , .
, - , -
, - , . ( - ). , , Excel . , Excel , , , Maple MathCAD, .
, Excel ( , ). , - Word, Excel .
Excel . , ,
( , ). - Excel - . , , , . , , , - , .
-, - , - .
[ . , Excel. - . .
, , - .
1. Excel 19
-
7/15/2019 MS Excel
22/514
Excel Excel , , Start
(), Programs () MicrosoftExcel (. 1.1).
- . xsl - . , - .
. , , -, -
.
, . 1.2. (Microsoft
Excel) . Book 1 ( 1). , - , , - , , .
. , , - Microsoft Excel 2002. - , , - .
-3 Accessories
I CJ 3 Startup' Internet E w p t o W fSSephotAnWirus5Mictotoft Oflee Tools|2Microsoft Access: MicrasoftOilfook ;;
OH MicratoftPoweiPorit '[PJ Microsoft Pubfchet_j GhostsoW
AaobatReader5.1@Adobe[SI MicrasaltWofd_r) WWW)
Expforet.ejteas.t .J ;. 1. 1. Microsoft Excel
20 I. Excel
-
7/15/2019 MS Excel
23/514
I F3 Micmsofl Excel - BooklCata Sjndow ttdp
- 1 0 @ , . < 4 WorkbookOpen a workbook __
Notes.xlsForms, xtsE x a m p l e , xkMyData.xls
More workbooks...NewD
Blank WorkbookNew Fromexisting workbook[} Choose workbook...
Newlromjternplate1] General Templates...[J Templates on my Web Sites.,.wj Templates on MicrosoFt.com
!C Add Web Folder...8} Microsoft Excel Help
Irj Show at startupReedy
. 1.2. Microsoft Excel
, , (. 1.3).
Qte * Sew fistrt Format Tools Qata dc
. 1.. Microsoft Excel
. : File (), Edit (), View (), Insert (), Format(), Tools (), Data (), Window () Help (). , . .
( . , Data Chart (). .
Excel , -, , . - (Standard) (Formatting). -. , - , . 1.2. - , - . ( , -
1. Excel 21
-
7/15/2019 MS Excel
24/514
, ), . . 1.4 , . 1.5
.
. 1.4.
E A r W ' - - I : atg; > % ,___-,-:-.-,-,-_-_.. 1.5.
( ). -
( 1 ) . 1.6.
1 .' ' *. 1.6.
, ,
( ).
. . , , , , . , . -
.
( ) . -
: ( , - . 1.6), - ( ) . , , 2 ,
.
. , View^Formula Bar. , .
(. 1.7), (
, , ..), .
Microsoft Office - , .
.22 \. Excel
-
7/15/2019 MS Excel
25/514
. 1.7.
Excel , , , Sheetl (1), Sheet2 (2) Sheets (). (. 1.8).
( ). (. 1.9). -
,
,
. . 1.1.
kSheetl. 1.8.
. 1.9.
1.1.
,
] j 3 , !
. -
.
, .
, , . -
,
. , - . , 1. , , . -
1. Excel 23
-
7/15/2019 MS Excel
26/514
65 536, 256. : Z ,
.. AZ , IV . 16 .
! , Excel - R 1 C 1 . , , -. R , , . , 1
R 1 1 , 4 R4C2 .., (. 1.10).
, . , . 1.10 Ready () , - ( ) ( ). CAPS , (.. : ), a N U M , .
1 1 ~~] ^ ^ ^
Ready
: D i E :
N \Sheet l/ShMt2.^9wet3/ |] * ISum-10 CAPS M UM
F
!
Z
J. 1.10. ( )
, , - 1 4. 10, ( Sum=10).
. Excel , . :
, , , . . ,
.
- . .( . , View^ Status Bar. , .
, .
24 I. Excel
-
7/15/2019 MS Excel
27/514
. - , .
> , - . .
> , - . - , .
> , . , - . - SCRL, , .
> () , . , (). - , Tools^Options (^) Options, Transition (), Microsoft Excel me nu or Help key ( Microsoft Excel Help) (. 1.11).
Color
Vtew Calculationj Save [Microsoft Excel Workbook;Settings
WcrosoftExcel or
-
7/15/2019 MS Excel
28/514
, , , , , , , - G 1, G3, G5 5 . , , ,
G 11 ( ), - I V 1 1 . , G 11 - , .
Distance!6 jD istance2rjOretanceSi%*tance4
Sp e e d!Spe e d2
Sped3Speed4Speeds
Puc. 1.12. , .
1 .
( ) - , ( -) .
- .
. , , . .
, -
,, , . , - .
26 I. Excel
-
7/15/2019 MS Excel
29/514
, ,
. . . , . . , , . In sert (). . 1.13 , . 1.14 .. 1 . 1 3 . Insert
B OWSColumnsSorksheet
Crjart...
BctureHyperink... .
5
Css...BOWS
ColumnsWorksheet
Symbol...
PagegreakFtjnction...
I SameCorimentBcture
Diagram...fibject...
Hyperlpk...
Puc. 1 . 1 4 . Insert
. Alwaysshow f u l l menus ( ) Options - Customize () (. 1.15). , - Tools^Customize. .
Tootjars|Commands OptionsPersonalizedMenus end ToolbarsW show Standard andFormatrigtoobars on two rows
sJTowTtSTmeg*:! . fylmenus after a short delay
* myusage data
fc namestn their font .'ShowScreenjjpson toolbars
. 1.15 .
1. Excel 27
-
7/15/2019 MS Excel
30/514
,
. , -
Hyperlink () . 1.14 . -, , .
.
, , , ,
. -
. , -
, , .
File File () ,
. . 1.16. File . 1.2.
, . , Save as Web Page no . ( ) . ,
, , . , , - . ,
.
a questiwi for f* _ ff x100%
New
Open a workbookNotes.xteMyOata.xlsForms.xlsExampe.xlsMore workbooks
General Tempates,,.Templates on my Web Sites...Templates on Mfcroscrft.com
Mail Recipient (as Attachment)
Routing Recipent...Exchange Folder...
Crtne
1 \Vaslev\ExceNJsting5\Notes.xlsI\Vasfev\ExcelV.istino.s\MyDeta.xlsJ\Vesfcv\Excel\LUtings\Forms.xb1\Vasitev\Excel\Lislhgs\Exampe.xl5Exit
Add Web Folder.,.Microsoft Excel HelpShow at startup
. 1 . 1 6 . File
28 I. Excel
-
7/15/2019 MS Excel
31/514
1.2. File -
New ()
Open ()
Close ()
Save ()
Save As ( )
Save as Web Page(
Web-)
Save Workspace( )
Search ()
Web Page Preview(
Web- )
Page Setup ()
Print Area ()
, -
-.
- Web-
. - -
, -
- . , - , -
- - Web-
.
: Set Print Area( ) Clear Print Area ( ). , ,
1. Excel 29
-
7/15/2019 MS Excel
32/514
. 1.2
-
Pri nt Preview (-
)
Print ()
Send To ()
Properties ()
Exi t ()
-, -
-
,
.
,
Excel
Edit Edit ()
(. 1.17). MicrosoftOffice. , , F i le . . 1.3 - E dit .
D Blank Workbook
New fromi odfUng workbook
General Tempates,..| uk] Templates onmy Web Sites,
. 1.1'7. Edit
30 I. Excel
-
7/15/2019 MS Excel
33/514
1.3. Edit
Undo ()
Repeat ()
Cut ()
()
-
7/15/2019 MS Excel
34/514
. 1. 3
Delete ()
Delete Sheet ()
Move or Copy Sheet
( -
)
Find ()
Replace ()
Go To ()
Links ()
Object ()
- ,
- , - . - -
- . -
- , (, -), -
. -
. 1.17 , ( Undo Repeat, )
( , ),
Can't, . ( . 1.17 ), .
. , , , ,
. . (
Excel), .
32 I . Excel
-
7/15/2019 MS Excel
35/514
, , -
, ,
. , - Repeat .
View View () ,
Excel.
. 1.18, . 1.4 .I Micros of t Excel - Bookl iS]Be E* Be | Insert_ Farmat __looteiD a* HJB-ma
Aral * jffli Eag Break PreviewA1 |*1 Task. Pane
A i loobars . 1|3567
69
1112
14
15Ifi s2021
1M 4Reai
3Statustteada
CustonL'f FyllS!..; . . . . .
a Bar
Bar
and Footer.. .ntsiViews...een
i 1 1;1
i;~ ~~
:
i
J
i
!
M?\J5heeU_/SieeK/Sheets /r/ :
Qaca WJndow relp
JStandard?| Formattffig:^% Borders
Control Toolbox;M Oawng;External Data; Forms
FormiJa AuditingPicture NPivotTable
Protection
, Reviewingjj|TaskPane||Text To Speech,Visual Basic Watch Window
:1Web1WordArt
"Tv!, --.. L.-vr.flr, 0X1 ' : ' ' l "" '.. _ : - * New wtrttock-.V. " , ; . : r x
j . Open a workbookNotes.xlsMyData.xlsForms.xlsExample.xls
j fir More workbooks..., N e w
| D Blank WorkbookINew fromexKtinflworkbookL i]Choose workbook...,: New from template
$ j General Tempiates . , .Lit] Templates on my Web Sites. . -: &j TemplatesonMicrosoft.com
i I
I-lj Q5 Add Web Pokier...
1 l? Microsoft Excel Help!T. [vj Show at startup
HUM. 1.18. View
1.4. View
Normal () . , . 1.18
1. Excel 33
-
7/15/2019 MS Excel
36/514
. 1.4
Page Break Preview( )
Task Pane ()
Toolbars ()
Form ula Bar ()
Status Bar ()
Header and Footer()
Comments()
Custom View s ()
. , -
. ,
- . -, -, - Customize() . 1.18. , -:
( Standard) - ( Formatting)
- (, - )
- . -
- Reviewin g()
34 I. Excel
-
7/15/2019 MS Excel
37/514
. 1.4
F u l l Screen ( )
Zoom ()
. - ,
- ,
. ,
(.. F u l l Screen)
. , , . 1.18 , -
. , - , .
Insert Insert ()
. . 1.19. -
1.5 .
9 6* Bw Inset y=flnnat Jjxte Qata Xflnobw Type ai question^ fo r he!c
HHBOpen a workbookNotes.xbMyData.xlsForms.x!sExampe,xls
Q Morewortoooks...New
>m existing workbookloose workbook...agram...
fibjert...
Hyperlink... +From Scanner or Camera..
? A Templates...esonmyWebates...
Puc. 1.19. Insert
1. Excel 35
-
7/15/2019 MS Excel
38/514
1.5. Insert
Cells ()
Rows ()
Col umn s ()
Worksheet ( )
Cha rt ()
Symbol ()
Page Break ( )
Function ()
Nam e ()
Commen t ()
Picture ()
Diagram ()
Obj e ct () Hyp erl ink ()
. -
, , -
.
Format Format ()
(. 1.20). - . 1.6.
, , . - Cells ().
36 I. Excel
-
7/15/2019 MS Excel
39/514
. 1.20. Format
1.6. Format
Cells ()
Row ()
Co lum n ()
Sheet ()
AutoForma t ()
Conditional Formatting (
)Style ()
-
-
-
, -
1. Excel 37
-
7/15/2019 MS Excel
40/514
Tools Tools () -
. . 1.21. . 1.7 Tools. .
!SJ Be * Bew .Insert Format j loob t 'Qata grtow _D ' ? : : 5"9-Arial - 10 ' U J\.
-
7/15/2019 MS Excel
41/514
.1.7 -
Protection ()
O n l i n e C o l l a b o r a t i o n ( onlin e)
Goal Seek (
)
Scenarios ()
Formula Audi ting ( )
Tools on the Web ( Web)
Macro ()
Ad d -I n s ()
AutoCorrect Options ( - )
Customize ()
Options ()
, -
online
.
-
, -,
- -
-
()
-
-,
-
Tools - Microsoft Office, .
, Excel,
-
. , ( 3), -
( 2 4). , (
) - . ,
( - ), , -
, .
1. Excel 39
-
7/15/2019 MS Excel
42/514
Data Data () , -
. Data . 1.22, . 1.8.
Microsoft Excel - ooklfgj fie E* ew insert Format loots j Qata jJSMowD * Heii u Sa * %i ijti;s o r t . . .Anal - 10. I U ;l *"" """TBBI'.''.*. r-" !:Subtotals...
i Validation..,' labte...
Text to Columns...Consolidate...5roupand OutlineEivotTabteendPivotChartReport...
5 Import External Oata
fonVfaookkbookdfi . x l sxl se.xls
# Sroup...*LSgroup...|M < T"M\Sheetl /ShMttiX Sheets/Ready,
New from | (%'] G
>ir', JtLI Settings...
Puc. 1.22. Data
1.8. Data
Sort ()
Filter ()
Form ()Subtotals ()
V a l i d a t i o n
()
Tabl e ()
Text to Co lu mn s ( )
Consolid ate ()
- ,
-
40 I. Excel
-
7/15/2019 MS Excel
43/514
. 1.8
G r o u p a n d O u t l i n e ( -)
P i v o t T a b l e a n d P i v o t C h a r t Report ( PivotTable
PivotChart)I m p o r t E x t e r n a l D a t a ( )
Refresh Data ( )
-
. , . - , , , .
Window Window () (. 1.23)
. - Window . 1.9.
M i c r o s o f t Excel - Bookl !gj 9 * Sew Insert Format lads Beta [Bn*"|MP
: D*c$SI&Elv I*
-
7/15/2019 MS Excel
44/514
1.9. Window
-
New Win do w ( )
Arrange ( )
Hide ()
Unhide ()
Split ()
Freeze Panes( )
-
. -
. -
, -
, -
. ,
Remove Split ( -),
. - , -
, .
Help Help () . 1.24. -
. 1.10, .
42 I. Excel
-
7/15/2019 MS Excel
45/514
! E Excel - Bookl
M\ShM*l 5 2 / / |l Microsoft Excel Helpiyj Show
at startup
Puc. 1.25.
, -. , . More workbooks ( ). , .
Bl an k W orkb oo k( ) New (). , Excel - . ( , , .) Choose workbook ( ) N ew fromexisting workbook ( ) -
New f ro m temp late ( ):General Templates ( ), Templates on my Web Sites ( - Web-), Templates on Microsoft.com ( Microsoft.com) - ( ).
Web- Add Web Folder (Web-) , Microso ft Excel Help ( MicrosoftExcel), Show at startup ( ) - .
1. Excel 47
-
7/15/2019 MS Excel
50/514
New Workbook ( ) Excel. , . 1.26.
Microsoft Office. Clipboard ( -). , , . 1.27. : 5 (=5), (=1 +3), (4), (name) (1).
24 ,
, .
. 1.26.
Open
G$lNew
D
Newf r Newfrir
-
7/15/2019 MS Excel
51/514
. 1.28.
.
Search Tips.,.WwSearch
-
7/15/2019 MS Excel
52/514
,
.
. . 1.30 . , , . . .
, . - . ' , . , .
, .
! , , , . , , . , , . - . , Edit directly in cell ( ), Edit () Options, - Tools^Options. . 1.31.
. ColorSettings|International I Save'Calcufatan' '_3| Error CnecMngTransport Security! ctw
&Aloweel ! J-agand drop: 17 ( before ovetwlmo. eelsP ve selection after Enter
0ection: [pawn
17 Extend fst formats and formuasP Enable automatic percent entry17 ShowPast*Options buttonsP Stew Insert OpMonsbuttom
Elaces: p"; P Cut, copy, and sort objects with ce8s17 A*toupdate automatic fc*s
,/P Provde feedbackwith Anmation.'7 Enable AutoCornpete for eel values
Puc. 1.31. Edit Options
. , - Excel - . , , - , . - < S h i f t + E n t e r > , , . .
Tools^Options, - Options, Edit() (. . 1.31). Move selection after Enter (
50 I. Excel
-
7/15/2019 MS Excel
53/514
Enter), Direction () - . : Down (), Right(), Up (), Left (). , , . - < S h i f t + E n t e r > . - . - . , - .
, - , . . , , , . . 1.32 -
3. , , , . . 1,13.
. 1.32 .
1.13.
C a n c e l( )
E n t e r ( )
I n s e r t F u n c t i o n ( )
- . , -
< E n t e r > , -
.
I n s e r t F u n c t i o n ( ) , -
, , - , .
, , -
. , , , , . , (+, , , , $, %, I, , ), . .
1. Excel 51
-
7/15/2019 MS Excel
54/514
. (=). , - . - . -, , - . , .
- . :
1. (-). -
(+) . , Excel .
2. , -. , (25) , 25.
3. ., , 10.
, 2, , 2000 ( 2 10 3).
4. . - .
' . - ( ). . -, . , , .
5. (/) . . , Excel , - . , 1/4, 7 (1- ) . , , -
, : 0 1/4. Excel .
6. Excel ( % ) ( ). - , .. ,, .
. ,
. : , , , , . , -. .
52 I. Excel
-
7/15/2019 MS Excel
55/514
! . -, , -
. , . , , , . , -. , .
. , , , , . . -
. , - . , ( ) , .
. , . , , - Format^Cells () - Format Cells ( ) Alignment () - Wrap text ( ).
. -
, . , , . - . .
1. .2. .3. .4. .
, - , . /, () , ( ) () (). () . -, () , ( ) ()
() .
1. Excel 53
-
7/15/2019 MS Excel
56/514
. , -
. -
.
! ,
, -
, .
,
Excel, . -
.
, "
", . 1.14.
1.14.
. ,
( ), -
. ,
. , . , ,
^ . -
^ -, .
-
, -
, -
,
-
: , , - ..
.
54 I. Excel
-
7/15/2019 MS Excel
57/514
. 1.14
.
Q
, ,
^ . , (, , ) . -,
( ,
. , ,
, .
.
. , , -
. (Tools^Options^EditoAllow cell drag and drop ). , , .
,
, , .
Excel ,
,
, , , . -, Excel.
1. Excel 55
-
7/15/2019 MS Excel
58/514
, .
Format^Cells (^), . - Format Cells ( ), . 1.33.
Category:NurrbeiCurrency
AccountingDateTimePercentageFractionScentificTextSpecialCustom
Patterns Protection
General format ce f l s have nospecific number format.
P u c . 1.33. Number
F o r m a t C e l l s
Number (), 12. Sample ().
. , ( Sample) . -, , , Category( ).
Category ( ) ,
. General (). , , - . . ( ) , . , General () , -
.
. . - , . , , , .
56 I. Excel
-
7/15/2019 MS Excel
59/514
General () Number (). , Format Cells
, . 1.34.
, Sample - .
Decimal places ( ), -
( 2).
Use 1000 Separator (,) ( -), .
! , , , ( ,
). Tools^Options, International (). , . 1.35.
Number handling ( ) : Decimal separator (
) Thousands separator ( ).
( ),
( ). - , (.. )
Use system separators ( ).
,
-
. . .
1000 Separator (,)Negative numbers;
Number fe used for generaldisplay of numbers. Currency and Accounting;offer specialized formattingfor monetary value.
Puc. 1.34. Format Cells
Number
1. Excel 57
-
7/15/2019 MS Excel
60/514
Negative numbers ( ) . . , - "" ( ), , ( "") .
Currency () Accounting ()(. 1.36 1.37 ) ,, .
v i e wColor
|Internationa
UK'']*: Chart
Number handhg gedmal separator!]!f~ ta*system separators
PrMhg;pASow M/tetter paper rejsfcdngRgN ' He)
Defautctrection; jgh-to>teft< ? tefMo-rtght
. Wea currentsheet roJMjHeftCursor Rwwjment: f* lop>cal
-
7/15/2019 MS Excel
61/514
. Excel Euro Currency Tools (), -. , Tools^Add-lns, , .
. Date () Category ( ). - . 1.38. , () ( , ,
Sample). ( Locale ( l o c a t i o n ) ) () . - , - .
Nunfcw I Alignment ] Font j Border | Patterns j Protection |;Samite-''-Decimal paces;
jjSne M p the currencysymbols and decimal panesnaP u c . 1.37.
Wednesday,March 14, 200 13/H3/14/0103/14/0114-Mar14-Mar-Ol .ZJLocate (location);i ' ' -'{English (United States)
! formats dspay date and time serial numbers as date values. Except foritems that have n asterskO appted formats do not switch date orderswth the operating system.
Puc. 1.38.
1. Excel 59
-
7/15/2019 MS Excel
62/514
Time ().
Format Cells ( ) . 1.39.
(.. -
), Percentage () Category
( ). (.. 1) 100 (.. 100%). , , 12 1200%. . 1.40,
Format Cells ( ) .
13:301:30 13:30:551:30:55 30:55.237:30:55locate(ocation):
/ date and ttraeseral numbers as values, Except for>en astersk(*)/af fedformats do not switchdate of timeorders with the operating system.
P u c . 1.39.
Number j AUgment j Font | Borderj Samite -TJ | 1200.00%
, gedmal places:
Percentage formats rnufeply the cdvalue by 100 and (Jsplays the result wtthe percentsymbd.
Pwc. 14(7. -
60 I. Excel
-
7/15/2019 MS Excel
63/514
, , . . - . (), ,
Fraction (). . 1.41. , , Excel,
( , ). , . () . -, (U p to one digit (1/4) ( )), , -
. (Up to two digits(21/25) ( )), . (Up to three digits (312/943) ( )) , . , (, , ..).
Up to two digits(21/25)Up to three dg ts (312/943)Ashalves (1/2)As quarters (2/4)Aseighths (4/8)As sixteenths (8/16)
Puc. 1 . 4 1 .
. - Excel . , , , . , 0113/199 ( , - ) , - 0.5678391959799. , , . , Up to one digi t (1/4) ( ), 4/7. Up to two digits (21/25) ( ), 46/81. , -
1 Excel 61
-
7/15/2019 MS Excel
64/514
(Up to three digits (312/943) ( )), - 113/199. , - 0.5678391959799, . Excel -
. -, . (), . , (), ( -). Excel -
. Decimal places ( ), . 1.42.
Form at Cells ( ) Scientific( ) Category ( ).
( Text) ( Nu mb er), (. 1.43). , . , , .
, , . Special ().
Forma t Cells , . 1.44. . () -
. -
( ), - . - , , Locale (location) (/).
Number | SSgrment j Font ] Border | Patterns j. Protection |-rSeipte-"-I 120-
Puc. 1.42, -
62 I. Excel
-
7/15/2019 MS Excel
65/514
Number |Alignment^Category; '..
GeneralNumberCurrency
AccountingDateTimePercentageFractionScientific
Font|BorderIPatterns:| Protection|.-Sample---
12
Text formatcefe fttreatedastext even when a number is in the Veel.- The celt dspayed exactly asentered.
SpecialCustorr
Puc. 1.43.
.Number J AlignmentCeteW:
IVPe:
Social Security Number
_| locate (ocation):(English (United States)
J~3Specialformats are useful for trackingfistanddatabase values.
Puc. 7.44. . , , -
. .
, Excel .
Custom ( ) Category ( ). . 1.45.
, -
. ,
, . -
, . 1.15.
1. Excel 63
-
7/15/2019 MS Excel
66/514
Number ( f a r m e r * Font Border Patterns Protection
Type the number format code, using one of the existing codes as a startingpoint.
Cancel
Puc. 1.45.
1.15.
. -
, - ( (.)) ,
12 0.00, 12.00. 0.00 : () , . -, 0.1, - ( General) . 0.00 ( , Custom Number ( - ), 0.10. : 12 000.000, 012.000 , , -
, , .
, ???.??? 12 12. (.. ). , -
, " ", ..
# , ,
, . - ( ?) -
. , ###.### 12, , 12., .
, , -
, , .. (, .123)
64 I. Excel
-
7/15/2019 MS Excel
67/514
.1.15
% .
100 (.. %)
, .
, , , , . , , ,
, ###/###. 1.2345 458/371. # ###/###, 1 87/371. . -
, , 00 ###/###?
, , : 01 87/371, , ,
. , -
, ,
. (+),
(). , - , .
() , -
. . , 123 0.##-00 1.2302, 0.???+000 1.23 +002. 0.###, ..
. ,
, . (
0.???+000)
, ,
. -
. ,
, . ,
( ).
, \R 0,
R. ! , .. , R
, " "
_ . ,
,
@ . ,
. , -
, .
, Baden,
@-@, Baden-Baden. :
, , .
Baden
1. Excel 65
-
7/15/2019 MS Excel
68/514
. 1.15
. , , , . , 12 0*, 12 ( X )
. . -
($, ,+), . , -
. , #,### 10000000 10,000,000.
. , , , . , . , 1234567 #,###, 1,235 (.. , 1234567). , .. 1234567 #,### 1. ,
, . - , , -
. -
, . - .
. ( ) -, . ,
. ( ), -
Format^Cells. , Sample () - .
, Excel -
, ,
, , " ". : , -
( ). : , , . -
. - .
1. , -, .
2. , , -
(.. ), -.
66 I. Exce l
-
7/15/2019 MS Excel
69/514
3. , .
4. .
Excel .
, ,
. " ",
. - , .
. 1.16 , , . 1.16.
Black
Blue
Cyan
Green
Magenta -
Red W h i t e Yell ow
, COLORx, 1 16 ( 56). .
, COLOR .
. (.. ,
) Formats Conditional Formatting(^* ) . .
, -
Custom Category. , -
. : , , -
. , -
.
. ,
.
, . .
, , . -
,
General () ( Excel). -
1. Excel 67
-
7/15/2019 MS Excel
70/514
, ( ). -
, ,
, .
.
.
. 1.17. 1.17.
. ,
. = ,
. = ,
. , , ,
.
( , , -
).
. .
1. Excel . - 1 :2.
2. Format^Cells (^) - Format Cells ( ) Number ()
Category ( ) Custom ( ).
3. , () [>10][blue]0.00;[red][
-
7/15/2019 MS Excel
71/514
[>10]). , ( [blue] ) . ([
-
7/15/2019 MS Excel
72/514
. Text alignment (- ) : Horizontal ( ) Vertical ( ), Indent () Jus ti fy distri bute d ( ) ( -). Horizontal . 1.18. .
1.18. Horizontal
General () . - ,
. In de nt ( 0 15 )
. - Indent
. , - , , . , - .
, - . - -
. - . ,
. - -. ( -), - ( Center ( )) , -. Indent () ( ). Justify distributed ( -) 0 Inde nt (), , - Dis tribut ed
. ( Indent) , ( ), ( ) . ; (- ), .
Left (Ind ent ) ( /)
Center ( )
Rig ht (Inde nt) ( /)
F i l l ()
Justify ( )
Center Across Selection( )
Distribu ted (Indent) (/)
70 I. Excel
-
7/15/2019 MS Excel
73/514
. - , Vertical, . 1.19. - , .
1.19. Vertical
( )
Center ( ) Bottom ( )
Just if y ( )
Distributed ( , -) Text control ( ) .
> Wrap text ( ) , . - .
> Shrink to fit ( ) - , .
> Merge cells ( ) . , (
) (.. - , ).
. Shrink to fit ( ) -
, . , -
, , - . , Shrink to f i t , . , -, .
Text direction ( ) Right-to-left( ) , (.. ), -
. Excel , ,
. Orientation (). Text ( ), -
Degrees (). , ,
, , .. -
1. Excel 71
-
7/15/2019 MS Excel
74/514
. , ( -90 90 ) , . Degrees, . -
.
I . , . , -
.
Font (). . 1.48.
This isa TrueTypefont. The same font wbe used on both yourprinterand your screen.
Puc. 1.48. Font Format Cells Microsoft Office -
, . . 1.20.
1.20. Font
, Font ()
Font style ()
Size ()
U n d e r l i n e ( )
Color ()
(, , - )
-
72 I . Excel
-
7/15/2019 MS Excel
75/514
. 1.20
,
Normal font ()
Strikethrough ()
Superscript ( )
Subscript ( )
Preview ()
( ) . - -
-
. .
Border () (. 1.49) , -
Excel .
Presets ( ) , -
.
Outline () -
. Inside () ,
. , .
None () ( , ).
Border , -
, , -
, . , , -
, .
Number j Alignment j FontPresets Si .P..t^one Qjjfctere
Patterns j Protection j: -
. . . . Qtor :
! ; ir:; ^ - J j \j"The iseiftted border ^vfe canbe appliedbycSd*gpresets, previewdiagram ofthe buttons above.
Puc. 1. 49. Border Format Cells
1. Excel 73
-
7/15/2019 MS Excel
76/514
, Color () , Style ( -
) . Line ().
Patterns ()
. Format Cells
. 1.50. Color . , -
No Color ( )
, Pattern () .
Sample ().
, Protection () (. 1.51). . : . - - Number.] A f i g n m e nCell shadingColor:
:;S i. a: a i : . ,::;i';;
Pattern;
Puc. 1.50. Patterns Format Cells
Number | P (petted
eels orhidios formulas ha s no elf ect gntess thetvor&sheet Is protected. To f^tAect worla^ieet, draoseProtection f r o n t the Toote , end then choose Protectt.A(Msswordisoptional
Puc. 1.51. Protection Format Cells
74 I. Excel
-
7/15/2019 MS Excel
77/514
, -
, ( ).
, - . , -
.
-
, . -, Excel, . 1.21. 1.21.
(x 1( f )
0,0579
0,1080
0,14900,2270
0,7780
1,4320
2,8710
4,4980
5,9150
(xlO )
3,302
48,690
59,7406,418
18990,000
5685,000
868,200
1024,000
0,130
() - (. .)
4880
12104
127566794
142985
120536
51118
49528
2300
0,38
0,91
1,000,38
2,36
0,92
0,90
1,10
0,07
. , -. .
R. Freedman, W. Kaufmann, Universe, W.H. Freeman and Company,New York, 2002.
Excel. , - , . 1.52. - .
. , ,
, .
1. 2:15 . : Format^Cells, Patterns - Pattern (. 1.53).
1. Excel 75
-
7/15/2019 MS Excel
78/514
. 1.52.
Edt Insert Format loot Bata Jndcw, < S ' * *- -;'* -
D
M l '2 5: : . 3" ...' :.
Sample
'Ready
\Sheet 1 / 5heet2 '/She'
-
7/15/2019 MS Excel
79/514
2. . , 2 : 1 5 , Format^Cells - Border (). Style ( ) ( ), - Outline () (. 1.54).
3. -, -. C5:G14 (. 1.55). . - Format^Cells Patterns, Color No Color ( ) (. . 1.55). .
4. - . -. Border Format Cells - . . 1.56, ( Style). Outline ( ) Inside( ). .
ob p_ata Window 10 - /
New Workbook; Open w o r k b o o k
Solar_System.xlsNotes.xls
Alignment for* Border Patterns Protection
,Jgjx)_VX
I VAutomatic JJj
"He seled bwder styte carv bee p f&e d faycSdong the prea s,p-eviewdsgran or the buttons above.
Caned
7> Nsheet 1XSheet2 / /Ready
ShowaFslartupMJM
Puc. 1.54.
1. Excel 77
-
7/15/2019 MS Excel
80/514
. 7.55. . . . , Color ().
5. D5:G5. - ( , ). - , Alignment () Format Ce lls (. 1.57) Horizontal Vertical ( - Center). , Wrap text - , . , 90 (. . 1.57).
6. . 1.58 C5:G5, (, 5). (.. - ) Format^Cells, Font - Font style () Bold ().
78 I. Excel
-
7/15/2019 MS Excel
81/514
~
-
7/15/2019 MS Excel
82/514
&tt View Sert Farmat loote , Qata Window- ui \ (3 ?
G H ~- * Workbook_- .11 Open a workbook5olar_Systens.xlsNotes.xls
MyData.xte
. I l l'S' Number I Aigrment Font | Border | Patterns | Pg Eont: . . Fontstyto; :
> T AlgerianAndreAntique Olive HIS3 (Bold Ital
:: > , : ; ; ' 0*::jNohe
Effectsj Strsethroughi Suoe-scrpt
rPI AaBbCcYyZz ]
TNs is a TrueType font. The same font wS be usedonboth your prnts*andyour screen.
Sites...
t.com
|"< \Sheetl5heet2 /5/[eady
:P M C . /.55.
7. 5 , . , -, . Border ( Style), - ( . 1.59, ).
8. 5 - ( Justify Vertical Alignment). Wrap text ,
, . . 1.60 .
9. 5 . - , ( - -). , ( ) , 5, . 1.61.
80 I. Excel
-
7/15/2019 MS Excel
83/514
i-
I-;
:
fi!
5
-
7/15/2019 MS Excel
84/514
Microsoft Excel - B o o k lje gdft Sert Fs-mat loob Eata SJrdow
^ c 4 - |-:S'B. v'. . '" .
"*.X
f* JL I E : : j__J
Puc. 1.61.
10. , - , , - . . , - , , .
C5:G14 (. 1.62), Patterns.
11. D6:G14, - (. 1.63). -
, .12. ( 6:14)
, ( D6:G14). , C8:G8 ( ) - (. 1.64).
82 I. Excel
-
7/15/2019 MS Excel
85/514
0 cft Sew Insert Format I*s
PMC. 162. ( )
\ !', ; -J
J ~ (mbiw | AJgnna* I Per 1 Boner Patterns j fntKOan ]
Puc. 1.63. ,
1. Excel 83
-
7/15/2019 MS Excel
86/514
ill. 1.64.
13. G6:G14 ( ), - Format^Cells Form at Cells Number. Category Custom [Red][>1]0.00;0.00, . , 1 (.. , ), . - , . . 1.65.
14. , , C3:G3 (. 1.66).
15. (. 1.67), Ali gn m en t Form at Cells - Merge cells ( ), ( Center Horizontal). - ,
.
I. Excel
-
7/15/2019 MS Excel
87/514
121314
ISj16 J18]19, \ Chartl"J ir
.s4880
12104
12756
6794
142985
120536
5 1 1 1 495282300
s . **
0 9 1 t j
. :0 . 90 J1 101
'51*2 /Sheets/ v. 1.67.
16. , ( Bold Font style Font), 13 ( Size , ), Underline () - Double Accounting (, ), Color - (. 1.68). Excel , , . 1.52.
, . - . , , -, . , . , . , , . - , . - . 12000 1 . 1 (.. ), - ( , -
) =1 .2* 1 ( : ). . 1.69.
86 I. Excel
-
7/15/2019 MS Excel
89/514
: in1 ;
v eC3
A
: Vjew insert Fgrmat Tools ^H ,
.-. . ' ,. i
- -
- , ' ' . , % - ? j-wt ;^i -.o,ll 0 I E i Fi G|
.=--
TNs is a TfyeTypefont. TtMidyour screen.
PMC. f .65. , . 1.70.
, , -
1 Scientific (), - Format^Cells Category Number. . 1.71.
SUM X/ )6 =1 2*1 OMA
1=1. 2*1 DM2
1 j ~ .p
2 . %;i
j , - > . A ' - ! , i12000 ""
1 $ =1.2*1012|;. I I !1 1 .20E404I: ; i [
. 1.69.
. 1.70.
. 1.71.
1. Excel 87
-
7/15/2019 MS Excel
90/514
, . Formatting (), . , , , , - .
-
, . Excel , - . , , Format. Cells -. .
Row (), Column () Sheet () -, , , - . . 1.22-1.24 - , .
1.22. Row
Height () , -
. 12.75. , . ,
( ) -
Au toFit () - ( )
Hide () . -,
U n h i d e ( ) . AutoFit () ., - , (, 20 10), . ( ), AutoFit, . , ,
, 20, - . , .
88 I. Exce l
-
7/15/2019 MS Excel
91/514
EditO1=> (1^1^)( ) Edit^Clear^Formats(^^) ( , ). , ( ) ( Unhide). , -
(, ) ( ) -
. , Unhide. , ( ) U nh ide .
I . , . , . Cell () Row.
1.23. Cell
W i d t h ( ) ( -, , ). 8 . 4 3
AutoFit Selection ( ) ,
Hide () ,
U n h i d e () S t a n d a r d W i d t h ( -
) . , "", , -
. - , (, -).
. , , , , - .
1 . E x c e l 89
-
7/15/2019 MS Excel
92/514
Sheet () , - . . 1.24.
1.24. Sheet
Rename () .
.
Hide ()
Un hi de () . .
Back ground () . , - , . , , Delete Background ( ).
Tab Colo r ( ) .
,
. ,
I . , , ., . 1.72, ,
, First (),Second () Third (). (First) , , . (Third) . , ( - Windows).
, , .
Format . - A u t o F o r m a t (), - , . ( ) -
, . 1.73.I . AutoFormat - Formats to apply ( ), Options () .90 I. Excel
-
7/15/2019 MS Excel
93/514
Sheel_Foiraat.xU
ill"PMC. 1.72.
EastWeslSouthTotal
Jan
a21
Feb
18
Mai5
921
Total19172460
EastWestSouthTotal
j a r t Fet>7 7
6 48 7
21 18
Total19172460
(1 5
East 7 5 19Wt 6 4 7 17South 8 7 9 24Total 21 18 21 60
Classic 2East
WestSouthT otal
7 J
821 J
1I7
18t
_ nul_J 19 ,
24 :fJ 60
EastSouthTotal
Jan7 J8
21
Feb7718I
Total
J 1917
$AorajntingJ
Pfex-tferPuc. 1.73.
, . , Formats to app ly ( ) , , - ( N umb er, Border, Font, Patterns, Alig nm en t, Wid th/ Hei ght ).
Cond itio nal Forma tting ( ) , - . - , . , . 1.74.. -
1. Excel
-
7/15/2019 MS Excel
94/514
: Cell Value Is () Formula Is (). , .
Condtion].
Preview of format to usewhen contSttonls true: No Format Set
fidd I Qeiet... |
P uc. 1.74. Cell Value Is
, :between ( ), not between ( ), equal to (), not equ al to( ), greaterthan (), less than (), greaterthan orequal to (
), less than or equal to ( ). ( ) ( ). ( ) .
, , , , Format. Format Cells, , , . -
(Font, Border Patterns), , , .
, Conditional Formatting Add ( ). . . . 1.75.
1 Conditional Formatting 1Condition i
l- 'Vjcel Value Is; when
| - , " - J c e l Value Is
_ j Jbetween j J 1'T A a B h Cjjj lessthan J-J 15
Preview or format to use j AaBbCwhen fs true: 1
Cond; on2 i_J (not equal to _] 0
; Preview of format to use * -.ou/ wr condtion is true: .
Jj ' I
iJand | .. . 2J 'irvyz; Eonnat... j
. -3cYyZz | Fjjrmat... |ij;.cYyZz format... [
Betete... < Cancel
Puc. 1 . 7 5 .
92 I. Excel
-
7/15/2019 MS Excel
95/514
: (Condition 1) , , .
, (Con dition 2), .., (Condition 3). , . 1.75 : 1 10, - . 15 ( ), - . -, 0, .
, , (. 1.76). 1 :2. 5,10,12 18. , 12 , 18 - . 0 (.. - ). : (5 10) ( ), - .
12 , . , 18 , .
, Conditional Formatting Delete (). , . 1.77. ,
( ) . .
. , - Co ndi ti on al Fo rm at ti ng . .
, (- ). - .
t=I ! \Sh/Sh.|
. 1.76.
Delete Conditional Formal jSelect the con*on(s)todote:
~ Condtioni
. 1.77.
1. Excel 93
-
7/15/2019 MS Excel
96/514
Cell Va lu e Is Formula Is. Conditional Formatting , , . -
( ) , .
. , 1, =1 >2. :
1 2 ( , Excel - ). - (. 1.78), .. 1 , 1 2. , 2 , - 1 2. 1, 3, 5 7. . 1.79.
alsPreview of format to usetrue:
Puc. 1 . 7 8 . . 2 .
1, ( EditCopy) ( ), 2 Edit^Paste. 1 2, . - , .
OJ I oim uld s ^ F oim a l xl t . 1.79. ,
, (, ) - 2, 2 2, 1 , 1 2.
Format Style. , . 1.80. - , . . , .
94 I. Excel
-
7/15/2019 MS Excel
97/514
Style Style name
( ) . FirstStyle. Modify ().
Format Cells.
, ( -
Format Cells). Format Cells , Style includes () . . 1.81 -
,
(Scientific), -
, Times New Roman 12, , .
, -
( ) , Formats Style. , Style name ( ) -
(FirstStyle) . . 1.82 -
1 :4, -
.
5tyle includesNumber . . . General )|* General, 8
-
7/15/2019 MS Excel
98/514
, , D1 :D4 , , Patterns () Number(). , 1 1 (. 1.83).
_. _ _ _ _ _ _2 . . J ' t e x t , t e x t t e x t
very long v e r y long 1 v e r y long3 : text text text4
5
|
: ~M t > >\Sheetl/Sh*2/5h|
-
7/15/2019 MS Excel
99/514
-
. , - .
, -
, -, , -, , .
', Toolbars
( ) View () .
, ,
. Microsoft Office.
. 1.25, -
, .
, View1*Toolbars. 1.25.
Standard ()
Formatting()
Borders ()
. -. - , , -, , ,
,
, . - : -
, , , , -. , ,
. - , - . ( , , ) ( )
1. Excel 97
-
7/15/2019 MS Excel
100/514
. 1.25
Chart ()
Control Toolbox( )
Drawing ()
External Data ()
Forms ()
Formula Auditing
( )
Picture ()
P i v o t T a b l e
P r o t e c t i o n ( )
Reviewing()
Task Pane ()
Text To Speech ( )
Visual Basic
Wa tc h Wi ndo w ()
Web
Wo r dAr t
. ,
. , -, , . - , ,
. . (, , , ..). (, )
.
, - .
-
-
. , ,
,
- Excel
, VB, ..
, -
WordAr t
98 I. Excel
-
7/15/2019 MS Excel
101/514
, - , . , -, View^ToolbarsoCustomize Customize () Commands () (. 1.84).
add command toa toolbar:command out of this daM) box to aCategories; C o m m a n t f a :
Puc. 1.84. Customize
Categories () (, , ). - Commands (, , - ). -, , , , "" ( , , ). . 1.85.
Formatting Pattern(). , . , , . , Mo di fy Selection() Customize (). . 1.86. - . 1.26.
( . - Exit (), File ().
1. Excel 99
-
7/15/2019 MS Excel
102/514
Bte'.""'. gdft $ew Insert format loofe ata V^indow fcteJpf"5! --5? f~5 ^ fd j WO- V 1~H f 3 -'"^f -~ r- *1 i *" [r J fey LC v - d? 1 * '*/ j ,*?Arial -r 10 .; .p -..J ,,U.
BJ.
'Toofears fipmtnands | QpTo add acommand toa todxcommand out of this datogboCategores:.; ' - . ' (.
y anddrag the
T ool sDataWindow and HelpDrawingAutoShapes
Selected command;Descrtetton
AD BordersBottom Double BorderF t f l Color I > aPattern
Dark Shading
> W \Sheet 1/sheeE./ sheets/Ready
O p e n a workbookM yStytesJ .x J sFormat_Cond,xlsFormulas_Format.xlsSheet_Format.xls
Q More workbooks.,.New
D Blank WorkbookNewfromexisting workbook
j!ky Choose workbook..,New from template
) Genera!Templates...I Templates en my Web Sites..,j Templates on Microsoft.corn
Add WebFolder...(3 Microsoft Excel Help| (] Show at startup
N U M'3 i ' ' ) ( f j :
. 1.85.
Reset
Delete
Name: E&xtCopy Button Image
Paste Button Image
Reset Button Image
dit Button Image...Change gutton ImageDefault Styte
!Tea Cyiy (iMenus)
Image and TextBegin a Group
AssignHyperink. Assign Macro...
Puc. 1.86. ,
Modify Selection
100 I. Excel
-
7/15/2019 MS Excel
103/514
1.26. Modify Selection
Reset ()
Delete ()
Name ()
Copy Button Image
( )
Paste Button Image( )
Reset Button Image( - )
Edit Button Image( - )
Change Button Image( )
Def aul t Style ( )
Text Only (Always)( , )
Text Only (in Menus)( , )
Image and Text( )
Begin a Group ()
As si gn Hyp er li nk
( )
Assign Macro ()
-
, - ( )
()
. ,
, -
- , .
,
, -
( ). , - ( )
. :Open (), Insert Picture ( ) Remove Link ( ), . -
, -. Insert Picture ( ) , . , Remove Link( ), , - ( Edit Hype rlink ),
. ,
1. Excel 101
-
7/15/2019 MS Excel
104/514
, Edit Button Image (
) . -
. 1.87.
Picture C o t o f s
1. 1.87.
Picture ().
Colors () .
Picture, -
. ,
, Erase (). - . Clear(). Preview ( ) -
, . Move () , -
, , .
, -
. , Cancel.
. ( -), , , .
Customize (, -
Customize), , , ,
Customize (), - , .. -
, , , -
. , -
. , - Built-in Menus ( ). .
102 I. Excel
-
7/15/2019 MS Excel
105/514
,
Excel ( Microsoft Office), . , - Customize Toolbars New (. 1.88). New Toolbar ( ) (. 1.89), - .
. Excel . , Excel. , - . - , , - . - ( ). Toolbars Attach (), Attach Toolbar ( ) (. 1.90). - Custom toolbars ( ) (). , ( Toolbars Delete), ( ).
Toofears I Commands | Options |Todba/st
Formatting3-D SettingsBordersChartChart Menu BarCircular ReferenceControl ToolboxDiagramDrawingDrawing CanvasExit Design ModeExternal DataFormsFormula AuditingFull Screen
Organization Chart
Puc. 1.88.
Toobar name:
. 1.89.
1 Excel 103
-
7/15/2019 MS Excel
106/514
Attach T o o f b a i sToolbars inworkbook:
EuroPlaceholder 2000 "3
Caned
P u c . 1.90. , Attach Toolbar,
Toolbars in workbook
( ), Delete, -
. . Commands
Categories New Menu ( ). -
, , Commands, ( ),
(. 1.91).
.fj jjjfe |d ew Insert Fo/mat loob fiata KJndow tt*J s # d > < a :sa ? v ' x % e
-
7/15/2019 MS Excel
107/514
, -. Mod ify Selection(), Commands Customize. , . - . Name () (. 1.92). ( My Menu).
\Sheet l/Sheet2/Sheets/
PMC. /.52. , ,
. - . , - .
:
1. Customize.2. .
3. Comm ands ( Customize).
4. Mod ify Selection.
5. Delete (. 1.93).
1. Excel 105
-
7/15/2019 MS Excel
108/514
Format_Cond.xlsMySylesJ ,xlsFormulas_Format.:dsSheet_Format.xls
-
7/15/2019 MS Excel
109/514
.
-. , -
. , -
, ( ) -
.
.xlt. . 1.27 -, Excel.
1.27. Excel
Excel
x l w . , , ..
_ _
, . ,
Excel. , - , (, , ..). -
, File^Save as, Save as type ( ) Template (), - Save.
! -
, . , -
General () Templates (), - .
, , ,
General Templates ( ) New from template
( ). Templates, -
. , -
, .
. , .
Choose workbook ( ) New from exist ing workbook
( ). ,
.
1. Excel 107
-
7/15/2019 MS Excel
110/514
. Excel , X L S t a r t ( C:\Program Files\Microsoft O f f i c e \ O f f i c e 1 0 \ X L S t a r t , -
, ), . , Book.xls -
(), Sheet.xls - , Insert^Worksheet (^) . , , -
Excel. . -, - , -. , . , Excel. -, -, , - - , Excel . . , - , , -, .
108 I. Exc el
-
7/15/2019 MS Excel
111/514
2
Excel
... Excel
Excel
J3 , Excel. , Excel , ,
. , - , . , Excel . , Excel - .
Excel ,
. - .
, . . , .
( ). 2.1 2.
( -), , , (. 2.2) , , . . .
-
7/15/2019 MS Excel
112/514
. 2.1. 2 . 2.2. -
, , . , Excel, : . , -, , - . 2 =3+4.
. Excel (+), - (), (*) (/). Excel (). -. , ( ).
. 2.3. , ,
. , SUM . -
. , - . 2.4.. , - ( : ).
. 2.3. . 2.4. -
. , , 2 . , .
, 2. 2 .
, 2 - 7 3 4. - : , - .
110 I. Excel
-
7/15/2019 MS Excel
113/514
, . . - , . . 2.5.
. 2.5.
, , .
Excel ,
, . , . , , - .
.
, , ( ) - .
( ! , R 1 C 1 , . (), -
, . - . t
S, S = gfl2. g , 9,8 / 2. .
( -). , 1 g, 2 t A3 S . . 2.6.
. 2 - 9.8. 2 1, - .
| . .
2 =2*22/2. - , . . 2.7 2.8.
, ( ). . 2.9.
2. Excel
-
7/15/2019 MS Excel
114/514
. 2.6. -
. 2.7. - -
,
. 2SUM
; A ii t2 f 9.813_j i...4i
X - J A =A2*B2 ! _ sl)*B2A2/2
f
2/2|
. 2.8. (2 2),
. 2.9.
2 (4.9 ).
, - , - . , ,
, . - 2 2 . 2 . . 2.10 , .
S3
19.6
. 2. 1 0 . ,
Excel , .
Excel . ,
.
, -
, , . -
( , ). -, , ( ).
Excel . , , ( !). , ,, , .
112 I. Excel
-
7/15/2019 MS Excel
115/514
. .
, . - - - .
. , -
, -
. , - , .
. ,
. .
,
, . , , , -
, ( !). - , , , .. , , , . -
. .
.
, =12, 1 ,
(. 2.11). 1 2. , ,
, 1 . . 2.12. , ( -
), . 1 ( , , ), .
5. , EditCopy (1^ ). , , , - ( ). 5 -
EditPaste (-=> ). . 2.13.'X^ jt = A 1 "2| 4
_ _8 .1 ,) 211= *M~l~iS*EZ 6 ~ \ i ! !
. 2.11. -
. 2.12. -
2. Excel
-
7/15/2019 MS Excel
116/514
5 16, =2. - . , 1 . , 1 , 5, -, , , 5. , . , , D4, 2.
. 2.13.
16 5. , , =12, , 1. 5 , , , , 1. . , - . 1, - 5. .
. 5 -, Paste () . , , . 2.14. -
( 5). - Keep Source Formatting ( ). , . , , 5 4, , 5, Values Only ( -). 5 , . . 2.15. , - 1 , 5 . ($). -, 1 , $$1.
, , . . =12 =$$12. . 2.16. -, , , - .
5., , . 2.17.
114 I. Excel
-
7/15/2019 MS Excel
117/514
Match Destination FormattingValuesOnyValues and tjumber FormattingjValues and Source FormattingKeep Source ColumnVjidthsFormatting OnlyUnkCefc
Puc. 2.14.
C5
_LValues and Number Formattingj Valyes and Source FormattingJKeep Source Column jtfjdths
"Jy Formatting Onty
e
Puc. 2.15.
83 . =$AJ12 . 2.16.
. 2.17.
2. Excel 15
-
7/15/2019 MS Excel
118/514
5 , (, , ).
. , , . , . .
. , , . , - .
, , . , $ , () , (3) . $3, , -, .
. -, . , ,.. , , -. , ( ), . - , , , - . , , - .
. . , -, .
, , 1 , 1 1 g( ), t () S ( ) -. 2 (9.8), 2, , 4 5 1 4, . . 2.18.
2 =$$2*22/2. , . 2.19.
, , , ( 2), ( $$2), -. , - .
116 I. Excel
-
7/15/2019 MS Excel
119/514
. 2 . 1 8 .
. 2.19. - 2
(. 2.20), , -
. ,
( EditCopy). , (
), EditPaste. . 2.21. ,
, . ,
2 , . , 2 . 2 .
. 2.20.
.221.
4 5, . , . 2.22.
. 4 5
2 . - . , -
. - .
. 2.22.
2. Excel
-
7/15/2019 MS Excel
120/514
. , , -
, , -
, . $$2 $2. . 2.23.
. ,
:5 (. 2.24). ( !), (. 2.25). , , -
, (. 2.26).
2 * =AJ2*B2A2/2D
9.8i j.g
. 2.23. -
. 2.24. -
5 JS =$2*5'-2/2J A . 8 L__c_1, .1 Owl
s in new workbook-Standardfor*IXeu* ffle location: , . '
: At startup, alfites n;Userpame:
Puc. 2.27. Options General R1C1 reference style (
R1C1). R 1 1 .
, .
( ) (, ) , . , . , ,R[-2]C[3] -, . , -
. , R2C3 2.
. , .
, . , , ( ), .
I ! R 1 1 !
, Excel - , , - . - , .
- .
2. Exc el
-
7/15/2019 MS Excel
122/514
. , 1 ( Sheet"!) 2 ( Sheet2), =Sheet2!B2.
( , ), - . , , , . . , , , - , . - . , 2, Sheet2 B o o k l , =[Book1]Sheet2!B2. - . -. .
1. , .
2. , .
3. , - (.. , ).
4. ( ), . . ,
, :
1. , , . , .
2. , . . , Window (), . - ( Window), .
3. , , .
. . , -. Excel , -
. , -
Excel. - , , - .
120 I. Excel
-
7/15/2019 MS Excel
123/514
Excel Excel -
. (). , , , . Excel - ( ) . -
, , , . , (.. -) .
, , , .
, , ,
. I n s e r t 1^ F u n c t i o n(). Insert Function, . 2.28.
Select a function ( ) , . ,
, .
, , , Or select category ( ) - (). Select a f u n c t i o n - . , , (, ), Or select category ( , , Logical Financial). , .
Search for a function:Type a brief ddick Go
ription ol" what you want to do andmen
Or select a jategory; JKust Recently Used . -Select a function;
IFAV ER AG EHYPERLINKCOUNTMAX
SIN
SUM(mJnberl .number2....)Adds althe numbers in a range < rf eels
-Heb on this funrtron
Puc. 2.28.
2. Excel 121
-
7/15/2019 MS Excel
124/514
, ,
Search for a f u n c t i o n ( ) InsertFunction . Excel
, .
. ,
, - -
.
, ,
, . ,
.
. Insert function( ), . - Insert Function, .
Excel.
. . -
. , -
, . ,
.
, - .
, . 2.1.
.
2.1.
ABS() .
, A COSQ
ACOSH()
A S I N Q , ASI NH()
ATAN ()
A T A N H ( )
122 I. Excel
-
7/15/2019 MS Excel
125/514
. 2.1
C E I L I N G Q ( ) . ,
, . -
COS()
COSH()
D E G R E E S Q EVEN() . -
, ,
E X P Q ( - 2.72 , )
FACT() ( )
F L O O R ( A . B ) ( ) , ( )
GAMMALN() -
INT()
LN()
LOG(A,B) ( ) ( )
LO G 10() 10() , . -
.
( )
MDETERM()
() , .
( !) ,
MIN() , . -
.
MINV ERSEO , ,
. -
,
M M U L T ( ) . , -
, . , -
,
M O D ( A , B ) ( ) ( )
2. Excel 123
-
7/15/2019 MS Excel
126/514
. 2.1
ODD()
POWER(A.B)PRODUCTORADIANSORAND()ROUND(A.B)
SIGNQ
SIN()
SINHQSQRTQSUM()
SUMIF()
SUMPRODUCTO
SUMSQQTAN()
TANH()
( )
. , -
= 3.1415 - 15 . (
!)
. ( )
( ) ,
.
,
() 1. ( ). -
, .. (
)
,
( 1, - 1 0)
. . .
, . . - .
( ). , , ,
. -
(
). , (..
, )
, , .
-
,
. -
, , , ( )
124 I. Excel
-
7/15/2019 MS Excel
127/514
. 2.1
T R A N S P O S E Q ( )
T R U N C ( ) , , - . () , ( )
, , , . ,
.
, . ,
. ,
.
, -
, . -
, .
, -
. -: TRUE () FALSE (). , -
IF(), , . 2.2.
2.2.
A N D Q TRUE, (- ) TRU E. (.. FALSE) FALSE
FALSE() FALSE
IF() . , . ( TRUE), . ( FALSE), N O T Q . , ( ). , TRUE FALSE O R Q . - TRUE, TRUE. FALSE, FALSET R U E Q T R U E .
.
2. Excel 125
-
7/15/2019 MS Excel
128/514
, -
. . 2.3 , -
.
2.3.
CHAROCODEOCONCATENATEO
FINDQ
FIXEDQ
LEFT()
LENQLOWEROPROPERO
, ,
,
,
,
, . -
( -
)
, .
T R U E .
FALSE. -
, - , , . -
.
, -
. ().
,
. -
, -
. ,
, (
). ()
. T R U E , . FALSE
, -
.
. -
. () -
,
,
, , -
( )
, , -
, .
126 I. Excel
-
7/15/2019 MS Excel
129/514
. 2.3
R E P L A C E Q . . , . , - . - . , , ,
R E P T {) , , - , S E A R C H Q F I N D Q , -
( )
S U B S T I T U T E Q . - , . - , . ( ). , , . , - -
() , -
.
( ) . , - . (. 1). -.
T R IMQ () ( - )
U P P E R ( ) , - , ( )V A L U E O ( ) .
,
. ,
. , -
.
2. Excel 127
-
7/15/2019 MS Excel
130/514
,
. , -
-
, . -
. 2.4.
2.4.
AVEDEVO
AVERAGEQ
BETADISTQ
, ( ) , . { :} (), ' -
1 " */ ~\, N ~
N / = i {,}, ,
1 " J C 0 = ;.. (, , ),
. , , , ,
.. [ :] N , 1 ", Vx, .
N , - A V E R A G E A Q . , , 0. , FALSE, 0. TRUE - 1
-. 0 < < 1 ,
1|>"'(1-)" (,)=|>~'(1-0~' 0 -, (3 > 0 .
, , ,
B E T A I N V Q -- ( ) . . , BETADIST(x,a,b,A,B)=y, B E T A I N V ( y , a , b , A , B ) = x . , BETADISTQ
128 I. Excel
-
7/15/2019 MS Excel
131/514
. 2.4
BINOMDISTO
CHIDISTO
CHIINVQ
COUNTBLANKOCOUNTIFQ
. -. . - . FALSE,
, **(1-)"~* , 1 = ! .k\(n-k)\ , k( ) ( ) ( ). TRUE,
1- )"~ -, k
- . . () , , ( ) . - % 1 =^, {,} - . -j () =; (/2) , 2"/(//2)() = J t~ l e.xp(-t)dt -. 1 - \p(z)dz,
yj n CHIDIST().
( ) ( ) - . , y = C H I D I S T ( x , n ) x = C H I I N V ( y , n ) ,
. . -, . . - , -
2. Excel 129
-
7/15/2019 MS Excel
132/514
. 2.4
DEVSQO
EXPONDISTO
GAMMADISTO
GAMMAINVOGEOMEANO
HARMEANQ
LARGEQ
. -
, ,
( ). [ {\ ,
N I NV(* - J C 0 ) 2 , . -Vx - NM (N )
. .
. FALSE, -
Xexp(-Xjc) ( ), - ,
. TRUE,
, |Xexp(-Xt)dt = 1-(-)
-. -
- "'1 (-*/) . -() .
. , ,
FALSE, - . TRUE,
pT(a)J -.
y=GAMMADIST(x',a,b,TRUE), x=GAMMAINV(y,a,b,TRUE)
( {x t} i ).
, ,
> -
-
( )
130 I. Excel
-
7/15/2019 MS Excel
133/514
. 2.4
LINESTQ
LOGESTQ
MODE()
NORMDISTO
NORMINVQ
NORMSINVO
POISSONQ
() - . , -. - .
.
. -, .
, - ( ) (
, )
,
f= ( -- ) . 'D' , ( -) D( ) -
. FALSE,
, . , ..
TRUE, / J (__ , )dtJlnD: 2 D 2 , ( ), - ( ) ( ) .
y=NORMDIST( x,a,D,TRUE), x = N O R M I N V ( y , a , D )N O R M S D I S T Q .
. J e\p(-t2/2)dt , * . , y=NORMSD IST(x), x=NORMSINV(y)
. . , , FALSE, k() . ( )
.' (-) J t !TRU E,
.
,"(-.)
2. Excel 131
-
7/15/2019 MS Excel
134/514
. 2.4
SMALLQ
STANDARDIZEO
STDEVQ
STEYX()
VAR()
-
. ,
( )
( ) D(
).
( - a)/D
. {*} - ( ).
- ,N(N-l)N . - .
, S T D E V A Q . , , , -
. {) / V
( ) .
N(N-1)( ,
STDEV(), ). -
.
, V A R A Q , , -
. Excel . -
, .
Excel
, -
, -
. , , -
,
.
132 I. Excel
-
7/15/2019 MS Excel
135/514
Excel ,
Tools Add-lns ( ), - Add-lns, . 2.29.
. 2.29. Add-lnsAnalysis ToolPsConditional Sum WizardEuro Currency ToolsInternet Assistant VBALookup WizardSolver Add-in
:'Analysis TooPak - ' Providesfuncttons and interfaces for financiaJ andscientftc data analysis
. -
, Analysis ToolPak (. . 2.29). -
Engineering (),
. . 2.5.
2.5. Excel
BESSELI() I j ( x ) ( - ). " ( } + '() - (
2+ v 1)y(x) = 0 ( v ).
. , (.. ), v
Jj(x), 2"() ++ '() + ( - v 2)y(x) = 0 ( ). / i-,i 2i+v Jv(x) = 2_ .--BESSELJQ , vB E S S E L K Q K j ( x ) ( - ). , IJix), " ( ) ++ '() - (:2 + v 2) y ( x ) = 0, , , .
,
2. Excel 133
-
7/15/2019 MS Excel
136/514
. 2.5
BESSELYO
BIN2DEC()
BIN2HEX()
BIN20CT()
COMPLEXO
CONVERTO
DEC2BINODEC2HEXODEC20CTODELTAQ
ERFQ
ERFCQ
FACTDOUBLEO
Yj(x).
cos(7iv)yv(x)-y VO)Y () = . Jjlx), sin(Tiv) " ( ) + '() + ( 2 v 2)y(x) = 0. -. ,
. -
,
.
. ,
. / / , i
. -
, ,
,
, . .
, 1,
: = (-) .V I I . , b
1=|(-) , v/J0 .
1 , .
, -
134 I. Excel
-
7/15/2019 MS Excel
137/514
. 2.5
GESTEPQHEX2BINQHEX2DECO
2()
IMABSOIMAGINARYQIMARGUMENTOIMCONJUGATEOIMCOSQIMDIVQ1()IMLN()
IMLOG100IMLOG20IMPOWERQIMPRODUCTO
IMREALOIMSINQIMSQRTOIMSUBOIMSUMOOCT2BINOOCT2DECO2()
, , , .
( ) -
, ,
( -) ( )
, - .
. - , ,
2. Excel 135
-
7/15/2019 MS Excel
138/514
, , , - .
, -. , , - VBA ( Visual Basic for Applications) . , .
. - , Excel . , - . , .
-
SUM(). , -. . - , , , .
. , Excel : - , , , . , 1 , 2, 1 2 , 1 :2.
. .
. - ( ) . 2.30.
| Resklotc.xls
. 2.30.
136 I. Excel
-
7/15/2019 MS Excel
139/514
, - R1 (10 ), R2 (20 ) R3 (25 ). - U (22 0 ). , , , ,.. R = Rl + R2 + R3, , : / = U/R. - G9 (
) G10 (). :
. , , -, ( 10, R 1 ) , D3( 20, R2) F3 ( 25, R3). , D9 U ( 220). G10 , , , -. SUM(). , G 10 =SUM(B3,D3,F3).
. ( ) - . I n s e r t ^ F u n c t i o n( ) ,
Insert Function ( ). - SUM() Most Recently Used ( -), , , Math&Trig( ). Function Arguments ( ) , , .
G9, =D9/SUM(B3,D3,F3), = D 9 / G 1 0 . , -, , , , - , , .
, -
. .
> , - . -, Format^Cells (^).
> Drawing (). V i e w ^ T o o l b a r s 1 ^ D r a w i n g (1^ -^). . 2.31, . 2.6.
2. Excel 137
-
7/15/2019 MS Excel
140/514
. 2.31. Drawing
2.6. Drawing
, , -
, , ..
. , (!)
: - , , ,
[ : | W o r d A r t
C l i p A r t
|.| J A - J
IgJ
|
, D3 F3, ,
, (9, 9, ) -
, ,
(9, F9, F10) . , F9:H10
138 I. Excel
-
7/15/2019 MS Excel
141/514
, G9 G10 .
, - .
. , -
Excel.
. -
. , -
. -
: (
) ( , , ).
, ,
. , -
( ). . 2.32
.
(. ) .
( G9). G10 .
.R1.0H |
U m a x -
^ jR2, ; R 3 . 0 H :
* . *
220 R- " " * ' 55
I V * W
it -50
..,,: U. I,
1 9
5 190.005 h 0.019:
91.65151":! 161.8894 11.666391 !| 2.943444!
200.02:2
3.636364"
i. U, C 1, A
CDatX0)X
OfX=1Q.U
55' X0)X _ D5
- ffi - ' 'U
0 1 - 1 0 . 5 1 2 7
X*" xS x& sS o 1 ' 01 '-5
1 5 5 . S G 3 4 9 22 E - 1 6 ' 2 . 5 5 4 7 7 8 2 . 8 2 8 4 2 7 1 2
H\Shcet l / /S h eet s /
:
Puc. 2.32.
2. Excel 139
-
7/15/2019 MS Excel
142/514
, , - . ( 20). 12- 0 20 ( C12:W12) - .
. , . (0 1 ..
12 D12) . ( ). -
W12 ( , , .. 20). ( ) , ., 13- ( C13:W13) -
, . , . - .
, , v = 1/v., , , C12:W12, , - , W12. , - , ( ) -
W12. , i( C12:W12) - . , 13 = C 1 2 / $ G $ 1 0 / $ W $ 1 2 . - . , -
( D13) 12 ( D12) . , 13 . 13, - W13. - 14 15, -
13:W15. ,
. : U(t)-f/,cos(ca?) + t/ 2sin(cor). - , 2. / , U 2 - , f / ma x, - / 0. , /, = U 0, a /, = -y/^L. ~ ^1 ( - , , -) . 14 =$D$10*COS(2*PI()*$G$10*C13)+SQRT($D$9 A2-$D$10A2)*SIN(2*PI()*$G$10*C13). , , 15 = C 1 4 / $ G $ 9 .140 I. Excel
-
7/15/2019 MS Excel
143/514
C13:W15 , . 2.32.
! . 2.32 - , ( ). - , , , .
, , , (. . 2.32),
, (, , -^ ). , , - ' - . A V E R A G E Q . 20 = A V E R A G E ( C 1 4 : V 1 4 ) , 21 - = A V E R A G E ( C 1 5 : V 1 5 ) .
, .
. V W , () ( W) (, -). , - .
, . , - , . - ( ! ) , - .
A V E D E V Q . D20 = A V E D E V ( C 1 4 : V 1 4 ) , D21 - = A V E D E V ( C 1 5 : V 1 5 ) . , : ( , - !), ( - W12), . ,
20 =SQRT(DEVSQ(C1 4: V1 4)/$W $1 2), 21 =SQRT(DEVSQ(C15:V15) /$W$12) . .
. Excel, , (, , ). - , -
.
2. Excel 141
-
7/15/2019 MS Excel
144/514
.
, -, . , , -
. , = , ( = 2nv), , j (
j, /) . X L L: X L = j'coL. Z () Z = R + X C + X L. U / U = \ Z \ I , |Z| - - . . 2.33. ,
.
- .
. . , . - , - , , - .
. 2.33.
142 I. Excel
-
7/15/2019 MS Excel
145/514
(, , ). , , , -
. - , , CONVERT(). , , . 2.7.
2.7. ,
CONVERT()
" g "
(slug) ( 14593.84 ) " sg" ( 45 3 , 6 ) " I bm" " "
(1 1 6 1 " o z m"16 ) ""
" m i "
( 1 8 5 3 , 6 ) " N m i " ( 2,5 ) " in "
( , 3 0 ,48 , " f t " )
( , 3 914,4 )
( p i c a ) (1 /72 )
-
"yd"
"ang"" P i c a "
" y r ""day"
" h r "" m n ""sec""Pa"
"aim"" m m H g "" N "" d y n ""Ibf ""J"
"e "
2. Excel 143
-
7/15/2019 MS Excel
146/514
. 2.7
-
-
-
-
BTU ( British Thermal Unit )
( , 1/16 29,57 )
( 1/4 , 2 1,14 0,95 )
""eV""HPh"" W h""fib""BTU"
"HP"
" W ""T ""ga""C ""F "
"K ""tsp""tbs""oz"
"cup"
"pt""uk_pt""qt""gal"
144 I. Excel
-
7/15/2019 MS Excel
147/514
, , . 2.8.
2.8.
()
(peta)
(tera)
(giga) (mega)
(kilo)
(hecto)
(dekao) (deci) (centi) (milli) (micro)
() (pico)
(femto)
(atto)
1+18
1+15
1+12
1+091+06
1+03
1+02
1+01
1-011-02
1-03
1-06
1-09
1-12
1-15
1-18
"" II""
"G "" "" k""h """" d "" ""m "" u "" n ""p "" f ""a "
, . . , - , - . , 12 = C O N V E R T ( $ D $ 1 2 , " u m " , " m " ) . Excel -, .
( = $ D $ 1 1 11 $D$13 13). , ( =$D $1 4*2*PI( ) 14).
, - ( ). , ( 16) =1_($$11,0),.. ( ), , , . - ( 17) =IMDIV(1,IMPRODUCT($E$14 ,$E$12 ," jM )) , .. . , ( 18) ( = I M P R O D U C T ( $ E $ 1 4 , $ E $ 1 3 , " j " ) ) .
2. Excel 145
-
7/15/2019 MS Excel
148/514
19 ( =IMS U M( E1 6: 1 8) ) , 20 ( = I M A B S ( E 1 9 ) ) .. , , .
. , . . , . ( , ).
(