Apple Numbers '08 Manual do Utilizador Página 237
- Página / 295
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
Chapter 12 Dictionary of Functions 237
INDEX
The INDEX function retrieves the value in the cell located at the intersection of the
specified row and column within a range of cells. You specify the location by indicating
how many rows down and how many columns to the right the cell is in relation to the
upper-left corner of the range.
INDEX(cell-range, [row], [column], [area])
 cell-range: A range or list of ranges containing the values you want to return. If more
than one range is given (specified in a list surrounded by parentheses), the area
argument specifies which range to give a result from.
 row: Optional; the number of the cell’s row, counting from top to bottom with the
topmost cell in the cell range numbered 1. If omitted, you must include column.
 column: Optional; the number of the cell’s column, counting from left to right with
the leftmost cell in the cell range numbered 1. If omitted, you must include row.
 area: Optional; the number of the area in cell-range if it includes more than one.
INDIRECT
The INDIRECT function returns a reference to an address specified as a string.
INDIRECT(address, [style])
 address: A string representing a cell address or a reference to a cell that contains a
cell address.
 style: Optional; address style used in address.
TRUE, 1, or omitted indicates the A1 style address.
FALSE or 0 returns an error indicating that the R1C1 style isn’t supported.
Examples
Given the following table:
INDEX(B2:E5,1,1) returns 2.
INDEX(B2:E5,3,2) returns 1024.
INDEX(B2:E5,2,3) returns 128.
INDEX(B2:E5,1,5) returns an error because the range contains only four columns.
- 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
Manuais e produtos relacionados com Software Apple Numbers '08
Software Apple MainStage 3 Manual do Utilizador
(34 páginas)
(34 páginas)
Software Apple iPhoto '08 Manual do Utilizador
(22 páginas)
(22 páginas)
Software Apple Numbers '09 Manual do Utilizador
(288 páginas)
(288 páginas)
Software Apple AppleShare 3.0 Manual do Utilizador
(20 páginas)
(20 páginas)
Software Apple QuickTime 7.2 Manual do Utilizador
(73 páginas)
(73 páginas)
Software Apple Keynote 1 Manual do Utilizador
(100 páginas)
(100 páginas)
Software Apple Xsan 2 Manual do Utilizador
(165 páginas)
(165 páginas)
Software Apple Logic Pro 9 Manual do Utilizador
(357 páginas)
(357 páginas)
Software Apple Numbers '09 Manual do Utilizador
(270 páginas)
(270 páginas)
Software Apple Logic Express 8 Manual do Utilizador
(83 páginas)
(83 páginas)
Software Apple MainStage Manual do Utilizador
(100 páginas)
(100 páginas)
© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.072 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais