OpenOffice.org 2.x Guía de usuario Pagina 287
- Pagina / 508
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 4: Spreadsheets in Calc
Consolidating Data
During consolidation, the contents of the cells from several sheets will be combined in one
place. Choose a function so that , for example, displays the sum, the standard deviation or the
variance of the data.
1. Open the document that contains the areas to be consolidated.
2. Choose Data > Consolidate to open the Consolidate dialogue.
3. From the Source Data Area list box, select an area as a starting point to consolidate with
other areas.
4. If the area is not named, click in the field next to the Source Data Area. A blinking text
cursor appears. Type a reference for the first source data area or select the area in the sheet
with the mouse.
5. Click Add to insert the selected area as a Consolidation Area.
6. Select additional areas and click Add after each selection.
7. Specify where to display the result by selecting a target area from the Copy results to list
box.
8. If the target area is not named, click in the field next to Copy results to and enter the
reference of the target area (or the top left cell in the target area). Alternatively, select the
area using the mouse or simply position the cursor in the top left cell of the target area.
9. Select a calculation rule for determining how the values of the consolidation areas should
be linked. The sum function is the default setting.
10.Click OK to consolidate the area.
OpenOffice.org User Guide for 2.x 253
- OpenOffice.org User Guide 1
- Feedback 3
- Acknowledgements 3
- Modifications and updates 5
- Contents 7
- Important Features with 2.x 37
- Multiple Language Support 41
- New Charting Module 41
- Help Agent 44
- The Title Bar 48
- The Menu Bar 49
- The Toolbars 49
- Examples of Floating Toolbars 50
- Using Floating Toolbars 51
- The document window 51
- Docking toolbars 51
- Docking windows 52
- Opening and Saving Documents 53
- Saving Documents 56
- Backup a File Automatically 57
- OpenOffice.org File Formats 58
- Sending Documents as E-Mail 61
- Printing Documents 62
- Spellcheck 66
- 5. Click Next 71
- Using Automatic Functions 74
- Undo URL recognition 76
- Turn off URL recognition 76
- Shift+Ctr+N 78
- Find & Replace 79
- Match Case 80
- Searching Backward 81
- Current Selection Only 81
- Searching for Styles 81
- Searching for Text Attributes 81
- Similarity Search 82
- Character Result/Use 83
- Permissions available 87
- Name Type Default 89
- Entering and Formatting Text 94
- Using the keyboard: 95
- Using the mouse: 95
- Deleting characters 96
- Deleting text 96
- Status bar uses 97
- Non-breaking spaces 99
- Non-breaking hyphen 99
- Hyphen, em-dash and en-dash 99
- Creating a link 106
- Delete (Del) 107
- Backspace 107
- Create Page Styles 118
- Editing Page Styles 122
- Page Styles Summary 125
- Defining default Templates 126
- Templates and Styles 127
- Automatic Spellcheck 130
- Using AutoText 131
- AutoText With AutoComplete 134
- Text Frames 135
- Editing Text Frames 136
- Linking Text Frames 136
- Using Text Animation 138
- Character 140
- Drawing Lines in Text 141
- Editing Text With FontWork 142
- Aligning Text With Lines 144
- The Navigator 145
- Other Navigator Features 147
- • Select Update Index/Table 150
- Preparation 153
- Entering Data 153
- Example file 154
- Headings and Numbering 159
- before 170
- Numbering Lines 172
- Tables in Text 173
- Table AutoFormat 175
- Table properties in general 175
- Calculating in Text Documents 177
- Statistical Functions 178
- Trigonometric Functions 178
- More Defined Values 179
- (Ctrl+a) 185
- Defining Captions 191
- Editing or deleting captions 191
- Charts with Linked Data 195
- Automatic hyphenation 206
- Manual Hyphenation 206
- Fixed and Variable Fields 209
- Printing Address Labels 213
- Newsletters 216
- Creating Page Styles 217
- Editing Headers 217
- Editing Columns 217
- Editing Paragraph Styles 218
- Working with Frames 219
- Formatting a Frame 219
- Anchoring Frames 219
- Defining a Frame Wrap 219
- Style for this purpose 221
- Using Automatic Hyphenation 224
- Letters With Envelopes 225
- Get a POSTNET font 229
- Importing into Calc 237
- Exporting from Calc 238
- The Calc Window 239
- Inserting Sheets 241
- Renaming Sheets 241
- =CONVERT( 245
- Calculating With formulae 251
- Handling Multiple Sheets 254
- Formatting a Spreadsheet 257
- Layout of Spreadsheets 259
- Addressing Cells 261
- (') 264
- Using References in formulae 266
- ='file:///C:/ 267
- Using Charts 269
- Database Functions in Calc 274
- Evaluating Data With Calc 283
- Consolidating Data 287
- Applying Goal Seek 289
- Examples 290
- Profit=Quantity * (Selling 291
- Using Scenarios 293
- Validity of Cell Contents 295
- Sample macro: 297
- Page 1 Page 3 299
- Page 2 Page 4 299
- AutoFill 304
- Linking Sheet Information 310
- 7. Click Next 316
- Outline view 320
- In-Slide Effects 321
- Editing Presentations 322
- Using Outline View 324
- NIX-based systems, use 328
- <instdir> 330
- Creating a Business Report 331
- Overview 332
- Introduction 332
- Creating a Slide Show 334
- Working with Connectors 336
- Editing Glue Points 338
- OpenOffice.org Draw Functions 343
- Drawing Curves 353
- Working With Objects 360
- Grouping Objects 362
- Entering Groups 362
- Exiting Groups 362
- Shapes - Merge 365
- Shapes - Subtract 365
- Applying Text to Bitmaps 366
- Working With colours 369
- 3D Globe 377
- 3D Effects: Favourites 379
- 3D Effects: Geometry 380
- 3D Effects: Shading 380
- 3D Effects: Illumination 381
- First Step: 382
- Second Step: 383
- Third Step: 384
- Fourth Step: 386
- Fifth Step: 387
- Using a Grid 389
- Add some more details 392
- Complete the drawing 394
- Using Snap Lines 395
- Creating a database file 398
- Creating a table 399
- Creating a related table 400
- Creating a data entry form 401
- Making data entry easier 402
- Viewing Data 406
- Creating a report 409
- Open the Data Sources window 410
- Refreshing the form 411
- Registering a Data Source 412
- Address Books 413
- Form Design 416
- Available controls 417
- Customizing controls 418
- Associating data with a field 420
- How to use the form 421
- Standard toolbar 422
- Operators 423
- Commands 424
- Further Information 432
- Inserting an object as a copy 433
- Inserting an object as a link 434
- Revision Marking Function 441
- Version Management 444
- Turning on protection 445
- Turning off protection 445
- How to get a Certificate? 448
- Self-signed certificates 449
- Moving Tabs on the Ruler 451
- Deleting Tabs 451
- Changing the Defaults 451
- Changing the colour of Text 452
- More on Templates 453
- Accessing the Sample Macros 455
- The Sample Macros 457
- Formula Entry 458
- Special Formating 461
- − 1 23 4 462
- −1 23 4 462
- Special Characters 463
- Special Operators 464
- Vectors and Matrices 465
- Formatting 466
- 5^(1+3+3^2) 467
- Step-by-Step Procedure 469
- Control 472
- 6. Adf fix 473
- Chapter 13: Xml Enhancements 480
- Creating a new Docbook Filter 485
- Common.xcu 487
- C:\<some 487
- <release>\user\basic 489
- Time for the second test 494
- Time for the third test 495
- They are a guide only 498
Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x
(548 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.113 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales