Apple Pages Betriebsanweisung Seite 192
- Seite / 246
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
192 Chapter 9 Using Formulas and Functions in Tables
5 If the value in a Quantity cell or in a Unit Price cell changes, the formula associated with
the Cost cell updates the value it displays.
Double-click the value in B2, type a different number, click outside B2, and notice that
the value in E2 changes.
6 The value displayed for each cell in the Cost column above the subtotal is derived using
values in each row.
To view the formula for a different Cost cell, double-click the cell. For example, double-
click the Cost cell in the third row (E3). Its formula is B3*C3.
7 Click outside the table, click the table, and then double-click E10, the cell in the Cost
column that’s next to the label “Subtotal.” The formula uses the SUM function to add
the values in cells E2 through E9.
In the formula, the cell references are enclosed in parentheses following the function
name: SUM(E2:E9). E2 and E9 are separated using a colon. The colon is a shorthand way
to refer to a range of cells, in this case, a range of eight cells.
8 Cells E11 and E12 also contain formulas. Examine the formulas in these cells by clicking
outside the table, selecting the table, then double-clicking cell E11 or E12. Cell E11
contains a formula that computes sales tax, and cell E12 contains a formula that sums
the subtotal and the sales tax.
Adding a Quick Formula
An easy way to perform a basic calculation using values in a range of adjacent table
cells is to add a quick formula using the Quick Formula pop-up menu in the Format
pane of the Table Inspector.
You can also choose Insert > Function and use the submenu that appears.
- 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
Verwandte Produkte und Handbücher für Software Apple Pages
Software Apple iDVD Bedienungsanleitung
(38 Seiten)
(38 Seiten)
Software Apple Logic Express 7 Technical Information
(167 Seiten)
(167 Seiten)
Software Apple iDVD 5 Bedienungsanleitung
(48 Seiten)
(48 Seiten)
Software Apple iMovie HD Bedienungsanleitung
(10 Seiten)
(10 Seiten)
Software Apple Logic Pro 7.1 Bedienungsanleitung
(16 Seiten)
(16 Seiten)
Software Apple iMovie HD Bedienungsanleitung
(19 Seiten)
(19 Seiten)
Software Apple Xsan Bedienungsanleitung
(165 Seiten)
(165 Seiten)
Software Apple Logic Pro 7.1 Bedienungsanleitung
(28 Seiten)
(28 Seiten)
Software Apple Xsan 1.1 Bedienungsanleitung
(25 Seiten)
(25 Seiten)
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 1.417 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern