Apple Pages Guide de l'utilisateur Page 190
- Page / 246
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
190 Chapter 9 Using Formulas and Functions in Tables
Here’s a formula that adds the values in nine cells of the first column: SUM(A2:A10).
There is one argument, A2:A10. The colon means the function should use the values
in cells A2 through A10.
You don’t need to understand more than this to use formulas in tables. Templates (such
as the Invoice template) and formula editing tools (such as the Formula Editor) make
basic formulas easy to use.
A Tour of Using Formulas
Reviewing the formulas built into the Invoice template is a good introduction to Pages
formulas.
1 Create a new Pages document using the Invoice template.
Open Pages, choose File > New, click Forms, select Invoice, and then click Choose.
The table in this template uses formulas to derive the values in the Cost column.
2 Select the table, and then double-click the value in the Cost cell in the first row. The
Formula Editor opens, revealing that the value is derived using a formula.
The asterisk symbol (*) is the multiplication operator.
A formula in each cell in the
Cost column automatically
updates totals when quantity
or unit price changes.
The formula in the Cost cell in
the first row multiplies the values
in two other cells—B2 and C2.
- 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
Produits connexes et manuels pour Logiciel Apple Pages
Logiciel Apple iDVD Manuel d'utilisateur
(38 pages)
(38 pages)
Logiciel Apple iDVD 5 Manuel d'utilisateur
(48 pages)
(48 pages)
Logiciel Apple Xsan Manuel d'utilisateur
(165 pages)
(165 pages)
Logiciel Apple Xsan 1.1 Manuel d'utilisateur
(25 pages)
(25 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.448 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels