Apple Pages Podręcznik Użytkownika Strona 196
- Strona / 246
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
196 Chapter 9 Using Formulas and Functions in Tables
Adding Cell References to a Formula
To insert a cell reference, you can click a cell, click a reference tab, or select a range of
cells when there’s an insertion point in the text field of the Formula Editor. You can also
insert a cell reference by typing
When you insert a cell reference by selecting cells or reference tabs, Pages adds cell
references that use header cell names if “Use header cell names as references” is
selected in the General pane of Pages preferences.
Here are ways to add a cell reference at the insertion point in the text field:
m To create a reference to a specific cell by using your mouse, click the cell.
You can also type a reference to a specific cell. Use the column letter followed by the
row number (A4) in the reference tabs or use the column name followed by the row
name (2006 Class Enrollment).
m To add a reference to a list of individual cells, click each cell. If the references are
arguments in a function, Pages automatically inserts a comma (,) between the
references, which you can replace with a different character if needed. For example, if
you’re in a location where the decimal separator is a comma, you can separate multiple
cell references using a semicolon instead of a comma.
m To add a reference to a range of adjacent cells, drag over the cells you want to add.
You can also type or click the first cell, type a colon, and then type or click the last cell.
For example B2:B5 refers to four cells in the second column. B2:C3 refers to two cells in
the second column and two cells in the third column.
m To refer to all the cells in a column, click the column’s reference tab or click its header
cell if there is one.
You can type the reference by using the column letter (C or C:C) or the column name if
there’s a header cell. For example, SUM(B) or SUM(B:B) adds all the values in the cells of
the second column.
m To refer to all the cells in a row, click the row’s reference tab or click its header cell if
there is one.
You can type the reference by using the row number (1:1) or the row name if there’s a
header cell. For example, SUM(1:1) adds all the values in the cells of the first row.
Copying or Moving Formulas with Cell References
You can copy or move a formula that contains cell references without invalidating the
references.
Here are techniques for relocating formulas:
m To move a formula to a different cell, move the formula’s cell by dragging it to another
cell.
- Pages ’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
- Pages Tools and Techniques 16
- Document Viewing Aids 18
- Document Page Views 19
- Layout View 19
- The Toolbar 22
- The Format Bar 23
- The Inspector Window 23
- The Media Browser 24
- The Font Panel 25
- The Colors Window 25
- Rulers and Alignment Guides 25
- The Styles Drawer 26
- The Warnings Window 28
- Research and Reference Tools 28
- Word Processing Templates 30
- Page Layout Templates 31
- Creating a New Document 31
- Importing a Document 33
- Saving Your Document 34
- Undoing Changes 35
- Saving a Copy of a Document 35
- Designing Documents 37
- Appearance of Text 38
- Graphics and Other Objects 38
- Working with Document Parts 39
- Setting Document Margins 42
- Using Page and Line Breaks 42
- Using Layouts 44
- Defining Column Breaks 45
- Defining Layout Breaks 46
- Defining Layout Margins 47
- Viewing Facing Pages 48
- Using Headers and Footers 49
- Using Footnotes and Endnotes 49
- Using Sections 53
- Defining Section Attributes 55
- Reusing Sections 56
- Master objects have 57
- Using a Table of Contents 58
- Styling a Table of Contents 59
- Reviewing and Revising 61
- Documents 61
- Using Change Tracking 62
- A Tour of Change Tracking 63
- Click to accept changes 65
- Click to reject changes 65
- Select to stop 65
- Choose how edited text is 66
- Accepting and Rejecting Edits 67
- Using Comments 68
- Click to delete 69
- Working with Text 70
- Placeholder text 71
- The entire text area is 71
- Adding New Template Pages 72
- Deleting Pages 73
- Selecting Text 74
- Smart quotes 83
- Straight quotes 83
- Ligature not used 83
- Ligature used 83
- Adjusting Font Smoothing 84
- Aligning Text Horizontally 85
- Aligning Text Vertically 86
- Changing Text Color 89
- Setting Indents 94
- Setting Indents for Lists 95
- Using Bulleted Lists 96
- Using Numbered Lists 98
- Adding Text Boxes 100
- Linking Floating Text Boxes 102
- Adding Borders and Rules 104
- Presenting Text in Columns 105
- Putting Text Inside a Shape 106
- Linking to a Webpage 107
- Editing Hyperlink Text 110
- Text wraps around 112
- Using Automatic Hyphenation 113
- Inserting a Nonbreaking Space 114
- Proofreading Documents 115
- Finding and Replacing Text 116
- Type the word or phrase 117
- Select an item in the 117
- Working with Styles 118
- About Styles 119
- Applying Styles 120
- Click to show list styles 121
- Click to show 121
- Changing the Style of Text 122
- Modifying Paragraph Styles 123
- Creating New Paragraph Styles 126
- Modifying Character Styles 127
- Creating New Character Styles 128
- Renaming a Style 133
- Deleting a Style 133
- Drag any of the selection 134
- Selecting Objects 135
- Deleting Objects 136
- Moving Objects 137
- Aligning Objects 138
- Modifying Objects 141
- Flipping and Rotating Objects 142
- Changing the Style of Borders 142
- Framing Objects 143
- Adding Shadows 144
- Adding a Reflection 145
- Adjusting Opacity 146
- Grouping and Locking Objects 147
- Filling Objects 147
- Using the Colors Window 148
- Using Shapes 151
- Making Shapes Editable 152
- Click a point and drag it 153
- Reshaping a Curve 154
- Reshaping a Straight Segment 154
- Using Media Placeholders 157
- Working with Images 158
- Masking (Cropping) Images 159
- Using PDF Files as Graphics 163
- Using Sound and Movies 164
- Adding a Movie File 165
- Using Tables 167
- Working with Tables 168
- Chapter 8 Using Tables 169 169
- Resizing a Table 170
- Moving Tables 171
- Converting Text to a Table 172
- Selecting a Table 172
- Selecting a Table Cell 172
- Selecting a Row or Column 174
- Selecting Table Cell Borders 174
- Working with Text in Cells 175
- Working with Numbers in Cells 176
- Working with Dates in Cells 177
- Formatting Cell Values 178
- Chapter 8 Using Tables 179 179
- Monitoring Cell Values 181
- Autofilling Table Cells 182
- Working with Rows and Columns 183
- Using a Footer Row 185
- Alternating Row Colors 185
- Working with Table Cells 186
- Formatting Table Cell Borders 187
- Copying and Moving Cells 187
- Sorting Table Cells 188
- Using Formulas and Functions 189
- A Tour of Using Formulas 190
- Adding a Quick Formula 192
- Removing a Formula 194
- Using the Formula Editor 194
- Using Cell References 195
- Using Operators 197
- Using Functions 200
- Using Charts 201
- Adding a Chart 204
- Selecting a Chart Type 204
- Editing Chart Data 206
- Using a Legend 207
- Using a Chart Title 208
- Resizing a Chart 208
- Rotating Charts 209
- Choose a line style 210
- Choose a line width 210
- Choose a line color 210
- Pie Charts 214
- Set a pie wedge apart 215
- Bar and Column Charts 216
- Area Charts and Line Charts 217
- Scatter Charts 218
- 3D Charts 219
- Personalizing Documents 220
- Using Address Book Fields 221
- Inserting Sender Data 221
- Printing and Exporting Your 225
- Document to Other Formats 225
- Printing Comments 227
- The ColorSync Utility icon 229
- Designing Your Own 233
- Document Templates 233
- Step 1: Set Up the Document 234
- Defining Default Styles 235
- Creating Placeholder Text 238
- Creating Media Placeholders 238
- 241 241
- 242 Index 242
- Index 243 243
- 244 Index 244
- Index 245 245
- 246 Index 246
Powiązane produkty i podręczniki dla Oprogramowanie Apple Pages
Oprogramowanie Apple iDVD Instrukcja Użytkownika
(38 strony)
(38 strony)
Oprogramowanie Apple Xsan Instrukcja Użytkownika
(165 strony)
(165 strony)
LG 86UH955V manuali
Manuali dei proprietari e guide per l'utente per no LG 86UH955V.
We fornisce 1 manuali pdf LG 86UH955V per scaricare gratuitamente in base al tipo di documento: Manuale Utente
Indice
Più prodotti e manuali per no LG
| Modelli | Tipo di Documento |
|---|---|
| TD-C70043E |
Manuale Utente
LG TD-C70043E Εγχειρίδιο Χρήσης [en] ,
28 pagine
|
| V-CB211HTU | Manuale Utente LG V-CB211HTU 使用手冊, 6 pagine |
| MS-1940V | Manuale Utente LG MS-1940V Instruktionsbogen, 27 pagine |
| DWD-1280FD | Manuale Utente LG DWD-1280FD Instruktionsbogen, 27 pagine |
| L2000CP-BF |
Manuale Utente
LG L2000CP-BF 产品说明书,
22 pagine
|
| 43UH619V |
Manuale Utente
 
LG 43UH610V,49UH610V,43UH619V Інструкція користувача [en] ,
50 pagine
|
| NC1000-BAAB |
Manuale Utente
LG NC1000-BAAB Руководство пользователя [en] ,
117 pagine
|
| MP500-BEBF |
Manuale Utente
LG MP500-BEBF 使用手冊,
41 pagine
|
| NB2020A | Manuale Utente LG NB2020A Εγχειρίδιο Χρήσης, 18 pagine |
| 43LJ550T |
Manuale Utente
LG 43LJ550T,49LJ550T 使用手冊,
37 pagine
|
| ARNU05GTRC4.ENWBLEU | Manuale Utente LG ARNU05GTRC4.ENWBLEU,ARNU18GTQC4.ENWBLEU,ARNU36GTNC4.ENWBLEU Instruktionsbogen, 13 pagine |
| LGT505 |
Manuale Utente
LG LGT505 Owner's manual [it] ,
2 pagine
|
| GR-T382SV | Manuale Utente LG GR-T382SV Owner’s Manual, 13 pagine |
| LAM-N760 |
Manuale Utente
LG LAM-N760 Руководство пользователя,
24 pagine
|
| RN29Q12IP | Manuale Utente LG RN29Q12IP Instruktionsbogen, 26 pagine |
| C12LH.NB1 | Manuale Utente LG C09LH,C12LH,C09LH.NB1,C12LH.NB1 Brukermanual, 25 pagine |
| SJ3 | Manuale Utente LG SJ3 Οδηγός Χρήσης, 4 pagine |
| ND5430 | Manuale Utente LG ND5430 Εγχειρίδιο Χρήσης, 24 pagine |
| 52LG50FR |
Manuale Utente
LG 52LG50FR 产品说明书,
106 pagine
|
| HVW6442AG |
Manuale Utente
LG HVW6442AG Руководство пользователя,
28 pagine
|
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.033 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji