OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 399
- Strana / 434
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
Syntax Description
SLOPE(data_Y; data_X) Returns the slope of the linear regression line.
Data_Y is the array or matrix of Y data. Data_X is the
array or matrix of X data.
SMALL(data; rank_c)
Returns the Rank_c-th smallest value in a data set.
Data is the cell range of data. Rank_c is the rank of
the value (2nd
smallest, 3rd smallest, etc.) written as
an integer.
STANDARDIZE(number;
mean; STDEV)
Converts a random variable to a normalized value.
Number is the value to be standardized. Mean is the
arithmetic mean of the distribution. STDEV is the
standard deviation of the distribution.
STDEV(number_1; number_2;
... number_30)
Estimates the standard deviation based on a sample.
Number_1; number_2; ... number_30 are
numerical values or ranges representing a sample
based on an entire population.
STDEVA(value_1; value_2; ...
value_30)
Calculates the standard deviation of an estimation
based on a sample. Value_1; value_2; ... value_30
are values or ranges representing a sample derived
from an entire population. Text has the value 0.
STDEVP(number_1;
number_2; ... number_30)
Calculates the standard deviation based on the entire
population. Number_1; number_2; ... number_30
are numerical values or ranges representing a
sample based on an entire population.
STDEVPA(value_1; value_2; ...
value_30)
Calculates the standard deviation based on the entire
population. Value_1; value_2; ... value_30 are
values or ranges representing a sample derived from
an entire population. Text has the value 0.
STEYX(data_Y; data_X) Returns the standard error of the predicted y value
for each x in the regression. Data_Y is the array or
matrix of Y data. Data_X is the array or matrix of X
data.
TDIST(number;
degrees_freedom; mode)
Returns the t-distribution for the given Number.
Degrees_freedom is the number of degrees of
freedom for the t-distribution. Mode = 1 returns the
one-tailed test, Mode = 2 returns the two-tailed test.
TINV(number;
degrees_freedom)
Returns the inverse of the t-distribution, for the given
Number associated with the two-tailed t-distribution.
Degrees_freedom is the number of degrees of
freedom for the t-distribution.
TRIMMEAN(data; alpha) Returns the mean of a data set without the Alpha
proportion of data at the margins. Data is the array
of data in the sample. Alpha is the proportion of the
marginal data that will not be taken into
consideration.
Appendix B Description of Functions 399
- OpenOffice.org 3.3 1
- Calc Guide 1
- Copyright 2
- Contents 3
- Note for Mac users 8
- Chapter 1 9
- Introducing Calc 9
- What is Calc? 10
- Parts of the main Calc window 10
- Title bar 11
- Menu bar 11
- Toolbars 12
- Moving toolbars 13
- Formatting toolbar 14
- Formula Bar 15
- Right-click (context) menus 16
- Individual cells 16
- Sheet tabs 16
- Status bar 17
- Starting new spreadsheets 18
- • Press the Control+N keys 19
- Opening existing spreadsheets 20
- Opening CSV files 21
- Saving spreadsheets 22
- Password protection 24
- Going to a particular cell 26
- Moving from cell to cell 26
- Moving from sheet to sheet 28
- Selecting cells 29
- Selecting columns and rows 30
- Selecting sheets 31
- Working with columns and rows 32
- Working with sheets 33
- Viewing Calc 34
- Freezing rows and columns 35
- Splitting the screen 36
- Split screen bar 37
- Using document properties 40
- Chapter 2 43
- Entering, Editing, and 43
- Formatting Data 43
- Entering dates and times 45
- Entering special characters 45
- Speeding up data entry 46
- Using a fill series 47
- Defining a fill series 48
- Using selection lists 49
- Validating cell contents 50
- Editing data 52
- Formatting data 53
- Using manual line breaks 54
- Formatting numbers 55
- Formatting the font 56
- Choosing font effects 56
- Formatting the cell borders 58
- In each 58
- Defining a new AutoFormat 59
- Using conditional formatting 60
- Hiding and showing data 61
- Outline group controls 62
- Sorting records 63
- Finding and replacing in Calc 65
- Finding and replacing text 67
- Chapter 3 69
- Creating Charts and 69
- Creating a chart 70
- Choosing a chart type 72
- Selecting data series 73
- Editing charts 74
- Data labels 76
- Trend lines 77
- Mean value lines 78
- Y error bars 78
- Formatting charts 79
- Moving chart elements 80
- Formatting 3D charts 82
- Appearance 83
- Illumination 84
- Formatting the chart elements 85
- Formating data labels 86
- Hierarchical axis labels 86
- Resizing and moving the chart 88
- Gallery of chart types 89
- Pie charts 90
- Donut charts 91
- Area charts 92
- Line charts 93
- Scatter or XY charts 93
- Bubble charts 94
- Net charts 95
- Stock charts 96
- Column and line charts 97
- Chapter 4 98
- Using Styles and 98
- Templates in Calc 98
- What is a template? 99
- What are styles? 99
- Types of styles in Calc 99
- Accessing styles 100
- Applying cell styles 101
- Applying page styles 102
- Modifying styles 103
- Cell style options 104
- Page style options 105
- Creating new (custom) styles 106
- Copying and moving styles 107
- Deleting styles 109
- Creating a template 110
- Editing a template 111
- Caution 112
- Setting a default template 113
- Organizing templates 115
- Importing a template 116
- Exporting a template 116
- Chapter 5 117
- Using Graphics in Calc 117
- Graphics in Calc 118
- Adding graphics (images) 118
- Drag and drop 119
- Linking an image file 120
- Modifying images 123
- Icon Name Behavior 124
- Choosing a graphics mode 125
- Using graphic filters 125
- Adjusting colors 126
- Setting transparency 126
- Cropping pictures 126
- Resizing an image 128
- Rotating a picture 128
- Position and Size 129
- Original Size 129
- Description 129
- Using Calc’s drawing tools 130
- Positioning graphics 133
- Arranging graphics 134
- Anchoring graphics 135
- Creating an image map 136
- Chapter 6 138
- Printing, Exporting, and 138
- E-mailing 138
- Quick printing 139
- Controlling printing 139
- Selecting sheets to print 141
- Using print ranges 142
- Removing a print range 143
- Editing a print range 143
- Defining a custom print range 144
- Page breaks 145
- Inserting a page break 146
- Deleting a page break 146
- Headers and footers 148
- Header or footer appearance 149
- Exporting to PDF 151
- Exporting to XHTML 157
- Saving as Web pages (HTML) 157
- E-mailing spreadsheets 157
- Digital signing of documents 157
- Removing personal data 158
- Chapter 7 159
- Using Formulas and 159
- Functions 159
- Introduction 160
- Setting up a spreadsheet 160
- Creating formulas 161
- Operator types 163
- Arithmetic operators 164
- Comparative operators 164
- Text operators 164
- Reference operators 166
- Range operator 167
- Intersection operator 168
- Relative referencing 169
- Absolute referencing 170
- Order of calculation 171
- Calculations linking sheets 172
- Understanding functions 175
- Nested functions 177
- Function Wizard 178
- + vt - ½at 180
- Finding and fixing errors 182
- Examples of common errors 183
- The Detective 184
- Color coding for input 184
- Examples of functions 187
- Simple statistics 188
- Rounding off numbers 189
- Advanced functions 192
- Chapter 8 193
- Using the DataPilot 193
- Advantages 198
- Example 2: Timekeeping 201
- Solution 203
- Differences and advantages 207
- Figure 188: Import settings 209
- Figure 189: Raw data in Calc 209
- Solution with the DataPilot 210
- DataPilot functions in detail 214
- Data source 215
- The DataPilot dialog 216
- More options 217
- Data fields 219
- Row and column fields 221
- Page fields 224
- Start the dialog 224
- Grouping rows or columns 224
- (Number of Days) as 7 226
- Sorting the result 228
- Drilling (showing details) 230
- Filtering 231
- Multiple data fields 232
- Function GETPIVOTDATA 236
- First syntax variation 238
- =GETPIVOTDATA("sales 238
- Second syntax variation 238
- Chapter 9 240
- Data Analysis 240
- Consolidating data 241
- Creating subtotals 243
- Using “what if” scenarios 245
- Settings 246
- Changing scenarios 246
- Changing scenario properties 247
- Changing scenario cell values 247
- Tracking values in scenarios 248
- Using other “what if” tools 249
- Chapter 9 Data Analysis 251 251
- Chapter 9 Data Analysis 253 253
- Goal Seek example 254
- Chapter 9 Data Analysis 255 255
- Using the Solver 256
- Chapter 9 Data Analysis 257 257
- Chapter 10 259
- Linking Calc Data 259
- Why use multiple sheets? 260
- Setting up multiple sheets 260
- Inserting new sheets 261
- Hyperlinks and URLs 267
- Creating hyperlinks 268
- Linking to external data 270
- Using the Navigator 271
- Viewing data sources 276
- Editing data sources 276
- . Once in 277
- Embedding spreadsheets 278
- Other OLE objects 279
- Non-linked OLE object 280
- Dynamic Data Exchange (DDE) 281
- DDE link in Writer 282
- Chapter 11 283
- Sharing and Reviewing 283
- Documents 283
- Opening a shared spreadsheet 285
- Saving a shared spreadsheet 285
- Recording changes 286
- Recording changes (tutorial) 287
- Adding comments to changes 288
- Editing change comments 289
- Adding other comments 290
- Reviewing changes 291
- Viewing changes 292
- Merging documents 294
- Comparing documents 295
- Saving versions 295
- Chapter 12 298
- Calc Macros 298
- Using the macro recorder 299
- Chapter 12 Calc Macros 301 301
- Write your own functions 303
- Using a macro as a function 305
- Chapter 12 Calc Macros 307 307
- Passing arguments to a macro 308
- Chapter 12 Calc Macros 309 309
- Accessing cells directly 310
- Chapter 12 Calc Macros 311 311
- Conclusion 312
- Chapter 13 313
- Calc as a Simple Database 313
- A B C D E F G 314
- Named range 315
- 0 TOP Select the top border 318
- Database range 319
- Auto filters 322
- Standard filters 323
- Advanced filters 326
- Manipulating filtered data 329
- Using formulas to find data 333
- Examples 335
- ADDRESS(row; column) 336
- ADDRESS(row; column; abs) 336
- Database-specific functions 339
- Chapter 14 341
- Setting up and 341
- Customizing Calc 341
- User Data options 343
- Print options 343
- Color options 343
- Security options 344
- Security options and warnings 345
- Appearance options 346
- General Load/Save options 347
- Choosing options for Calc 350
- General options for Calc 351
- View options for Calc 352
- Visual aids section 353
- Display section 353
- Calculate options 354
- Iterative references section 355
- Date section 355
- Other options 355
- Sort Lists options 356
- Changes options 357
- Grid options 357
- Customizing the menu font 358
- Customizing menu content 359
- Creating a new menu 360
- Modifying existing menus 360
- Adding a command to a menu 361
- Modifying menu entries 361
- Customizing toolbars 362
- Creating a new toolbar 363
- Adding a command to a toolbar 363
- Saving changes to a file 366
- Resetting the shortcut keys 366
- Installing extensions 367
- Using extensions 368
- Appendix A 369
- Keyboard Shortcuts 369
- Shortcut Keys Effect 372
- In this mode, you 372
- You can also 372
- Table 31. Arrow key shortcuts 372
- Cell formatting shortcuts 373
- DataPilot shortcuts 374
- Appendix B 375
- Description of Functions 375
- Functions available in Calc 376
- Mathematical functions 376
- Financial analysis functions 381
- Date and time functions 401
- Syntax Description 402
- Number is a time value 402
- Logical functions 404
- Informational functions 405
- Database functions 407
- Array functions 408
- Spreadsheet functions 410
- Text functions 414
- Radix is the base of the 415
- is the text to 415
- (optional) is the 415
- Applying the 416
- Add-in functions 417
- Places is 418
- The complex number is 419
- The complex_number is 419
- Appendix C 421
- Calc Error Codes 421
- General error codes 424
- Index 427 427
- Index 429 429
- Index 431 431
- Index 433 433
Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3
Software OpenOffice.org OpenOffice - 3.2 Manuál
(34 stránky)
(34 stránky)
Blackberry GOOGLE TALK FOR SMARTPHONES podręczniki
Instrukcje obsługi i podręczniki użytkownika dla Telefony komórkowe Blackberry GOOGLE TALK FOR SMARTPHONES.
Dostarczamy 4 pdf podręczników Blackberry GOOGLE TALK FOR SMARTPHONES do pobrania za darmo według typów dokumentów: Instrukcja Użytkownika
Blackberry GOOGLE TALK FOR SMARTPHONES Instrukcja Użytkownika (17 strony)
Marka: Blackberry | Kategoria: Mobile phones | Rozmiar: 0.52 MB |
Spis treści
Chat-Verlauf
13
Rückmeldung
14
Blackberry GOOGLE TALK FOR SMARTPHONES Instrukcja Użytkownika (16 strony)
Marka: Blackberry | Kategoria: Mobile phones | Rozmiar: 0.51 MB |
Spis treści
Blackberry GOOGLE TALK FOR SMARTPHONES Instrukcja Użytkownika (16 strony)
Marka: Blackberry | Kategoria: Mobile phones | Rozmiar: 0.52 MB |
Spis treści
Comentarios
13
Aviso legal
14
Blackberry GOOGLE TALK FOR SMARTPHONES Instrukcja Użytkownika (16 strony)
Marka: Blackberry | Kategoria: Mobile phones | Rozmiar: 0.53 MB |
Spis treści
Royaume-Uni
16
Więcej produktów i instrukcji dla Telefony komórkowe Blackberry
| Modele | Rodzaj dokumentu |
|---|---|
| PEARL 8120 - PGP SUPPORT PACKAGE FOR DEVICES |
Instrukcja Użytkownika
Benutzerhandbuch [en] ,
300 strony
|
| ENTERPRISE SERVER FOR MICROSOFT EXCHANGE - - |
Przewodnik Instalacji
Blackberry ENTERPRISE SERVER FOR MICROSOFT EXCHANGE - - Installation guide [en] ,
114 strony
|
| STORM 9500 SMARTPHONE - VERSION 4.7 |
Instrukcja Użytkownika
BlackBerry Storm 9500 Smartphone - 4.7 - Manual - wm,
261 strony
|
| Bold 9900 Bold 9930 |
Instrukcja Użytkownika
BlackBerry® Bold™ 9900,
357 strony
|
| YAHOO! MESSENGER FOR SMARTPHONES |
Instrukcja Użytkownika
Yahoo! Messenger para Smartphones BlackBerry - 3.0,
18 strony
|
| PGP |
Instrukcja Użytkownika
This is the user interface of the BlackBerry Enterprise,
5 strony
|
| Curve 9310 Series |
Instrukcja Użytkownika
Télécharger - Recommerce Solutions,
396 strony
|
| CURVE 9300 - V6.0 |
Instrukcja Użytkownika
BlackBerry Curve Series - 6.0,
332 strony
|
| Bold 9900 Bold 9930 |
Instrukcja Użytkownika
Start Here - BlackBerry Bold 9900/9930 Smartphones,
6 strony
|
| Curve |
Instrukcja Użytkownika
BlackBerry Curve 8320,
2 strony
|
| STORM 9530 - VERSION 5.0 |
Dokumentacja
Blackberry STORM 9530 - VERSION 5.0 Specifications,
100 strony
|
| PEARL 8120 - S-MIME SUPPORT PACKAGE FOR DEVICES |
Instrukcja Użytkownika
BlackBerry Pearl Series - 6.0,
350 strony
|
| 8220 - Pearl USB Sync Charge Desktop Docking Cradle |
Podręcznik Użytkownika
Blackberry 8220 - Pearl USB Sync Charge Desktop Docking Cradle User guide,
44 strony
|
| 8820 SMARTPHONE |
Instrukcja Użytkownika
BlackBerry 8820 Smartphone,
4 strony
|
| Pearl |
Instrukcja Użytkownika
Blackberry Pearl User Manual,
24 strony
|
| 6750 |
Instrukcja Użytkownika
Blackberry 6750 User Manual,
130 strony
|
| Bold 9700 |
Instrukcja Użytkownika
Blackberry Bold 9700 User Manual,
332 strony
|
| 7230 |
Instrukcja Użytkownika
Blackberry 7230 User Manual,
152 strony
|
| 8703e |
Instrukcja Użytkownika
Blackberry 8703e User Manual,
30 strony
|
| CONNECT FOR POCKET PC 2.1 |
Instrukcja Użytkownika
Blackberry CONNECT FOR POCKET PC 2.1 User Manual,
38 strony
|
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.037 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce