Apple Numbers '08 Manuel d'utilisateur Page 233
- Page / 295
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Chapter 12 Dictionary of Functions 233
FORECAST
The FORECAST function uses linear regression analysis of known value pairs to find the
y (dependent) value that corresponds to a chosen x (independent) value.
FORECAST(x, y-values, x-values)
 x: The x value for which you want to find a corresponding y value.
 y-values: A range of cells containing the known y values. Must be the same size as x-
values.
 x-values: A range of cells containing the known x values.
Notes
You can use the SLOPE and INTERCEPT functions to find the equation used to calculate
forecast values.
FV
The FV function calculates the future value of an investment, given a series of fixed,
periodic added payments, interest rate, and number of periods. FV stands for future
value.
FV(rate, num-periods, [payment], [present-value], [when-due])
 rate: The interest rate per period.
 num-periods: The number of periods.
 payment: Optional; the added payment to be made per period, specified as a
negative number. If omitted, you must include present-value.
Examples
FLOOR(0.25,1) returns 0.
FLOOR(1.25,1) returns 1.
FLOOR(5,2) returns 4.
FLOOR(73,10) returns 70.
FLOOR(-0.25,-1) returns 0.
FLOOR(9,2.5) returns 7.5.
Examples
Given the following table:
FORECAST(9, A3:F3, A2:F2) returns 19.
- Numbers ’08 1
- User’s Guide 1
- Contents 3
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- Welcome to the 16
- Numbers User’s Guide 16
- Numbers Tools and Techniques 18
- The Numbers Window 20
- Spreadsheet Viewing Aids 21
- Print View 22
- Alignment Guides 22
- The Styles Pane 23
- The Toolbar 24
- The Format Bar 25
- The Inspector Window 25
- Formula Tools 26
- Click to open the 27
- Function Browser 27
- The Media Browser 28
- The Colors Window 28
- The Font Panel 29
- The Warnings Window 29
- Working with a Numbers 31
- Importing a Document 33
- Saving Spreadsheets 34
- Undoing Changes 35
- Viewing Sheets 37
- Adding and Deleting Sheets 38
- Dividing a Sheet into Pages 39
- Using Headers and Footers 41
- Arranging Objects on a Page 41
- Setting Page Orientation 42
- Setting Pagination Order 42
- Numbering Pages 42
- Setting Page Margins 43
- Using Tables 44
- Working with Tables 45
- 46 Chapter 3 Using Tables 46
- Chapter 3 Using Tables 47 47
- Resizing a Table 48
- Moving Tables 48
- Naming Tables 49
- Defining Reusable Tables 49
- 50 Chapter 3 Using Tables 50
- Selecting a Table 51
- Selecting a Table Cell 51
- Selecting a Row or Column 52
- Selecting Table Cell Borders 53
- 54 Chapter 3 Using Tables 54
- Working with Text in Cells 55
- Working with Numbers in Cells 56
- Working with Dates in Cells 57
- Formatting Cell Values 58
- Chapter 3 Using Tables 59 59
- 60 Chapter 3 Using Tables 60
- Chapter 3 Using Tables 61 61
- 62 Chapter 3 Using Tables 62
- Chapter 3 Using Tables 63 63
- 64 Chapter 3 Using Tables 64
- Chapter 3 Using Tables 65 65
- 66 Chapter 3 Using Tables 66
- Monitoring Cell Values 67
- Autofilling Table Cells 68
- Working with Rows and Columns 69
- Adding Columns 70
- Rearranging Rows and Columns 70
- Chapter 3 Using Tables 71 71
- Using a Footer Row 72
- Hiding Rows and Columns 72
- Alternating Row Colors 73
- Working with Table Cells 74
- Formatting Table Cell Borders 75
- Copying and Moving Cells 76
- Adding Comments 76
- Reorganizing Tables 77
- Filtering Rows 78
- Working with Table Styles 79
- Applying Table Styles 80
- Modifying a Table’s Style 80
- Using the Default Table Style 81
- Creating New Table Styles 82
- Renaming a Table Style 82
- Deleting a Table Style 82
- Using Formulas 83
- A Tour of Using Formulas 84
- Adding a Quick Formula 87
- Removing a Formula 88
- Using the Formula Editor 88
- Using the Formula Bar 90
- Using Cell References 91
- Handling Errors and Warnings 93
- Using Operators 94
- Using Functions 96
- Using Charts 98
- Chapter 6 Using Charts 99 99
- Adding a Chart 101
- Editing Charts 102
- Chapter 6 Using Charts 103 103
- Deleting a Chart 105
- Moving a Chart 105
- Using a Legend 106
- Using a Chart Title 107
- Resizing a Chart 107
- Rotating Charts 107
- Chapter 6 Using Charts 109 109
- Chapter 6 Using Charts 111 111
- Pie Charts 113
- Set a pie wedge apart by 114
- Bar and Column Charts 115
- Area Charts and Line Charts 116
- Scatter Charts 117
- 3D Charts 118
- Working with Text 119
- Selecting Text 120
- Smart quotes 128
- Straight quotes 128
- Adjusting Font Smoothing 129
- Aligning Text Horizontally 131
- Aligning Text Vertically 131
- Changing Text Color 133
- Setting a New Tab Stop 135
- Changing a Tab Stop 135
- Deleting a Tab Stop 135
- Setting Indents 136
- Setting Indents for Lists 137
- Using Bulleted Lists 138
- Using Numbered Lists 139
- Adding Text Boxes 141
- Presenting Text in Columns 141
- Putting Text Inside a Shape 142
- Using Hyperlinks 143
- Editing Hyperlink Text 144
- Inserting a Nonbreaking Space 146
- Finding and Replacing Text 148
- Selecting Objects 149
- Deleting Objects 150
- Moving Objects 150
- Aligning Objects 151
- Modifying Objects 154
- Changing the Style of Borders 155
- Framing Objects 156
- Adding Shadows 156
- Adding a Reflection 158
- Adjusting Opacity 158
- Grouping and Locking Objects 159
- Filling Objects 160
- Using the Colors Window 161
- Using Shapes 164
- Making Shapes Editable 165
- Reshaping a Curve 166
- Reshaping a Straight Segment 167
- Using Media Placeholders 170
- Working with Images 171
- Masking (Cropping) Images 172
- Using PDF Files as Graphics 176
- Using Sound and Movies 177
- Adding Address Book Data 179
- Sharing Your Numbers 183
- Spreadsheet 183
- The ColorSync Utility icon 186
- Sending a Spreadsheet to iWeb 187
- Designing Your Own Numbers 188
- Spreadsheet Templates 188
- Dictionary of Functions 193
- Date and Time Functions 195
- Financial Functions 196
- Logical Functions 198
- Information Functions 198
- Reference Functions 199
- Numeric Functions 200
- Trigonometric Functions 201
- Statistical Functions 202
- Text Functions 204
- Function Descriptions 205
- ACCRINTM 206
- AVERAGEA 211
- CONCATENATE 216
- CONFIDENCE 216
- COUNTBLANK 220
- COUPDAYBS 221
- COUPDAYS 221
- COUPDAYSNC 222
- FORECAST 233
- HYPERLINK 236
- INDIRECT 237
- INTERCEPT 238
- Examples 253
- PERCENTILE 256
- PRICEDISC 260
- PRICEMAT 260
- QUOTIENT 263
- RANDBETWEEN 264
- ROUNDDOWN 268
- SUBSTITUTE 277
- SUMPRODUCT 278
- TIMEVALUE 282
- Index 291 291
- 292 Index 292
- Index 293 293
- 294 Index 294
- Index 295 295
Produits connexes et manuels pour Logiciel Apple Numbers '08
(34 pages)
Logiciel Apple Numbers '09 Manuel d'utilisateur
(288 pages)
(288 pages)
(73 pages)
Logiciel Apple Keynote 1 Manuel d'utilisateur
(100 pages)
(100 pages)
Logiciel Apple Xsan 2 Manuel d'utilisateur
(165 pages)
(165 pages)
Logiciel Apple Logic Pro 9 Manuel d'utilisateur
(357 pages)
(357 pages)
Logiciel Apple Numbers '09 Manuel d'utilisateur
(270 pages)
(270 pages)
Logiciel Apple MainStage Manuel d'utilisateur
(100 pages)
(100 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.052 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels