OpenOffice.org OpenOffice - 3.3 Podstawowy Przewodnik Strona 391
- Strona / 434
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
Syntax Description
SYD(cost; salvage; life;
period)
Returns the arithmetic-declining depreciation rate.
Use this function to calculate the depreciation
amount for one period of the total depreciation span
of an object. Arithmetic declining depreciation
reduces the depreciation amount from period to
period by a fixed sum. Cost is the initial cost of an
asset. Salvage is the value of an asset after
depreciation. Life is the period fixing the time span
over which an asset is depreciated. Period defines
the period for which the depreciation is to be
calculated.
TBILLEQ(settlement;
maturity; discount)
Calculates the annual return on a treasury bill.
Settlement is the date of purchase of the security.
Maturity is the date on which the security matures
(expires). (The settlement and maturity date must be
in the same year.) Discount is the percentage
discount on acquisition of the security.
TBILLPRICE(settlement;
maturity; discount)
Calculates the price of a treasury bill per 100
currency units. Settlement is the date of purchase
of the security. Maturity is the date on which the
security matures (expires). Discount is the
percentage discount upon acquisition of the security.
TBILLYIELD(settlement;
maturity; price)
Calculates the yield of a treasury bill. Settlement is
the date of purchase of the security. Maturity is the
date on which the security matures (expires). Price
is the price (purchase price) of the treasury bill per
100 currency units of par value.
VDB(cost; salvage; life; start;
end; factor; type)
Returns the depreciation of an asset for a specified
or partial period using a variable declining balance
method. Cost is the initial value of an asset. Salvage
is the value of an asset at the end of the
depreciation. Life is the depreciation duration of the
asset. Start is the start of the depreciation entered
in the same date unit as the life. End is the end of
the depreciation. Factor (optional) is the
depreciation factor. FA=2 is double rate
depreciation. Type (optional) defines whether the
payment is due at the beginning (1) or the end (0) of
a period.
XIRR(values; dates; guess) Calculates the internal rate of return for a list of
payments which take place on different dates. The
calculation is based on a 365 days per year basis,
ignoring leap years. If the payments take place at
regular intervals, use the IRR function. Values and
dates are a series of payments and the series of
associated date values entered as cell references.
Guess (optional) is a guess for the internal rate of
return. The default is 10%.
Appendix B Description of Functions 391
- 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
Powiązane produkty i podręczniki dla Oprogramowanie OpenOffice.org OpenOffice - 3.3
(56 strony)Xerox Color J75 Press con FreeFlow Print Server-18609 Handbücher
Bedienungsanleitungen und Benutzerhandbücher für Computerhardware Xerox Color J75 Press con FreeFlow Print Server-18609.
Wir stellen 1 PDF-Handbücher Xerox Color J75 Press con FreeFlow Print Server-18609 zum kostenlosen herunterladen nach Dokumenttypen zur Verfügung Bedienungsanleitung
Xerox Color J75 Press con FreeFlow Print Server-18609 Bedienungsanleitung (342 Seiten)
Marke: Xerox | Kategorie: Computer hardware | Größe: 6.20 MB |
Inhaltsverzeichnis
Color J751-2
12
Color J751-8
18
Color J754-2
28
Color J754-4
30
Color J754-6
32
Color J754-8
34
Color J755-2
40
Ficha Copia
41
Color J755-4
42
Cubiertas
56
Anotaciones
63
Escaneado
73
Modo de brillo
103
Mantenimiento
105
Color J759-20
124
Códigos de error
140
Otros errores
159
Sugerencias
166
Color J7510-44
170
Más sugerencias
171
Especificaciones
173
(bandejas 6/7)
175
Color J7512-2
176
12-3Prensa Xerox
177
Color J7512-4
178
12-5Prensa Xerox
179
Color J7512-6
180
12-7Prensa Xerox
181
Color J7512-8
182
Color J7512-10
184
Color J7512-12
186
Color J7512-16
190
Color J7512-18
192
Color J7512-22
196
Color J7512-24
198
Color J7512-26
200
Color J7512-28
202
Color J7512-30
204
Panel de control
206
Color J7514-2
222
Color J7514-4
224
Color J7514-6
226
14-7Prensa Xerox
227
Color J7514-8
228
Color J7514-12
232
Color J7514-14
234
Color J7514-16
236
Color J7514-18
238
Color J7514-20
240
Color J7514-22
242
Color J7514-24
244
Color J7514-26
246
Color J7514-28
248
Color J7515-2
250
Tipos de pliegue
252
15-5Prensa Xerox
253
15-7Prensa Xerox
255
Color J7515-8
256
15-9Prensa Xerox
257
Color J7515-10
258
Color J7515-12
260
Color J7515-14
262
Color J7515-16
264
Color J7515-18
266
Color J7515-20
268
Color J7515-22
270
Color J7515-24
272
Color J7515-26
274
Color J7515-28
276
Color J7515-30
278
Color J7515-32
280
Color J7515-34
282
Color J7515-36
284
Color J7515-38
286
Color J7515-42
290
Color J7515-44
292
Color J7515-46
294
Color J7515-48
296
Color J7515-50
298
Color J7515-52
300
Color J7515-54
302
SquareFold
305
Color J7516-6
310
16-7Prensa Xerox
311
Color J7516-10
314
Color J7516-16
320
Color J7516-20
324
Color J7516-22
326
Color J7516-24
328
Color J7516-26
330
Color J7516-28
332
Datos técnicos
333
Color J7516-30
334
Color J75ii
336
Color J75iv
338
Color J75vi
340
Weitere Produkte und Handbücher für Computerhardware Xerox
| Modelle | Dokumententyp |
|---|---|
| Impresora de color digital Xerox 700i-700 con Xero |
Bedienungsanleitung
Xerox Impresora de color digital Xerox 700i-700 con Xerox EX Print Server powered by Fiery-18476 Manual del usuario,
8 Seiten
|
| Impresora de color digital Xerox 700i-700 con Xero |
Bedienungsanleitung
Xerox Impresora de color digital Xerox 700i-700 con Xerox EX Print Server powered by Fiery-18467 Manual del usuario,
58 Seiten
|
| Impresora de color digital Xerox 700i-700 con Xero |
Bedienungsanleitung
Xerox Impresora de color digital Xerox 700i-700 con Xerox EX Print Server powered by Fiery-18463 Manual del usuario,
42 Seiten
|
| Impresora de color digital Xerox 700i-700 con Inte |
Bedienungsanleitung
Xerox Impresora de color digital Xerox 700i-700 con Integrated Fiery Color Server-18406 Manual del usuario,
22 Seiten
|
| DocuColor 7000-8000 con Creo CXP8000-18733 |
Bedienungsanleitung
Xerox DocuColor 7000-8000 con Creo CXP8000-18733 Manual del usuario,
64 Seiten
|
| DocuColor 7002-8002 con Xerox EX Print Server-1885 |
Bedienungsanleitung
Xerox DocuColor 7002-8002 con Xerox EX Print Server-18854 Manual del usuario,
99 Seiten
|
| Color 800-1000 Digital Press con Xerox EX Print Se |
Bedienungsanleitung
Xerox Color 800-1000 Digital Press con Xerox EX Print Server 800DCP-18555 Manual del usuario,
28 Seiten
|
| Color 800-1000 Digital Press con Xerox FreeFlow Pr |
Bedienungsanleitung
Xerox Color 800-1000 Digital Press con Xerox FreeFlow Print Server 800DCP-18576 Manual del usuario,
366 Seiten
|
| Impresora de color digital Xerox 700i-700 con Xero |
Bedienungsanleitung
Xerox Impresora de color digital Xerox 700i-700 con Xerox CX Print Server powered by Creo-18432 Manual del usuario,
28 Seiten
|
| Color 800-1000 Digital Press con Xerox EX Print Se |
Bedienungsanleitung
Xerox Color 800-1000 Digital Press con Xerox EX Print Server 800DCP-18550 Manual del usuario,
66 Seiten
|
| 770 Digital Color Press con Xerox FreeFlow Print S |
Bedienungsanleitung
Xerox 770 Digital Color Press con Xerox FreeFlow Print Server-18503 Manual del usuario,
24 Seiten
|
| DocuColor 7002-8002 con Xerox CX Print Server-1884 |
Bedienungsanleitung
Xerox DocuColor 7002-8002 con Xerox CX Print Server-18847 Manual del usuario,
198 Seiten
|
| Color 800-1000 Digital Press con Xerox FreeFlow Pr |
Bedienungsanleitung
Xerox Color 800-1000 Digital Press con Xerox FreeFlow Print Server 800DCP-18563 Manual del usuario,
36 Seiten
|
| DocuColor 7000AP-8000AP con Xerox EX Print Server- |
Bedienungsanleitung
Xerox DocuColor 7000AP-8000AP con Xerox EX Print Server-18819 Manual del usuario,
64 Seiten
|
| Color 800-1000 Digital Press con Xerox CX Print Se |
Bedienungsanleitung
Xerox Color 800-1000 Digital Press con Xerox CX Print Server 800DCP-18534 Manual del usuario,
94 Seiten
|
| Color 800-1000 Digital Press con Xerox EX Print Se |
Bedienungsanleitung
Xerox Color 800-1000 Digital Press con Xerox EX Print Server 800DCP-18542 Manual del usuario,
420 Seiten
|
| DocuColor 7000-8000 con Creo CXP8000-18736 |
Bedienungsanleitung
Xerox DocuColor 7000-8000 con Creo CXP8000-18736 Manual del usuario,
472 Seiten
|
| Impresora de color digital Xerox 700i-700 con Xero |
Bedienungsanleitung
Xerox Impresora de color digital Xerox 700i-700 con Xerox EX Print Server powered by Fiery-18462 Manual del usuario,
26 Seiten
|
| Impresora digital de color DocuColor 5000 con Fier |
Bedienungsanleitung
Xerox Impresora digital de color DocuColor 5000 con Fiery EXP50-18905 Manual del usuario,
52 Seiten
|
| Impresora digital de color DocuColor 5000 con Fier |
Bedienungsanleitung
Xerox Impresora digital de color DocuColor 5000 con Fiery EXP50-18899 Manual del usuario,
16 Seiten
|
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.030 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji