OpenOffice.org 2.x Guía de usuario Pagina 290
- Pagina / 508
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 4: Spreadsheets in Calc
11.Now enter the formula in E5 using the variables = C*n*i instead of =A5*B5*C5.
Start Goal Seek
Assume an interest rate of 7. 5% and that the number of years (1) will remain constant.
However, the user may want to know how much more or less investment would be needed to
attain a particular annual return. For example, calculate how much capital would be required
for an annual return of $15,000 by performing the following steps:
1. Place the cursor in cell E5.
2. Select Tools > Goal Seek and the Goal Seek dialogue appears.
3. The correct cell, (E5), should already be entered in the field Formula Cell.
4. Place the cursor in the field Variable Cell.
5. In the sheet, click in the cell (A5) that contains the value to be changed.
6. Enter the expected result of the formula (i.e., the desired value) under Target Value. In
this example, the value is 15,000.
7. Click OK.
8. A dialogue appears with the result of the Goal Seek. The result is provided for use as
desired. If the result should be used, click Yes to enter the result in cell A5.
Applying Multiple Operations
Multiple Operations in Columns or Rows
If the data of a data range is one above the other (for columns) or next to each other (for
rows), select the data range together with the cell or cell range next to or below it as the target
range. In the Column/Row field, enter the cell reference to the first cell in the data range. In
the Formula field, enter the cell reference to the cell with the formula that applies to the data
range.
Examples
The company produces toys which sell for $10 each. Each toy costs $2 to make, in addition
to which there are fixed costs of $10,000 per annum. How much profit will be made in a year
if a particular number of toys are sold?
Consider the following table:
OpenOffice.org User Guide for 2.x 256
- 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.039 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales