Microsoft Office Excel: a professional approach
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Boston [u.a.]
McGraw-Hill
2008
|
| Schriftenreihe: | Professional approach series
|
| Schlagworte: | |
| Online-Zugang: | Publisher description Table of contents only Inhaltsverzeichnis |
| Beschreibung: | Includes index. |
| Beschreibung: | Getr. Zählung Ill., graph. Darst. |
| ISBN: | 9780073519210 9780073294674 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV035078992 | ||
| 003 | DE-604 | ||
| 005 | 20091105 | ||
| 007 | t | ||
| 008 | 081001s2008 xxuad|| |||| 00||| eng d | ||
| 010 | |a 2007011392 | ||
| 020 | |a 9780073519210 |9 978-0-07-351921-0 | ||
| 020 | |a 9780073294674 |9 978-0-07-329467-4 | ||
| 035 | |a (OCoLC)87755659 | ||
| 035 | |a (DE-599)BVBBV035078992 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 050 | 0 | |a HF5548.4.M523 | |
| 082 | 0 | |a 005.54 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Stewart, Kathleen |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Microsoft Office Excel |b a professional approach |c Kathleen Stewart |
| 246 | 1 | 3 | |a Excel 2007 |
| 246 | 1 | 3 | |a Microsoft Office Excel 2007 |
| 264 | 1 | |a Boston [u.a.] |b McGraw-Hill |c 2008 | |
| 300 | |a Getr. Zählung |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Professional approach series | |
| 500 | |a Includes index. | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Wirtschaft | |
| 650 | 4 | |a Business |x Computer programs | |
| 650 | 4 | |a Electronic spreadsheets | |
| 650 | 0 | 7 | |a Excel 2007 |0 (DE-588)7558101-2 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Excel 2007 |0 (DE-588)7558101-2 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0710/2007011392-d.html |3 Publisher description | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0710/2007011392-t.html |3 Table of contents only | |
| 856 | 4 | 2 | |m Digitalisierung UB Bayreuth |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016747261&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-016747261 | |
Datensatz im Suchindex
| _version_ | 1807864500976615424 |
|---|---|
| adam_text |
conLen
Preface
Installation Requirements
Windows Tutorial
Case Study
XVI
xviii
XX
xlii
EXCEL
J
Unit
1
Introduction to Excel
LESSON
1:
GETTING STARTED
WITH EXCEL
Starting Excel
Exercise
1-1:
Work with the Excel Interface
Navigating in a Workbook
Exercise
1-2:
Move Between Worksheets
Exercise
1-3:
Go to a Specific Cell
Exercise
1-4:
Scroll Through a Worksheet
Exercise
1-5:
Change the Zoom Size
Exercise
1-6:
Close a Workbook
Opening an Existing Workbook
Exercise
1-7:
Open a Workbook
Editing a Worksheet
Exercise
1-8:
View Worksheets and
Cell Contents
Exercise
1-9:
Replace Cell Contents
Exercise
1-10:
Edit Cell Contents
Exercise
1-11:
Clear Cell Contents
Exercise
1-12:
Use Undo and Redo
Managing Files
Exercise
1-13:
Create a New Folder and
Use Save As
Printing Excel Files
Exercise
1-14:
Preview and
Print a Worksheet
Exercise
1-15:
Print a Workbook
Exercise
1-16:
Save an XPS File
Exercise
1-17:
Exit Excel
Lesson
1
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
1-18
Exercise
1-19
Exercise
1-20
Exercise
1-21
Lesson Applications
Exercise
1-22
Exercise
1-23
Exercise
1-24
Exercise
1-25
2
4
6
7
7
9
11
12
12
12
13
14
15
16
18
18
20
20
21
22
23
24
25
26
28
28
28
29
29
29
30
30
31
32
32
32
33
33
On Your Own
34
Exercise
1-26 34
Exercise
1-27 34
Exercise
1-28 34
LESSON
2:
CREATING A WORKBOOK
36
Entering Labels
36
Exercise
2-1:
Enter Labels in a Worksheet
37
Changing the Document Theme
38
Exercise
2-2:
Change the Theme
39
Exercise
2-3:
Change the Font, Font Size,
and Style
41
Exercise
2-4:
Use the Format Painter
42
Selecting Cell Ranges
43
Exercise
2-5:
Select Ranges with the Mouse
43
Exercise
2-6:
Select Ranges with Keyboard
Shortcuts
45
Modifying Column Width and Row Height
47
Exercise
2-7:
Modify Column Width
47
Exercise
2-8:
Modify Row Height
48
Entering Values and Dates
49
Exercise
2-9:
Enter Dates and Values
49
Exercise
2-Ю:
Apply Number Formats
from the Ribbon
50
Exercise
2-11:
Apply Date Formats from the
Dialog Box
51
Exercise
2-12:
Change the Font Color
52
Exercise
2-13:
Rename a Worksheet
and Change the Tab Color
53
Saving a Workbook
54
Exercise
2-14:
Save a Workbook
55
Entering Basic Formulas
55
Exercise
2-15:
Key a Basic Formula
56
Exercise
2-16:
Enter a Formula by Pointing
58
Exercise
2-17:
Copy a Formula by Using
the Copy and Paste Buttons
58
Exercise
2-18:
Use AutoSum, Average,
and Max
59
Exercise
2-19:
Check Results with
AutoCalculate
61
Lesson
2
Summary
63
Concepts Review
65
True/False Questions
65
Short Answer Questions
65
IV
Contents
Critical Thinking
66
Skills Review
66
Exercise
2-20 66
Exercise
2-21 67
Exercise
2-22 68
Exercise
2-23 69
Lesson Applications
71
Exercise
2-24 71
Exercise
2-25 72
Exercise
2-26 72
Exercise
2-27 73
On Your Own
73
Exercise
2-28 73
Exercise
2-29 74
Exercise
2-30 74
LESSON
3:
USING EDITING
AND STYLE TOOLS
76
Using AutoCorrect and
Error Checking
76
Exercise
3-1:
Use AutoCorrect to
Correct Errors
77
Exercise
3-2:
Set AutoCorrect Options
78
Exercise
3-3:
Review Error Checking
79
Checking Spelling
80
Exercise
3-4:
Spell-Check a Worksheet
80
Using Find and Replace
82
Exercise
3-5:
Find Data
83
Exercise
3-6:
Use Wildcards
85
Exercise
3-7:
Replace Data
85
Exercise
3-8:
Replace a Function in
a Formula
86
Exercise
3-9:
Correct Errors with
Replace
86
Exercise
3-10:
Find and Replace Formats
87
Exercise
3-11 :
Reset Find and Replace
Formats
89
Using Series and AutoFill
89
Exercise
3-12:
Create Month and Week Series
89
Exercise
3-13:
Create a Number Series
90
Exercise
3-14:
Copy Data with the Fill Handle
91
Exercise
3-15:
Copy a Formula with the
Fill Handle
91
Applying Table and Cell Styles
92
Exercise
3-16:
Create a Table
92
Exercise
3-17:
Change the Table Style
93
Exercise
3-18:
Apply a Cell Style
94
Exercise
3-19:
Print a Selection
95
Preparing Headers and Footers
95
Exercise
3-20:
Set Headers and Footers
96
Exercise
3-21:
Print Gridlines and Row
and Column Headings
97
Exercise
3-22:
Change Margins and
Column Widths in Page Layout View
98
Lesson
3
Summary
99
Concepts Review
101
True/False Questions
101
Short Answer Questions
101
Critical Thinking
Ю2
Skills Review
102
Exercise
3-23 102
Exercise
3-24 103
Exercise
3-25 104
Exercise
3-26 105
Lesson Applications
107
Exercise
3-27 107
Exercise
3-28 107
Exercise
3-29 108
Exercise
3-30 109
On Your Own
110
Exercise
3-31 110
Exercise
3-32 110
Exercise
3-33 111
LESSON
4:
EXPLORING HOME TAB
COMMANDS
112
Inserting and Deleting Sheets and Cells
112
Exercise
4-1:
Insert Worksheets
113
Exercise
4-2:
Move and Delete Worksheets
114
Exercise
4-3:
Insert Cells
115
Exercise
4-4:
Delete Cells
116
Using AutoComplete and Pick From
Drop-Down List
116
Exercise
4-5:
Use AutoComplete
117
Exercise
4-6:
Use Pick From Drop-Down List
118
Copying, Cutting, and Pasting Cell Contents
119
Exercise
4-7:
Cut and Paste Cell Contents
119
Exercise
4-8:
Copy and Paste Cell Contents
120
Exercise
4-9:
Use Drag and Drop
122
Exercise
4-10:
Use the Office Clipboard
123
Working with Columns and Rows
124
Exercise
4-11:
Insert Rows
125
Exercise
4-12:
Delete Rows
127
Exercise
4-13:
Insert and Delete Rows
127
Exercise
4-14:
Hide and Unhide Columns
and Rows
127
Exercise
4-15:
Freeze and Split the Window
128
Working with Cell Alignment
130
Exercise
4-16:
Change the Horizontal
Alignment
131
Exercise
4-17:
Use Center Across Selection
131
Exercise
4-18:
Change the Vertical Alignment
133
Exercise
4-19:
Wrap Text and Change Indents
133
Exercise
4-20:
Use Merge and Center
134
Exercise
4-21:
Change Cell Orientation
134
Applying Borders and Fill
135
Exercise
4-22:
Apply Borders Using the
Borders Button
135
Exercise
4-23:
Apply Borders Using the
Dialog Box
137
Exercise
4-24:
Add Solid Fill
139
Exercise
4-25:
Use Pattern Fill
139
Exercise
4-26:
Complete the Number
Formatting
140
Using Data Bars
142
Exercise
4-27:
Use Data Bars
142
Exercise
4-28:
Edit the Data Bar Rule
143
Contents
Lesson
4
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
4-29
Exercise
4-30
Exercise
4-31
Exercise
4-32
Lesson Applications
Exercise
4-33
Exercise
4-34
145
147
147
147
148
148
148
149
150
151
153
153
154
Exercise
4-35
Exercise
4-36
On Your Own
Exercise
4-37
Exercise
4-38
Exercise
4-39
UNIT
1
APPLICATIONS
Unit Application
1 -1
Unit Application
1-2
Unit Application
1-3
Unit Application
1-4
154
155
156
136
156
156
157
157
157
159
159
Unit
2
Working with Formulas and Functions
LESSON
5:
EXPLORING
FORMULA BASICS
162
Using a Template to Create a Workbook
162
Exercise
5-1:
Create a Workbook from
a Template
163
Building Addition and Subtraction Formulas
164
Exercise
5-2:
Create and Copy Addition
Formulas
164
Exercise
5-3:
Create and Copy
Subtraction Formulas
166
Building Multiplication and
Division Formulas
167
Exercise
5-4:
Create Multiplication Formulas
167
Exercise
5-5:
Edit a Formula in the
Formula Bar
168
Exercise
5-6:
Create Division Formulas
169
Exercise
5-7:
Apply the Percent Style and
Increase Decimal Positions
169
Using Order of Precedence in a Formula
170
Exercise
5-8:
Use Multiplication and
Addition in a Formula
171
Exercise
5-9:
Set Order of Precedence
172
Using Relative, Absolute, and
Mixed References
173
Exercise
5-10:
Use a Line Break
173
Exercise
5-11 :
Copy a Formula with a
Relative Reference
174
Exercise
5-12:
Create a Formula with
an Absolute Reference
175
Exercise
5-13:
Use a Color Scale
175
Exercise
5-14:
Use Mixed References
177
Exercise
5-15:
Add Borders and Fill
for Printing
178
Working with the Page Layout Tab
179
Exercise
5-16:
Change Page Orientation
179
Exercise
5-17:
Change Scaling and Page
Margins
179
Exercise
5-18:
Copy a Worksheet and
Display Formulas
181
Exercise
5-19:
Add a Background
182
Exercise
5-20:
Save a W'orkbook as a
Web Page
183
Lesson
5
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
5-21
Exercise
5-22
Exercise
5-23
Exercise
5-24
Lesson Applications
Exercise
5-25
Exercise
5-26
Exercise
5-27
Exercise
5-28
On Your Own
Exercise
5-29
Exercise
5-30
Exercise
5-31
185
187
187
187
188
188
188
189
190
191
194
194
194
195
196
196
196
197
197
LESSON
6:
WORKING WITH FUNCTIONS
198
Using Math and Trig Functions
198
Exercise
6-1:
Use SUM and the Formula Bar
199
Exercise
6-2:
Use Insert Function
201
Exercise
6-3:
Use TRUNC
203
Exercise
6-4:
Use SUMIF
204
Using Statistical Functions
205
Exercise
6-5:
Use the AVERAGE Function
205
Exercise
6-6:
Use AVERAGEIF
206
Exercise
6-7:
Use the
MIN
and
MAX Functions
206
Exercise
6-8:
Use COUNT and
COUNTBLANK
208
Exercise
6-9:
Use the
COUNTA
Function
209
Using Icon Sets
210
Exercise
6-10:
Apply Icon Sets
210
Exercise
6-11:
Edit the Icon Formatting Rule
211
Grouping Worksheets
212
Exercise
6-12:
Group and
Delete Worksheets
212
Exercise
6-13:
Manase
Worksheets
21 ?
vi
Contents
Using Date and lime Functions
Exercise
6-14:
Use the TODAY() Function
Exercise
6-15:
Key and Format Dates
Exercise
6-16:
Use Fill Across Worksheets
Exercise
6-17:
Create a Custom Date Format
Exercise
6-18:
Key and Format Times
Exercise
6-19:
Use the NOW() Function
Exercise
6-20:
Create a Custom
Time Format
Exercise
6-21:
Add a Header to
Grouped Sheets
Lesson
6
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
6-22
Exercise
6-23
Exercise
6-24
Exercise
6-25
Lesson Applications
Exercise
6-26
Exercise
6-27
Exercise
6-28
Exercise
6-29
On Your Own
Exercise
6-30
Exercise
6-31
Exercise
6-32
LESSON
7:
USING LOGICAL AND
FINANCIAL FUNCTIONS
Using the IF Function
Exercise
7-1:
Use IF to Show Text
Exercise
7-2:
Use IF to Calculate a Value
Using AND, OR, and NOT Functions
Exercise
7-3:
Use the AND Function
Exercise
7-4:
Use the OR Function
Exercise
7-5:
Use the NOT Function
Working with Cell Styles
Exercise
7-6:
Use Cell Styles
Exercise
7-7:
Clear and Reapply Cell Styles
Exercise
7-8:
Create a Style
Exercise
7-9:
Edit a Style
Working with Page Breaks
Exercise
7-10:
Preview and Change
Page Breaks
Exercise
7-11:
Remove and Insert
Page Breaks
Exercise
7-12:
Set Print Titles
Exercise
7-13:
Center a Page
Exercise
7-14:
Change the Footer Font
and Print Page Numbers
Exercise
7-15:
Remove a Page Break
Using the PMT and FV Functions
Exercise
7-16:
Use the PMT Function
Exercise
7-17:
Kev a PMT Function
214
214
215
216
217
218
219
219
220
222
223
223
223
224
224
224
225
226
227
229
229
230
230
231
232
232
232
233
234
234
235
237
238
238
240
241
242
242
243
243
244
244
245
Exercise
7-18:
Use the FV Function
254
Exercise
7-19:
Format Negative Numbers
255
Using Depreciation Functions
255
Exercise
7-20:
Use the
DB
Function
256
Exercise
7-21 :
Copy and Edit the
DB
Function
258
Lesson
7
Summary
259
Concepts Review
261
True/False Questions
261
Short Answer Questions
261
Critical Thinking
262
Skills Review
262
Exercise
7-22 262
Exercise
7-23 263
Exercise
7-24 264
Exercise
7-25 266
Lesson Applications
268
Exercise
7-26 268
Exercise
7-27 268
Exercise
7-28 269
Exercise
7-29 269
On Your Own
Exercise
7-30
Exercise
7-31
Exercise
7-32
LESSON
8:
ROUNDING AND NESTING
FUNCTIONS
Using the INT Function
Exercise
8-1 :
Use INT with a Cell Reference
Exercise
8-2:
Compare Values with INT
Using the ROUND Function
Exercise
8-3:
Use ROUND
Exercise
8-4:
Compare Rounded Values
Exercise
8-5:
Change Colors and Borders
Using Date and
Ήπιε
Arithmetic
Exercise
8-6:
Determine Ages and Dates
Exercise
8-7:
Determine Time Passed
Exercise
8-8:
Group Sheets to Add Footers
Exercise
8-9:
Hide and Unhide a Worksheet
Creating Nested Functions
Exercise
8-10:
Nest SUM and ROUND
Exercise
8-11 :
Create a Nested IF Function
Exercise
8-12:
Set Top/Bottom Conditional
Formatting
Creating a Hyperlink
Exercise
8-13:
Create a Hyperlink
Exercise
8-14:
Run the Compatibility
Checker
246
Lesson
8
Summary
248
Concepts Review
249
True/False Questions
249
Short Answer Questions
250
Critical Thinking
251
Skills Review
251
Exercise
8-15
252
Exercise
8-16
270
270
270
271
272
272
273
273
274
274
275
276
277
277
278
279
280
280
280
282
283
284
284
286
287
289
289
289
290
290
290
291
Contents
VII
Exercise
8-17
Exercise
8-18
Lesson
Applications
Exercise
8-19
Exercise
8-20
Exercise
8-21
Exercise
8-22
On
Your Own
Exercise
8-23
Exercise
8-24
Exercise
8-25
292
293
294
294
294
295
296
297
297
297
297
UNIT
2
APPLICATIONS
Unit Application
2-1
Unit Application
2-2
Unit Application
2-3
Unit Application
2-4
298
298
298
299
300
Unit
3
Enhancing Worksheet Appearance
LESSON
9:
BUILDING CHARTS
Viewing and Printing a Chart
Exercise
9-1:
View a Chart Object
Exercise
9-2:
Print a Chart Object
Working with Chart Elements
Exercise
9-3:
Change the Chart Layout
Exercise
9-4:
Change the Chart Style
Exercise
9-5:
Edit and Format the
Chart Title
Exercise
9-6:
Set Shape Fill and Effects
Exercise
9-7:
Set and Format Data Labels
Exercise
9-8:
Format the Axes
302
303
303
304
304
306
307
307
309
311
311
Exercise
9-9:
Format the Plot and Chart Areas
312
Creating Charts
313
Exercise
9-10:
Create and Edit a Chart Sheet
314
Exercise
9-11:
Create a Chart Object
315
Exercise
9-12:
Move and Size a Chart Object
315
Exercise
9-13:
Change the Layout and Styles
316
Exercise
9-14:
Create a Bar Chart Sheet
317
Exercise
9-15:
Add Gridlines and a
Data Table
318
Editing Chart Data
319
Exercise
9-16:
Edit Chart Data
319
Exercise
9-17:
Add a Data Point
319
Exercise
9-18:
Add and Rename Data Series
321
Exercise
9-19:
Delete Data Points and a
Data Series
323
Using Images, Gradients, and Textures
for a Data Series
323
Exercise
9-20:
Use an Image for a Data Series
323
Exercise
9-21 :
Use a Gradient for a
Data Series
325
Exercise
9-22:
Use a Texture for a Data Point
326
Creating a Combination Chart
327
Exercise
9-23:
Create a Chart with Two
Chart Types
327
Exercise
9-24:
Build a Chart with Two Series
328
Exercise
9-25:
Add a Secondary Axis
329
Lesson
9
Summary
330
Concepts Review
332
True/False Questions
332
Short Answer Questions
332
Critical Thinking
333
Skills Review
333
Exercise
9-26 333
Exercise
9-27 334
Exercise
9-28 335
Exercise
9-29 336
Lesson Applications
338
Exercise
9-30 338
Exercise
9-31 338
Exercise
9-32 339
Exercise
9-33 340
On Your Own
340
Exercise
9-34 340
Exercise
9-35 341
Exercise
9-36 341
LESSON
10:
INSERTING SHAPES
342
Adding and Formatting a Callout
343
Exercise
10-1 :
Add a Callout to a Worksheet
343
Exercise
10-2:
Format and Move a Callout
345
Exercise
10-3:
Use the Format Shape Dialog
Box
346
Using Text Boxes
348
Exercise
10-4:
Add a Text Box
348
Exercise
10-5:
Format and Move a Text Box
348
Exercise
10-6:
Choose a Shape Style
349
Inserting Basic Shapes and Arrows
350
Exercise
10-7:
Add a Shape and an Arrow
350
Exercise
10-8:
Resize the Name Box
351
Exercise
10-9:
Use the Selection and
Visibility Pane
352
Using the Drawing Tools Format Tab
353
Exercise
10-10:
Format Multiple Shapes
353
Exercise
10-11:
Copy and Move Objects
353
Exercise
10-12:
Size Shapes
354
Exercise
10-13:
Align and Nudge Shapes
356
Exercise
10-14:
Change a Shape
356
Exercise
10-15:
Use the Adjustment Handle
357
Exercise
10-16:
Rotate Shapes
358
Exercise
10-17:
Style Multiple Shapes
359
Using Comments
359
Exercise
10-18:
Edit a Comment
360
Exercise
10-19:
Insert a Comment
361
viii
Contents
Exercise
10-20:
Pri;
Comments
361
Exercise
10-21:
Use Document Inspector
361
Inserting WordArt
363
Exercise
10-22:
Insert WordArt
363
Exercise
10-23:
Edit WordArt
364
Lesson
10
Summary
365
Concepts Review
367
True/False Questions
367
Short Answer Questions
367
Critical Thinking
368
Skills Review
368
Exercise
10-24 368
Exercise
10-25 369
Exercise
10-26 371
Exercise
10-27 372
Lesson Applications
373
Exercise
10-28 373
Exercise
10-29 373
Exercise
10-30 374
Exercise
10-31 374
On Your Own
375
Exercise
10-32 375
Exercise
10-33 375
Exercise
10-34 375
LESSON
11:
USING IMAGES AND
SMARTART GRAPHICS
376
Inserting a Picture
376
Exercise
11-1:
Insert a Picture from a File
377
Exercise
11-2:
Check Properties and Scale
the Picture
378
Exercise
11-3:
Format and Copy
an Image
379
Exercise
11-4:
Insert Clip Art
379
Exercise
11-5:
Crop, Size, and Style
an Image
380
Adding a Picture to a Header/Footer
381
Exercise
11-6:
Insert an Image in
a Footer
381
Exercise
11-7:
Size an Image in a Footer
382
Exercise
11-8:
Create a Watermark
383
Creating a Hierarchy SmartArt Shape
383
Exercise
11 -9:
Create and Style an
Organization Chart
383
Exercise
11-10:
Add a Shape to an
Organization chart
385
Exercise
11 -11 :
Add Text to the Shapes
3 86
Building a Cycle SmartArt Shape
387
Exercise
11-12:
Create a Cycle Diagram
387
Exercise
11-13:
Move Text in the Text Pane
388
Exercise
11-14:
Choose a New Layout
389
Using the Research Tool
389
Exercise
11-15:
Find Synonyms
390
Exercise
11-16:
Translate Words
392
Exercise
11-17:
Use a Special Symbol
393
Exercise
11-18:
Set Document Properties
394
Lesson
11
Summary
396
Concepts Review
397
True/False Questions
397
Short Answer Questions
397
Critical Thinking
398
Skills Review
398
Exercise
11-19 398
Exercise
11-20 399
Exercise
11-21 400
Exercise
11-22 401
Lesson Applications
403
Exercise
11-23 403
Exercise
11-24 403
Exercise
11-25 404
Exercise
11-26 405
On Your Own
405
Exercise
11-27 405
Exercise
11-28 406
Exercise
11-29 406
UNIT
3
APPLICATIONS
407
Unit Application
3-1 407
Unit Application
3-2 407
Unit Application
3-3 408
Unit Application
3-4 408
Unit
4
Expanding Uses of Workbook Data
LESSON
12:
USING
3-D
REFERENCES
410
Working with Multiple Sheets
410
Exercise
12-1:
Edit a Marked-as-Final
Workbook
410
Exercise
12-2:
Group Sheets for Editing
411
Creating a
3-D
Reference
412
Exercise
12-3:
Create a Single-Cell
3-D
Reference
412
Exercise
12-4:
Edit Referenced Data
413
Using a Formula in a
3-D
Reference
413
Exercise
12-5:
Use Addition in a
3-D
Reference
414
Exercise
12-6:
Use Multiplication in a
3-D
Reference
415
Exercise
12-7:
Copy and Scroll
Multiple Worksheets
416
Using a Function in a
3-D
Reference
417
Exercise
12-8:
Key Data in a Selected Range
418
Exercise
12-9:
Use AVERAGE in a
3-D
Reference
418
Exercise
12-10:
Use MAX in a
3-D
Reference
419
Creating a Digital Signature
421
Exercise
12-11:
Add a Digital Signature
421
Exercise
12-12:
Remove a Digital Signature
422
Contents
ix
Lesson
12
Summary
423
Concepts Review
424
True/False Questions
424
Short Answer Questions
424
Critical Thinking
425
Skills Review
425
Exercise
12-13 425
Exercise
12-14 426
Exercise
12-15 427
Exercise
12-16 428
Lesson Applications
430
Exercise
12-17 430
Exercise
12-18 430
Exercise
12-19 431
Exercise
12-20 431
On Your Own
432
Exercise
12-21 432
Exercise
12-22 433
Exercise
12-23 433
LESSON
13:
WORKING WITH TABLES
434
Preparing a List as a Table
434
Exercise
13-1:
Prepare a List
435
Exercise
13-2:
Create a Table
437
Working with the Table Tools Design
and Data Tabs
438
Exercise
13-3:
Restyle a
Table
438
Exercise
13-4:
Name a Table and Remove
Duplicates
438
Exercise
13-5:
Sort Records in a Table
440
Exercise
13-6:
Sort by Multiple
Columns
440
Adding and Filtering Records
441
Exercise
13-7:
Add a Record to a Table
441
Exercise
13-8:
Resize a Table
441
Exercise
13-9:
Use the Filter Arrow Lists
442
Exercise
13-10:
Filter Dates
443
Exercise
13-11:
Show Totals in a Table
445
Using COUNTIFS and SUMIFS
445
Exercise
13-12:
Create a
3-D
Formula
with COUNTIFS
445
Exercise
13-13:
Use SUMIFS
447
Exercise
13-14:
Use the TEXT Function
449
Setting Print Areas
450
Exercise
13-15:
Set and Clear a Print Area
450
Exercise
13-16:
Print Noncontiguous
Selections
451
Creating Custom Views
452
Exercise
13-17:
Convert a Table to
a Range
452
Exercise
13-18:
Create Custom Views
453
Exercise
13-19:
Display Views
454
Lesson
13
Summary
454
Concepts Review
456
True/False Questions
456
Short Answer Questions
456
Critical Thinking
457
Skills Review
457
Exercise
13-20
457
Exercise
13-21
458
Exercise
13-22
459
Exercise
13-23
460
Lesson Applications
461
Exercise
13-24
461
Exercise
13-25
461
Exercise
13-26
462
Exercise
13-27
462
On Your Own
463
Exercise
13-28
463
Exercise
13-29
463
Exercise
13-30
463
LESSON
14:
USING NAMED RANGES
AND STRUCTURED REFERENCES
464
Using Named Ranges
464
Exercise
14-1:
Use Ranges for
Navigation
465
Exercise
14-2:
Name a Defined Range
466
Exercise
14-3:
Use Named Ranges in
a Formula
467
Exercise
14-4:
Insert Data within a
Named Range
468
Exercise
14-5:
Create Range Names
Automatically
469
Exercise
14-6:
Delete Range Names
470
Exercise
14-7:
Suppress Errors for
Printing
470
Exercise
14-8:
Setting the Scope for a
Named Range
471
Exercise
14-9:
Modifv Defined Names
472
Naming a Constant
473
Exercise
14-10:
Name a Constant
473
Exercise
14-11:
Use a Constant in
a Formula
473
Documenting Range Names
474
Exercise
14-12:
Create a Range
Name List
474
Working with Structured References
475
Exercise
14-13:
Review Structured
References
475
Exercise
14-14:
Use Structured References
in Formulas
476
Using Lookup Functions
477
Exercise
14-15:
Use VLOOKUP
477
Exercise
14-16:
Transpose Data While
Copying
479
Exercise
14-17:
Use HLOOKUP
480
Exercise
14-18:
Edit an HLOOKUP
Function
480
Exercise
14-19:
Create and Remove a
Circular Reference
481
Lesson
14
Summary
482
Concepts Review
484
True/False Questions
484
Short Answer Questions
484
Contents
Critical Thinking
Skills Review
Exercise
14-20
Exercise
14-21
Exercise
14-22
Exercise
14-23
Lesson Applications
Exercise
14-24
Exercise
14-25
Exercise
14-26
Exercise
14-27
485
485
485
486
487
488
490
490
491
491
492
On Your Own
Exercise
14-28
Exercise
14-29
Exercise
14-30
UNIT
4
APPLICATIONS
Unit Application
4-1
Unit Application
4-2
Unit Application
4-3
Unit Application
4-4
493
493
493
493
494
494
495
495
496
Unit
5
Auditing, Analyzing, and Consolidating Data
LESSON
15:
USING AUDITING TOOLS
498
Evaluating a Formula
498
Exercise
15-1:
Evaluate a Formula
499
Setting a Data Validation List
501
Exercise
15-2:
Create a Data Validation List
501
Exercise
15-3:
Set an Error Message for
Data Validation
502
Exercise
15-4:
Use and Copy Data
Validation Settings
503
Exercise
15-5:
Circle Invalid Data
504
Tracing Precedents, Dependents,
and Error Messages
504
Exercise
15-6:
Trace Precedents
504
Exercise
15-7:
Trace Dependents and
Error Messages
505
Finding and Correcting Errors
506
Exercise
15-8:
Use Go to Special
507
Exercise
15-9:
Use Multiple Windows
508
Troubleshooting Errors
509
Exercise
15-10:
Look for Errors
510
Exercise
15-11:
Correct Errors
511
Using the Watch Window
511
Exercise
15-12:
Use the Watch Window
512
Exercise
15-13:
Delete a Watch
513
Exercise
15-14:
Correct Division by Zero
513
Exercise
15-15:
Mark a Workbook as Final
514
Using IFERROR
514
Exercise
15-16:
Use IFERROR
514
Lesson
15
Summary
516
Concepts Review
517
True/False Questions
517
Short Answer Questions
517
Critical Thinking
518
Skills Review
518
Exercise
15-17 518
Exercise
15-18 520
Exercise
15-19 521
Exercise
15-20 522
Lesson Applications
523
Exercise
15-21 523
Exercise
15-22 523
Exercise
15-23 524
Exercise
15-24 525
On Your Own
525
Exercise
15-25 525
Exercise
15-26 525
Exercise
15-27 525
LESSON
16:
USING
W
H
AT-1F ANALYSIS
526
Creating a Scenario
526
Exercise
16-1:
Enable and Run a Macro
527
Exercise
16-2:
Create a Scenario
528
Exercise
16-3:
Add Scenarios to the
Worksheet
529
Setting Highlight Cells Rules
531
Exercise
16-4:
Set a Highlight Cells Rule
531
Exercise
16-5:
Create a New Formatting Rule
532
Exercise
16-6:
Set Two Highlight Cells Rules
533
Managing Scenarios
533
Exercise
16-7:
Show Scenarios
533
Exercise
16-8:
Edit a Scenario
534
Exercise
16-9:
Print a Scenario
Summary Report
534
Exercise
16-10:
Save a Macro-Free Workbook
536
Forecasting with
a
Trendline 536
Exercise
16-11:
Create and Format a Chart
536
Exercise
16-12:
Add
a
Trendline
to a Chart
537
Exercise
16-13:
Format a Trendline
538
Using Goal Seek
539
Exercise
16-14:
Use Goal Seek to
Determine a Price
539
Exercise
16-15:
Use Goal Seek to
Determine Units Sold
541
Using Solver
541
Exercise
16-16:
Use Solver to Determine
Units Sold
541
Exercise
16-17:
Add Solver Constraints
543
Exercise
16-18:
Edit a Scenario Report
544
Exercise
16-19:
Save a Document with a
Thumbnail Preview
544
Lesson
16
Summary
546
Concepts Review
547
True/False Questions
547
Contents
xi
Short
Answer Questions
547
Critical Thinking
548
Skills Review
548
Exercise
16-20 548
Exercise
16-21 550
Exercise
16-22 551
Exercise
16-23 552
Lesson Applications
554
Exercise
16-24 554
Exercise
16-25 554
Exercise
16-26 555
Exercise
16-27 555
On Your Own
556
Exercise
16-28 556
Exercise
16-29 557
Exercise
16-30 557
LESSON
17:
CONSOLIDATING AND
LINKING WORKBOOKS
558
Creating a Static Data Consolidation
558
Exercise
17-1:
Prepare a Worksheet for
Consolidation
559
Exercise
17-2:
Create a Static Consolidation
559
Exercise
17-3:
Edit Underlying Data
560
Creating a Dynamic Data
Consolidation
561
Exercise
17-4:
Create a Dynamic
Consolidation
561
Exercise
17-5:
Display Formulas in
an Outline
562
Consolidating Data by Category
563
Exercise
17-6:
Set Up Data to Be Consolidated
564
Exercise
17-7:
Use AVERAGE to Consolidate
by Category
564
Exercise
17-8:
Consolidate Data by
Using MAX
565
Linking Workbooks
566
Exercise
17-9:
Link Workbooks by Pointing
566
Examining and Editing Links
568
Exercise
17-10:
Examine Links
568
Exercise
17-11:
Move a Source Workbook
570
Exercise
17-12:
Edit Links
570
Exercise
17-13:
Break Links
571
Exercise
17-14:
Restrict Permission to a
Workbook
571
Lesson
17
Summary
573
Concepts Review
575
True/False Questions
575
Short Answer Questions
575
Critical Thinking
576
Skills Review
576
Exercise
17-15 576
Exercise
17-16 577
Exercise
17-17 578
Exercise
17-18 579
Lesson Applications
580
Exercise
17-19 580
Exercise
17-20 580
Exercise
17-21 581
Exercise
17-22 581
On Your Own
582
Exercise
17-23 582
Exercise
17-24 582
Exercise
17-25 582
UNIT
5
APPLICATIONS
583
Unit Application
5-1 583
Unit Application
5-2 583
Unit Application
5-3 584
Unit Application
5-4 585
Unit
6
Exploring Data and Table Features
LESSON
18:
USING EXTERNAL
DATA SOURCES
Using Text Sources
Exercise
18-1:
Copy and Paste
from Word
Exercise
18-2:
Review Data and
Smart Tags
Exercise
18-3:
Create a Custom Format
Exercise
18-4:
Drag and Drop a Word
Document
Exercise
18-5:
Use Copy and Paste Special
Exercise
18-6:
Get a Text File
Managing Imported Data
Exercise
18-7:
Set Import Options
Exercise
18-8:
Create Theme Fonts
and Colors
Exercise
18-9:
Save a Document Theme
Exercise
18-10:
Remove Duplicate Data
588
588
589
590
591
592
592
593
594
594
595
596
597
Exercise
18-11:
Convert Text to Columns
597
Exercise
18-12:
Use PROPER and
SUBSTITUTE
598
Using Web Sources
599
Exercise
18-13:
Copy from the Web
by Dragging
600
Exercise
18-14:
Create a Web Query
601
Exercise
18-15:
Manage Connections
602
Using Database Sources
603
Exercise
18-16:
Import an Access Table
604
Exercise
18-17:
Use Microsoft Query
604
Exporting Excel Data
606
Exercise
18-18:
Copy Data to Word
607
Exercise
18-19:
Save a Workbook as a Text File
607
Exercise
18-20:
Delete a Document Theme
608
Lesson
18
Summary
Concepts Review
608
610
xii
Contents
True/False Questions
610
Short Answer Questions
610
Critical Thinking
611
Skills Review
611
Exercise
18-21 611
Exercise
18-22 612
Exercise
18-23 613
Exercise
18-24 614
Lesson Applications
615
Exercise
18-25 615
Exercise
18-26 615
Exercise
18-27 616
Exercise
18-28 616
On Your Own
617
Exercise
18-29 617
Exercise
18-30 617
Exercise
18-31 617
LESSON
19:
EXPLORING LIST RANGES
618
Sorting and Filtering a List Range
618
Exercise
19-1:
Name and Format a
List Range
619
Exercise
19-2:
Sort by Conditional
Formatting
619
Exercise
19-3:
Filter by Cell Attributes
621
Exercise
19-4:
Create Custom Filters
621
Creating Advanced Filters
623
Exercise
19-5:
Set the Criteria Range
623
Exercise
19-6:
Filter Data in Place
623
Exercise
19-7:
Create an Output Range
625
Exercise
19-8:
Filter Data to an
Output Range
625
Using Subtotals
626
Exercise
19-9:
Use Subtotal
626
Exercise
19-10:
Subtotal with AVERAGE
628
Using Database Functions
628
Exercise
19-11 :
Use DMIN
629
Exercise
19-12:
Use DCOUNT
630
Creating and Editing Outlines
630
Exercise
19-13 :
Use the SUBTOTAL function
631
Exercise
19-14:
Add Grand Totals
632
Exercise
19-15:
Create an Auto Outline
633
Exercise
19-16:
Create a Row Outline
Manually
634
Exercise
19-17:
Expand and Hide Details
635
Lesson
19
Summary
635
Concepts Review
637
True/False Questions
637
Short Answer Questions
637
Critical Thinking
638
Skills Review
638
Exercise
19-18 638
Exercise
19-19 639
Exercise
19-20 639
Exercise
19-21 640
Lesson Applications
642
Exercise
19-22 642
Exercise
19-23 642
Exercise
19-24 643
Exercise
19-25 644
On Your Own 645
Exercise
19-26 645
Exercise
19-27 645
Exercise
19-28 645
LESSON
20:
USING DATA TABLES
AND PIVOTTABLES
646
Building a One-Variable Data Table
646
Exercise
20-1:
Prepare Formulas and
Input Values
647
Exercise
20-2:
Create a Data Table
648
Exercise
20-3:
Format the Data Table
650
Exercise
20-4:
Insert an En Dash and
a Pointer
650
Exercise
20-5:
Delete, Edit, and Copy a
Data Table
652
Building a Two-Variable Data Table
652
Exercise
20-6:
Set Up Input Values
and the Formula
653
Exercise
20-7:
Create and Format the
Data Table
653
Analyzing Data in a PivotTable
654
Exercise
20-8:
View Data in a PivotTable
655
Exercise
20-9:
Pivot Fields in the PivotTable
Field List Pane
656
Creating a PivotTable
658
Exercise
20-10:
Create a PivotTable
658
Exercise
20-11:
Use PivotTable Tools
Options
659
Exercise
20-12:
Edit Field Settings
659
Using Multiple Calculations
661
Exercise
20-13:
Use Multiple Fields and
Functions
662
Exercise
20-14:
Add a Calculated Field
663
Exercise
20-15:
Set How Values are Shown
664
Exercise
20-16:
Refresh Data
665
Creating a PivotChart
665
Exercise
20-17:
Create a PivotChart for
an Existing PivotTable
665
Exercise
20-18:
Create a PivotChart from
the List
668
Lesson
20
Summary
669
Concepts Review
670
True/False Questions
670
Short Answer Questions
670
Critical Thinking
671
Skills Review
671
Exercise
20-19 671
Exercise
20-20 672
Exercise
20-21 673
Exercise
20-22 675
Lesson Applications
676
Exercise
20-23 676
Exercise
20-24 676
Contents
xiii
Exercise
20-25
Exercise
20-26
On
Your Own
Exercise
20-27
Exercise
20-28
Exercise
20-29
677
677
678
678
678
678
UNIT
6
APPLICATIONS
Unit Application
6-1
Unit Application
6-2
Unit Application
6-3
Unit Application
6-4
679
679
679
680
680
Unit
7
Exploring
Macros,
Templates, and
Workgroups
LESSON
21:
WORKING WITH
MACROS
682
Running and Viewing a Macro
682
Exercise
21 -1 :
Run a Macro
683
Exercise
21-2:
Open the Visual Basic Editor
684
Editing and Printing a Macro
685
Exercise
21-3:
Edit a Macro
685
Exercise
21-4:
Use a Macro Keyboard Shortcut
686
Exercise
21-5:
Add a Comment and Print a
Macro
687
Recording a Macro
688
Exercise
21-6:
Record a Macro with
Absolute References
688
Exercise
21-7:
Delete a Macro
690
Exercise
21-8:
Use Relative References in
a Macro
690
Exercise
21-9:
Review Macro Code
691
Assigning a Macro to a Button
692
Exercise
21-10:
Display the Developer Tab
692
Exercise
21 -11 :
Draw a Button
692
Exercise
21 -12 :
Delete a Button
693
Creating a Macro Workbook
694
Exercise
21 -13 :
Record Macros
694
Exercise
21-14:
Save, Hide, and Use a
Macro Workbook
695
Lesson
21
Summary
696
Concepts Review
697
True/False Questions
697
Short Answer Questions
697
Critical Thinking
698
Skills Review
698
Exercise
21-15 698
Exercise
21-16 699
Exercise
21-17 700
Exercise
21-18 701
Lesson Applications
703
Exercise
21-19 703
Exercise
21-20 703
Exercise
21-21 704
Exercise
21-22 704
On Your Own
705
Exercise
21-23 705
Exercise
21-24 705
Exercise
21-25 705
LESSON
22:
USING TEMPLATES
706
Using an Installed Template
706
Exercise
22-1:
Create a Workbook Based
on an Installed Template
707
Exercise
22-2:
Edit and Save a Workbook
Based on a Template
707
Adding Worksheet Protection
708
Exercise
22-3:
Edit an Installed Template
708
Exercise
22-4:
Change the Locked Property
710
Exercise
22-5:
Protect the Worksheet
711
Exercise
22-6:
Update Properties
711
Exercise
22-7:
Save a Template
713
Exercise
22-8:
Use View Side by Side
714
Exercise
22-9:
Delete a Template
715
Using an Online Template
715
Exercise
22-10:
Download an Online Template
715
Exercise
22-11:
Edit and Save a Template
716
Exercise
22-12:
Use and Delete a Template
718
Creating a User Template
718
Exercise
22-13:
Build a Template
719
Exercise
22-14:
Add a Formula and Hide Zeros
719
Exercise
22-15:
Add Data Validation
Exercise
22-16:
Use a Validation Input
Message
Exercise
22-17:
Add Conditional Formatting
and a Comment
Exercise
22-18:
Protect the Sheet with
a Password
Exercise
22-19:
Create a Templates Folder
Exercise
22-20:
Create a Workbook from
a Template
Exercise
22-21 :
Remove Protection and the
Password
720
721
722
722
723
724
725
Using Workbook Protection
725
Exercise
22-22:
Create a Workbook Template
725
Exercise
22-23:
Add Sheet and Workbook
Protection
726
Exercise
22-24:
Delete a Folder and Files
727
Lesson
22
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
22-25
Exercise
22-26
Exercise
22-27
Exercise
22-28
Lesson Applications
Exercise
22-29
Exercise
22-30
Exercise
22-31
Exercise
22-32
729
730
730
730
731
731
731
732
734
735
737
737
737
738
738
XIV
Contents
On Your Own
739
Exercise
22-33
739
Exercise
22-34
739
Exercise
22-35
739
LESSON
23:
USING WORKGROUP
FEATURES
740
Creating a Shared Workbook
740
Exercise
23-1:
Create a Shared Workbook
741
Tracking Changes
742
Exercise
23-2:
Set Change History Options
743
Exercise
23-3:
Activate Change Highlighting
744
Exercise
23-4:
Track and Highlight Changes
744
Exercise
23-5:
Add Comments in a Shared
Workbook
745
Printing a Change History Sheet
746
Exercise
23-6:
Display and Print a History
Worksheet
746
Comparing and Merging Workbooks
747
Exercise
23-7:
Display the Compare and
Merge Button
747
Exercise
23-8:
Compare and Merge Workbooks
748
Accepting or Rejecting Changes
749
Exercise
23-9:
Accept or Reject Changes
749
Exercise
23-10:
Reset the User Name and
Quick Access Toolbar
750
Lesson
23
Summary
751
Concepts Review
752
True/False Questions
752
Short Answer Questions
Critical Thinking
Skills Review
Exercise
23-11
Exercise
23-12
Exercise
23-13
Exercise
23-14
Lesson Applications
Exercise
23-15
Exercise
23-16
Exercise
23-17
Exercise
23-18
On Your Own
Exercise
23-19
Exercise
23-20
Exercise
23-21
UNIT
7
APPLICATIONS
Unit Application
7-1
Unit Application
7-2
Unit Application
7-3
Unit Application
7-4
APPENDIX
GLOSSARY
INDEX
752
753
753
753
754
755
756
758
758
758
759
759
760
760
760
760
761
761
762
762
763
A-1
G-1
1-1 |
| adam_txt |
conLen
Preface
Installation Requirements
Windows Tutorial
Case Study
XVI
xviii
XX
xlii
EXCEL
J
Unit
1
Introduction to Excel
LESSON
1:
GETTING STARTED
WITH EXCEL
Starting Excel
Exercise
1-1:
Work with the Excel Interface
Navigating in a Workbook
Exercise
1-2:
Move Between Worksheets
Exercise
1-3:
Go to a Specific Cell
Exercise
1-4:
Scroll Through a Worksheet
Exercise
1-5:
Change the Zoom Size
Exercise
1-6:
Close a Workbook
Opening an Existing Workbook
Exercise
1-7:
Open a Workbook
Editing a Worksheet
Exercise
1-8:
View Worksheets and
Cell Contents
Exercise
1-9:
Replace Cell Contents
Exercise
1-10:
Edit Cell Contents
Exercise
1-11:
Clear Cell Contents
Exercise
1-12:
Use Undo and Redo
Managing Files
Exercise
1-13:
Create a New Folder and
Use Save As
Printing Excel Files
Exercise
1-14:
Preview and
Print a Worksheet
Exercise
1-15:
Print a Workbook
Exercise
1-16:
Save an XPS File
Exercise
1-17:
Exit Excel
Lesson
1
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
1-18
Exercise
1-19
Exercise
1-20
Exercise
1-21
Lesson Applications
Exercise
1-22
Exercise
1-23
Exercise
1-24
Exercise
1-25
2
4
6
7
7
9
11
12
12
12
13
14
15
16
18
18
20
20
21
22
23
24
25
26
28
28
28
29
29
29
30
30
31
32
32
32
33
33
On Your Own
34
Exercise
1-26 34
Exercise
1-27 34
Exercise
1-28 34
LESSON
2:
CREATING A WORKBOOK
36
Entering Labels
36
Exercise
2-1:
Enter Labels in a Worksheet
37
Changing the Document Theme
38
Exercise
2-2:
Change the Theme
39
Exercise
2-3:
Change the Font, Font Size,
and Style
41
Exercise
2-4:
Use the Format Painter
42
Selecting Cell Ranges
43
Exercise
2-5:
Select Ranges with the Mouse
43
Exercise
2-6:
Select Ranges with Keyboard
Shortcuts
45
Modifying Column Width and Row Height
47
Exercise
2-7:
Modify Column Width
47
Exercise
2-8:
Modify Row Height
48
Entering Values and Dates
49
Exercise
2-9:
Enter Dates and Values
49
Exercise
2-Ю:
Apply Number Formats
from the Ribbon
50
Exercise
2-11:
Apply Date Formats from the
Dialog Box
51
Exercise
2-12:
Change the Font Color
52
Exercise
2-13:
Rename a Worksheet
and Change the Tab Color
53
Saving a Workbook
54
Exercise
2-14:
Save a Workbook
55
Entering Basic Formulas
55
Exercise
2-15:
Key a Basic Formula
56
Exercise
2-16:
Enter a Formula by Pointing
58
Exercise
2-17:
Copy a Formula by Using
the Copy and Paste Buttons
58
Exercise
2-18:
Use AutoSum, Average,
and Max
59
Exercise
2-19:
Check Results with
AutoCalculate
61
Lesson
2
Summary
63
Concepts Review
65
True/False Questions
65
Short Answer Questions
65
IV
Contents
Critical Thinking
66
Skills Review
66
Exercise
2-20 66
Exercise
2-21 67
Exercise
2-22 68
Exercise
2-23 69
Lesson Applications
71
Exercise
2-24 71
Exercise
2-25 72
Exercise
2-26 72
Exercise
2-27 73
On Your Own
73
Exercise
2-28 73
Exercise
2-29 74
Exercise
2-30 74
LESSON
3:
USING EDITING
AND STYLE TOOLS
76
Using AutoCorrect and
Error Checking
76
Exercise
3-1:
Use AutoCorrect to
Correct Errors
77
Exercise
3-2:
Set AutoCorrect Options
78
Exercise
3-3:
Review Error Checking
79
Checking Spelling
80
Exercise
3-4:
Spell-Check a Worksheet
80
Using Find and Replace
82
Exercise
3-5:
Find Data
83
Exercise
3-6:
Use Wildcards
85
Exercise
3-7:
Replace Data
85
Exercise
3-8:
Replace a Function in
a Formula
86
Exercise
3-9:
Correct Errors with
Replace
86
Exercise
3-10:
Find and Replace Formats
87
Exercise
3-11 :
Reset Find and Replace
Formats
89
Using Series and AutoFill
89
Exercise
3-12:
Create Month and Week Series
89
Exercise
3-13:
Create a Number Series
90
Exercise
3-14:
Copy Data with the Fill Handle
91
Exercise
3-15:
Copy a Formula with the
Fill Handle
91
Applying Table and Cell Styles
92
Exercise
3-16:
Create a Table
92
Exercise
3-17:
Change the Table Style
93
Exercise
3-18:
Apply a Cell Style
94
Exercise
3-19:
Print a Selection
95
Preparing Headers and Footers
95
Exercise
3-20:
Set Headers and Footers
96
Exercise
3-21:
Print Gridlines and Row
and Column Headings
97
Exercise
3-22:
Change Margins and
Column Widths in Page Layout View
98
Lesson
3
Summary
99
Concepts Review
101
True/False Questions
101
Short Answer Questions
101
Critical Thinking
Ю2
Skills Review
102
Exercise
3-23 102
Exercise
3-24 103
Exercise
3-25 104
Exercise
3-26 105
Lesson Applications
107
Exercise
3-27 107
Exercise
3-28 107
Exercise
3-29 108
Exercise
3-30 109
On Your Own
110
Exercise
3-31 110
Exercise
3-32 110
Exercise
3-33 111
LESSON
4:
EXPLORING HOME TAB
COMMANDS
112
Inserting and Deleting Sheets and Cells
112
Exercise
4-1:
Insert Worksheets
113
Exercise
4-2:
Move and Delete Worksheets
114
Exercise
4-3:
Insert Cells
115
Exercise
4-4:
Delete Cells
116
Using AutoComplete and Pick From
Drop-Down List
116
Exercise
4-5:
Use AutoComplete
117
Exercise
4-6:
Use Pick From Drop-Down List
118
Copying, Cutting, and Pasting Cell Contents
119
Exercise
4-7:
Cut and Paste Cell Contents
119
Exercise
4-8:
Copy and Paste Cell Contents
120
Exercise
4-9:
Use Drag and Drop
122
Exercise
4-10:
Use the Office Clipboard
123
Working with Columns and Rows
124
Exercise
4-11:
Insert Rows
125
Exercise
4-12:
Delete Rows
127
Exercise
4-13:
Insert and Delete Rows
127
Exercise
4-14:
Hide and Unhide Columns
and Rows
127
Exercise
4-15:
Freeze and Split the Window
128
Working with Cell Alignment
130
Exercise
4-16:
Change the Horizontal
Alignment
131
Exercise
4-17:
Use Center Across Selection
131
Exercise
4-18:
Change the Vertical Alignment
133
Exercise
4-19:
Wrap Text and Change Indents
133
Exercise
4-20:
Use Merge and Center
134
Exercise
4-21:
Change Cell Orientation
134
Applying Borders and Fill
135
Exercise
4-22:
Apply Borders Using the
Borders Button
135
Exercise
4-23:
Apply Borders Using the
Dialog Box
137
Exercise
4-24:
Add Solid Fill
139
Exercise
4-25:
Use Pattern Fill
139
Exercise
4-26:
Complete the Number
Formatting
140
Using Data Bars
142
Exercise
4-27:
Use Data Bars
142
Exercise
4-28:
Edit the Data Bar Rule
143
Contents
Lesson
4
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
4-29
Exercise
4-30
Exercise
4-31
Exercise
4-32
Lesson Applications
Exercise
4-33
Exercise
4-34
145
147
147
147
148
148
148
149
150
151
153
153
154
Exercise
4-35
Exercise
4-36
On Your Own
Exercise
4-37
Exercise
4-38
Exercise
4-39
UNIT
1
APPLICATIONS
Unit Application
1 -1
Unit Application
1-2
Unit Application
1-3
Unit Application
1-4
154
155
156
136
156
156
157
157
157
159
159
Unit
2
Working with Formulas and Functions
LESSON
5:
EXPLORING
FORMULA BASICS
162
Using a Template to Create a Workbook
162
Exercise
5-1:
Create a Workbook from
a Template
163
Building Addition and Subtraction Formulas
164
Exercise
5-2:
Create and Copy Addition
Formulas
164
Exercise
5-3:
Create and Copy
Subtraction Formulas
166
Building Multiplication and
Division Formulas
167
Exercise
5-4:
Create Multiplication Formulas
167
Exercise
5-5:
Edit a Formula in the
Formula Bar
168
Exercise
5-6:
Create Division Formulas
169
Exercise
5-7:
Apply the Percent Style and
Increase Decimal Positions
169
Using Order of Precedence in a Formula
170
Exercise
5-8:
Use Multiplication and
Addition in a Formula
171
Exercise
5-9:
Set Order of Precedence
172
Using Relative, Absolute, and
Mixed References
173
Exercise
5-10:
Use a Line Break
173
Exercise
5-11 :
Copy a Formula with a
Relative Reference
174
Exercise
5-12:
Create a Formula with
an Absolute Reference
175
Exercise
5-13:
Use a Color Scale
175
Exercise
5-14:
Use Mixed References
177
Exercise
5-15:
Add Borders and Fill
for Printing
178
Working with the Page Layout Tab
179
Exercise
5-16:
Change Page Orientation
179
Exercise
5-17:
Change Scaling and Page
Margins
179
Exercise
5-18:
Copy a Worksheet and
Display Formulas
181
Exercise
5-19:
Add a Background
182
Exercise
5-20:
Save a W'orkbook as a
Web Page
183
Lesson
5
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
5-21
Exercise
5-22
Exercise
5-23
Exercise
5-24
Lesson Applications
Exercise
5-25
Exercise
5-26
Exercise
5-27
Exercise
5-28
On Your Own
Exercise
5-29
Exercise
5-30
Exercise
5-31
185
187
187
187
188
188
188
189
190
191
194
194
194
195
196
196
196
197
197
LESSON
6:
WORKING WITH FUNCTIONS
198
Using Math and Trig Functions
198
Exercise
6-1:
Use SUM and the Formula Bar
199
Exercise
6-2:
Use Insert Function
201
Exercise
6-3:
Use TRUNC
203
Exercise
6-4:
Use SUMIF
204
Using Statistical Functions
205
Exercise
6-5:
Use the AVERAGE Function
205
Exercise
6-6:
Use AVERAGEIF
206
Exercise
6-7:
Use the
MIN
and
MAX Functions
206
Exercise
6-8:
Use COUNT and
COUNTBLANK
208
Exercise
6-9:
Use the
COUNTA
Function
209
Using Icon Sets
210
Exercise
6-10:
Apply Icon Sets
210
Exercise
6-11:
Edit the Icon Formatting Rule
211
Grouping Worksheets
212
Exercise
6-12:
Group and
Delete Worksheets
212
Exercise
6-13:
Manase
Worksheets
21 ?
vi
Contents
Using Date and lime Functions
Exercise
6-14:
Use the TODAY() Function
Exercise
6-15:
Key and Format Dates
Exercise
6-16:
Use Fill Across Worksheets
Exercise
6-17:
Create a Custom Date Format
Exercise
6-18:
Key and Format Times
Exercise
6-19:
Use the NOW() Function
Exercise
6-20:
Create a Custom
Time Format
Exercise
6-21:
Add a Header to
Grouped Sheets
Lesson
6
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
6-22
Exercise
6-23
Exercise
6-24
Exercise
6-25
Lesson Applications
Exercise
6-26
Exercise
6-27
Exercise
6-28
Exercise
6-29
On Your Own
Exercise
6-30
Exercise
6-31
Exercise
6-32
LESSON
7:
USING LOGICAL AND
FINANCIAL FUNCTIONS
Using the IF Function
Exercise
7-1:
Use IF to Show Text
Exercise
7-2:
Use IF to Calculate a Value
Using AND, OR, and NOT Functions
Exercise
7-3:
Use the AND Function
Exercise
7-4:
Use the OR Function
Exercise
7-5:
Use the NOT Function
Working with Cell Styles
Exercise
7-6:
Use Cell Styles
Exercise
7-7:
Clear and Reapply Cell Styles
Exercise
7-8:
Create a Style
Exercise
7-9:
Edit a Style
Working with Page Breaks
Exercise
7-10:
Preview and Change
Page Breaks
Exercise
7-11:
Remove and Insert
Page Breaks
Exercise
7-12:
Set Print Titles
Exercise
7-13:
Center a Page
Exercise
7-14:
Change the Footer Font
and Print Page Numbers
Exercise
7-15:
Remove a Page Break
Using the PMT and FV Functions
Exercise
7-16:
Use the PMT Function
Exercise
7-17:
Kev a PMT Function
214
214
215
216
217
218
219
219
220
222
223
223
223
224
224
224
225
226
227
229
229
230
230
231
232
232
232
233
234
234
235
237
238
238
240
241
242
242
243
243
244
244
245
Exercise
7-18:
Use the FV Function
254
Exercise
7-19:
Format Negative Numbers
255
Using Depreciation Functions
255
Exercise
7-20:
Use the
DB
Function
256
Exercise
7-21 :
Copy and Edit the
DB
Function
258
Lesson
7
Summary
259
Concepts Review
261
True/False Questions
261
Short Answer Questions
261
Critical Thinking
262
Skills Review
262
Exercise
7-22 262
Exercise
7-23 263
Exercise
7-24 264
Exercise
7-25 266
Lesson Applications
268
Exercise
7-26 268
Exercise
7-27 268
Exercise
7-28 269
Exercise
7-29 269
On Your Own
Exercise
7-30
Exercise
7-31
Exercise
7-32
LESSON
8:
ROUNDING AND NESTING
FUNCTIONS
Using the INT Function
Exercise
8-1 :
Use INT with a Cell Reference
Exercise
8-2:
Compare Values with INT
Using the ROUND Function
Exercise
8-3:
Use ROUND
Exercise
8-4:
Compare Rounded Values
Exercise
8-5:
Change Colors and Borders
Using Date and
Ήπιε
Arithmetic
Exercise
8-6:
Determine Ages and Dates
Exercise
8-7:
Determine Time Passed
Exercise
8-8:
Group Sheets to Add Footers
Exercise
8-9:
Hide and Unhide a Worksheet
Creating Nested Functions
Exercise
8-10:
Nest SUM and ROUND
Exercise
8-11 :
Create a Nested IF Function
Exercise
8-12:
Set Top/Bottom Conditional
Formatting
Creating a Hyperlink
Exercise
8-13:
Create a Hyperlink
Exercise
8-14:
Run the Compatibility
Checker
246
Lesson
8
Summary
248
Concepts Review
249
True/False Questions
249
Short Answer Questions
250
Critical Thinking
251
Skills Review
251
Exercise
8-15
252
Exercise
8-16
270
270
270
271
272
272
273
273
274
274
275
276
277
277
278
279
280
280
280
282
283
284
284
286
287
289
289
289
290
290
290
291
Contents
VII
Exercise
8-17
Exercise
8-18
Lesson
Applications
Exercise
8-19
Exercise
8-20
Exercise
8-21
Exercise
8-22
On
Your Own
Exercise
8-23
Exercise
8-24
Exercise
8-25
292
293
294
294
294
295
296
297
297
297
297
UNIT
2
APPLICATIONS
Unit Application
2-1
Unit Application
2-2
Unit Application
2-3
Unit Application
2-4
298
298
298
299
300
Unit
3
Enhancing Worksheet Appearance
LESSON
9:
BUILDING CHARTS
Viewing and Printing a Chart
Exercise
9-1:
View a Chart Object
Exercise
9-2:
Print a Chart Object
Working with Chart Elements
Exercise
9-3:
Change the Chart Layout
Exercise
9-4:
Change the Chart Style
Exercise
9-5:
Edit and Format the
Chart Title
Exercise
9-6:
Set Shape Fill and Effects
Exercise
9-7:
Set and Format Data Labels
Exercise
9-8:
Format the Axes
302
303
303
304
304
306
307
307
309
311
311
Exercise
9-9:
Format the Plot and Chart Areas
312
Creating Charts
313
Exercise
9-10:
Create and Edit a Chart Sheet
314
Exercise
9-11:
Create a Chart Object
315
Exercise
9-12:
Move and Size a Chart Object
315
Exercise
9-13:
Change the Layout and Styles
316
Exercise
9-14:
Create a Bar Chart Sheet
317
Exercise
9-15:
Add Gridlines and a
Data Table
318
Editing Chart Data
319
Exercise
9-16:
Edit Chart Data
319
Exercise
9-17:
Add a Data Point
319
Exercise
9-18:
Add and Rename Data Series
321
Exercise
9-19:
Delete Data Points and a
Data Series
323
Using Images, Gradients, and Textures
for a Data Series
323
Exercise
9-20:
Use an Image for a Data Series
323
Exercise
9-21 :
Use a Gradient for a
Data Series
325
Exercise
9-22:
Use a Texture for a Data Point
326
Creating a Combination Chart
327
Exercise
9-23:
Create a Chart with Two
Chart Types
327
Exercise
9-24:
Build a Chart with Two Series
328
Exercise
9-25:
Add a Secondary Axis
329
Lesson
9
Summary
330
Concepts Review
332
True/False Questions
332
Short Answer Questions
332
Critical Thinking
333
Skills Review
333
Exercise
9-26 333
Exercise
9-27 334
Exercise
9-28 335
Exercise
9-29 336
Lesson Applications
338
Exercise
9-30 338
Exercise
9-31 338
Exercise
9-32 339
Exercise
9-33 340
On Your Own
340
Exercise
9-34 340
Exercise
9-35 341
Exercise
9-36 341
LESSON
10:
INSERTING SHAPES
342
Adding and Formatting a Callout
343
Exercise
10-1 :
Add a Callout to a Worksheet
343
Exercise
10-2:
Format and Move a Callout
345
Exercise
10-3:
Use the Format Shape Dialog
Box
346
Using Text Boxes
348
Exercise
10-4:
Add a Text Box
348
Exercise
10-5:
Format and Move a Text Box
348
Exercise
10-6:
Choose a Shape Style
349
Inserting Basic Shapes and Arrows
350
Exercise
10-7:
Add a Shape and an Arrow
350
Exercise
10-8:
Resize the Name Box
351
Exercise
10-9:
Use the Selection and
Visibility Pane
352
Using the Drawing Tools Format Tab
353
Exercise
10-10:
Format Multiple Shapes
353
Exercise
10-11:
Copy and Move Objects
353
Exercise
10-12:
Size Shapes
354
Exercise
10-13:
Align and Nudge Shapes
356
Exercise
10-14:
Change a Shape
356
Exercise
10-15:
Use the Adjustment Handle
357
Exercise
10-16:
Rotate Shapes
358
Exercise
10-17:
Style Multiple Shapes
359
Using Comments
359
Exercise
10-18:
Edit a Comment
360
Exercise
10-19:
Insert a Comment
361
viii
Contents
Exercise
10-20:
Pri;
Comments
361
Exercise
10-21:
Use Document Inspector
361
Inserting WordArt
363
Exercise
10-22:
Insert WordArt
363
Exercise
10-23:
Edit WordArt
364
Lesson
10
Summary
365
Concepts Review
367
True/False Questions
367
Short Answer Questions
367
Critical Thinking
368
Skills Review
368
Exercise
10-24 368
Exercise
10-25 369
Exercise
10-26 371
Exercise
10-27 372
Lesson Applications
373
Exercise
10-28 373
Exercise
10-29 373
Exercise
10-30 374
Exercise
10-31 374
On Your Own
375
Exercise
10-32 375
Exercise
10-33 375
Exercise
10-34 375
LESSON
11:
USING IMAGES AND
SMARTART GRAPHICS
376
Inserting a Picture
376
Exercise
11-1:
Insert a Picture from a File
377
Exercise
11-2:
Check Properties and Scale
the Picture
378
Exercise
11-3:
Format and Copy
an Image
379
Exercise
11-4:
Insert Clip Art
379
Exercise
11-5:
Crop, Size, and Style
an Image
380
Adding a Picture to a Header/Footer
381
Exercise
11-6:
Insert an Image in
a Footer
381
Exercise
11-7:
Size an Image in a Footer
382
Exercise
11-8:
Create a Watermark
383
Creating a Hierarchy SmartArt Shape
383
Exercise
11 -9:
Create and Style an
Organization Chart
383
Exercise
11-10:
Add a Shape to an
Organization chart
385
Exercise
11 -11 :
Add Text to the Shapes
3 86
Building a Cycle SmartArt Shape
387
Exercise
11-12:
Create a Cycle Diagram
387
Exercise
11-13:
Move Text in the Text Pane
388
Exercise
11-14:
Choose a New Layout
389
Using the Research Tool
389
Exercise
11-15:
Find Synonyms
390
Exercise
11-16:
Translate Words
392
Exercise
11-17:
Use a Special Symbol
393
Exercise
11-18:
Set Document Properties
394
Lesson
11
Summary
396
Concepts Review
397
True/False Questions
397
Short Answer Questions
397
Critical Thinking
398
Skills Review
398
Exercise
11-19 398
Exercise
11-20 399
Exercise
11-21 400
Exercise
11-22 401
Lesson Applications
403
Exercise
11-23 403
Exercise
11-24 403
Exercise
11-25 404
Exercise
11-26 405
On Your Own
405
Exercise
11-27 405
Exercise
11-28 406
Exercise
11-29 406
UNIT
3
APPLICATIONS
407
Unit Application
3-1 407
Unit Application
3-2 407
Unit Application
3-3 408
Unit Application
3-4 408
Unit
4
Expanding Uses of Workbook Data
LESSON
12:
USING
3-D
REFERENCES
410
Working with Multiple Sheets
410
Exercise
12-1:
Edit a Marked-as-Final
Workbook
410
Exercise
12-2:
Group Sheets for Editing
411
Creating a
3-D
Reference
412
Exercise
12-3:
Create a Single-Cell
3-D
Reference
412
Exercise
12-4:
Edit Referenced Data
413
Using a Formula in a
3-D
Reference
413
Exercise
12-5:
Use Addition in a
3-D
Reference
414
Exercise
12-6:
Use Multiplication in a
3-D
Reference
415
Exercise
12-7:
Copy and Scroll
Multiple Worksheets
416
Using a Function in a
3-D
Reference
417
Exercise
12-8:
Key Data in a Selected Range
418
Exercise
12-9:
Use AVERAGE in a
3-D
Reference
418
Exercise
12-10:
Use MAX in a
3-D
Reference
419
Creating a Digital Signature
421
Exercise
12-11:
Add a Digital Signature
421
Exercise
12-12:
Remove a Digital Signature
422
Contents
ix
Lesson
12
Summary
423
Concepts Review
424
True/False Questions
424
Short Answer Questions
424
Critical Thinking
425
Skills Review
425
Exercise
12-13 425
Exercise
12-14 426
Exercise
12-15 427
Exercise
12-16 428
Lesson Applications
430
Exercise
12-17 430
Exercise
12-18 430
Exercise
12-19 431
Exercise
12-20 431
On Your Own
432
Exercise
12-21 432
Exercise
12-22 433
Exercise
12-23 433
LESSON
13:
WORKING WITH TABLES
434
Preparing a List as a Table
434
Exercise
13-1:
Prepare a List
435
Exercise
13-2:
Create a Table
437
Working with the Table Tools Design
and Data Tabs
438
Exercise
13-3:
Restyle a
Table
438
Exercise
13-4:
Name a Table and Remove
Duplicates
438
Exercise
13-5:
Sort Records in a Table
440
Exercise
13-6:
Sort by Multiple
Columns
440
Adding and Filtering Records
441
Exercise
13-7:
Add a Record to a Table
441
Exercise
13-8:
Resize a Table
441
Exercise
13-9:
Use the Filter Arrow Lists
442
Exercise
13-10:
Filter Dates
443
Exercise
13-11:
Show Totals in a Table
445
Using COUNTIFS and SUMIFS
445
Exercise
13-12:
Create a
3-D
Formula
with COUNTIFS
445
Exercise
13-13:
Use SUMIFS
447
Exercise
13-14:
Use the TEXT Function
449
Setting Print Areas
450
Exercise
13-15:
Set and Clear a Print Area
450
Exercise
13-16:
Print Noncontiguous
Selections
451
Creating Custom Views
452
Exercise
13-17:
Convert a Table to
a Range
452
Exercise
13-18:
Create Custom Views
453
Exercise
13-19:
Display Views
454
Lesson
13
Summary
454
Concepts Review
456
True/False Questions
456
Short Answer Questions
456
Critical Thinking
457
Skills Review
457
Exercise
13-20
457
Exercise
13-21
458
Exercise
13-22
459
Exercise
13-23
460
Lesson Applications
461
Exercise
13-24
461
Exercise
13-25
461
Exercise
13-26
462
Exercise
13-27
462
On Your Own
463
Exercise
13-28
463
Exercise
13-29
463
Exercise
13-30
463
LESSON
14:
USING NAMED RANGES
AND STRUCTURED REFERENCES
464
Using Named Ranges
464
Exercise
14-1:
Use Ranges for
Navigation
465
Exercise
14-2:
Name a Defined Range
466
Exercise
14-3:
Use Named Ranges in
a Formula
467
Exercise
14-4:
Insert Data within a
Named Range
468
Exercise
14-5:
Create Range Names
Automatically
469
Exercise
14-6:
Delete Range Names
470
Exercise
14-7:
Suppress Errors for
Printing
470
Exercise
14-8:
Setting the Scope for a
Named Range
471
Exercise
14-9:
Modifv Defined Names
472
Naming a Constant
473
Exercise
14-10:
Name a Constant
473
Exercise
14-11:
Use a Constant in
a Formula
473
Documenting Range Names
474
Exercise
14-12:
Create a Range
Name List
474
Working with Structured References
475
Exercise
14-13:
Review Structured
References
475
Exercise
14-14:
Use Structured References
in Formulas
476
Using Lookup Functions
477
Exercise
14-15:
Use VLOOKUP
477
Exercise
14-16:
Transpose Data While
Copying
479
Exercise
14-17:
Use HLOOKUP
480
Exercise
14-18:
Edit an HLOOKUP
Function
480
Exercise
14-19:
Create and Remove a
Circular Reference
481
Lesson
14
Summary
482
Concepts Review
484
True/False Questions
484
Short Answer Questions
484
Contents
Critical Thinking
Skills Review
Exercise
14-20
Exercise
14-21
Exercise
14-22
Exercise
14-23
Lesson Applications
Exercise
14-24
Exercise
14-25
Exercise
14-26
Exercise
14-27
485
485
485
486
487
488
490
490
491
491
492
On Your Own
Exercise
14-28
Exercise
14-29
Exercise
14-30
UNIT
4
APPLICATIONS
Unit Application
4-1
Unit Application
4-2
Unit Application
4-3
Unit Application
4-4
493
493
493
493
494
494
495
495
496
Unit
5
Auditing, Analyzing, and Consolidating Data
LESSON
15:
USING AUDITING TOOLS
498
Evaluating a Formula
498
Exercise
15-1:
Evaluate a Formula
499
Setting a Data Validation List
501
Exercise
15-2:
Create a Data Validation List
501
Exercise
15-3:
Set an Error Message for
Data Validation
502
Exercise
15-4:
Use and Copy Data
Validation Settings
503
Exercise
15-5:
Circle Invalid Data
504
Tracing Precedents, Dependents,
and Error Messages
504
Exercise
15-6:
Trace Precedents
504
Exercise
15-7:
Trace Dependents and
Error Messages
505
Finding and Correcting Errors
506
Exercise
15-8:
Use Go to Special
507
Exercise
15-9:
Use Multiple Windows
508
Troubleshooting Errors
509
Exercise
15-10:
Look for Errors
510
Exercise
15-11:
Correct Errors
511
Using the Watch Window
511
Exercise
15-12:
Use the Watch Window
512
Exercise
15-13:
Delete a Watch
513
Exercise
15-14:
Correct Division by Zero
513
Exercise
15-15:
Mark a Workbook as Final
514
Using IFERROR
514
Exercise
15-16:
Use IFERROR
514
Lesson
15
Summary
516
Concepts Review
517
True/False Questions
517
Short Answer Questions
517
Critical Thinking
518
Skills Review
518
Exercise
15-17 518
Exercise
15-18 520
Exercise
15-19 521
Exercise
15-20 522
Lesson Applications
523
Exercise
15-21 523
Exercise
15-22 523
Exercise
15-23 524
Exercise
15-24 525
On Your Own
525
Exercise
15-25 525
Exercise
15-26 525
Exercise
15-27 525
LESSON
16:
USING
W
H
AT-1F ANALYSIS
526
Creating a Scenario
526
Exercise
16-1:
Enable and Run a Macro
527
Exercise
16-2:
Create a Scenario
528
Exercise
16-3:
Add Scenarios to the
Worksheet
529
Setting Highlight Cells Rules
531
Exercise
16-4:
Set a Highlight Cells Rule
531
Exercise
16-5:
Create a New Formatting Rule
532
Exercise
16-6:
Set Two Highlight Cells Rules
533
Managing Scenarios
533
Exercise
16-7:
Show Scenarios
533
Exercise
16-8:
Edit a Scenario
534
Exercise
16-9:
Print a Scenario
Summary Report
534
Exercise
16-10:
Save a Macro-Free Workbook
536
Forecasting with
a
Trendline 536
Exercise
16-11:
Create and Format a Chart
536
Exercise
16-12:
Add
a
Trendline
to a Chart
537
Exercise
16-13:
Format a Trendline
538
Using Goal Seek
539
Exercise
16-14:
Use Goal Seek to
Determine a Price
539
Exercise
16-15:
Use Goal Seek to
Determine Units Sold
541
Using Solver
541
Exercise
16-16:
Use Solver to Determine
Units Sold
541
Exercise
16-17:
Add Solver Constraints
543
Exercise
16-18:
Edit a Scenario Report
544
Exercise
16-19:
Save a Document with a
Thumbnail Preview
544
Lesson
16
Summary
546
Concepts Review
547
True/False Questions
547
Contents
xi
Short
Answer Questions
547
Critical Thinking
548
Skills Review
548
Exercise
16-20 548
Exercise
16-21 550
Exercise
16-22 551
Exercise
16-23 552
Lesson Applications
554
Exercise
16-24 554
Exercise
16-25 554
Exercise
16-26 555
Exercise
16-27 555
On Your Own
556
Exercise
16-28 556
Exercise
16-29 557
Exercise
16-30 557
LESSON
17:
CONSOLIDATING AND
LINKING WORKBOOKS
558
Creating a Static Data Consolidation
558
Exercise
17-1:
Prepare a Worksheet for
Consolidation
559
Exercise
17-2:
Create a Static Consolidation
559
Exercise
17-3:
Edit Underlying Data
560
Creating a Dynamic Data
Consolidation
561
Exercise
17-4:
Create a Dynamic
Consolidation
561
Exercise
17-5:
Display Formulas in
an Outline
562
Consolidating Data by Category
563
Exercise
17-6:
Set Up Data to Be Consolidated
564
Exercise
17-7:
Use AVERAGE to Consolidate
by Category
564
Exercise
17-8:
Consolidate Data by
Using MAX
565
Linking Workbooks
566
Exercise
17-9:
Link Workbooks by Pointing
566
Examining and Editing Links
568
Exercise
17-10:
Examine Links
568
Exercise
17-11:
Move a Source Workbook
570
Exercise
17-12:
Edit Links
570
Exercise
17-13:
Break Links
571
Exercise
17-14:
Restrict Permission to a
Workbook
571
Lesson
17
Summary
573
Concepts Review
575
True/False Questions
575
Short Answer Questions
575
Critical Thinking
576
Skills Review
576
Exercise
17-15 576
Exercise
17-16 577
Exercise
17-17 578
Exercise
17-18 579
Lesson Applications
580
Exercise
17-19 580
Exercise
17-20 580
Exercise
17-21 581
Exercise
17-22 581
On Your Own
582
Exercise
17-23 582
Exercise
17-24 582
Exercise
17-25 582
UNIT
5
APPLICATIONS
583
Unit Application
5-1 583
Unit Application
5-2 583
Unit Application
5-3 584
Unit Application
5-4 585
Unit
6
Exploring Data and Table Features
LESSON
18:
USING EXTERNAL
DATA SOURCES
Using Text Sources
Exercise
18-1:
Copy and Paste
from Word
Exercise
18-2:
Review Data and
Smart Tags
Exercise
18-3:
Create a Custom Format
Exercise
18-4:
Drag and Drop a Word
Document
Exercise
18-5:
Use Copy and Paste Special
Exercise
18-6:
Get a Text File
Managing Imported Data
Exercise
18-7:
Set Import Options
Exercise
18-8:
Create Theme Fonts
and Colors
Exercise
18-9:
Save a Document Theme
Exercise
18-10:
Remove Duplicate Data
588
588
589
590
591
592
592
593
594
594
595
596
597
Exercise
18-11:
Convert Text to Columns
597
Exercise
18-12:
Use PROPER and
SUBSTITUTE
598
Using Web Sources
599
Exercise
18-13:
Copy from the Web
by Dragging
600
Exercise
18-14:
Create a Web Query
601
Exercise
18-15:
Manage Connections
602
Using Database Sources
603
Exercise
18-16:
Import an Access Table
604
Exercise
18-17:
Use Microsoft Query
604
Exporting Excel Data
606
Exercise
18-18:
Copy Data to Word
607
Exercise
18-19:
Save a Workbook as a Text File
607
Exercise
18-20:
Delete a Document Theme
608
Lesson
18
Summary
Concepts Review
608
610
xii
Contents
True/False Questions
610
Short Answer Questions
610
Critical Thinking
611
Skills Review
611
Exercise
18-21 611
Exercise
18-22 612
Exercise
18-23 613
Exercise
18-24 614
Lesson Applications
615
Exercise
18-25 615
Exercise
18-26 615
Exercise
18-27 616
Exercise
18-28 616
On Your Own
617
Exercise
18-29 617
Exercise
18-30 617
Exercise
18-31 617
LESSON
19:
EXPLORING LIST RANGES
618
Sorting and Filtering a List Range
618
Exercise
19-1:
Name and Format a
List Range
619
Exercise
19-2:
Sort by Conditional
Formatting
619
Exercise
19-3:
Filter by Cell Attributes
621
Exercise
19-4:
Create Custom Filters
621
Creating Advanced Filters
623
Exercise
19-5:
Set the Criteria Range
623
Exercise
19-6:
Filter Data in Place
623
Exercise
19-7:
Create an Output Range
625
Exercise
19-8:
Filter Data to an
Output Range
625
Using Subtotals
626
Exercise
19-9:
Use Subtotal
626
Exercise
19-10:
Subtotal with AVERAGE
628
Using Database Functions
628
Exercise
19-11 :
Use DMIN
629
Exercise
19-12:
Use DCOUNT
630
Creating and Editing Outlines
630
Exercise
19-13 :
Use the SUBTOTAL function
631
Exercise
19-14:
Add Grand Totals
632
Exercise
19-15:
Create an Auto Outline
633
Exercise
19-16:
Create a Row Outline
Manually
634
Exercise
19-17:
Expand and Hide Details
635
Lesson
19
Summary
635
Concepts Review
637
True/False Questions
637
Short Answer Questions
637
Critical Thinking
638
Skills Review
638
Exercise
19-18 638
Exercise
19-19 639
Exercise
19-20 639
Exercise
19-21 640
Lesson Applications
642
Exercise
19-22 642
Exercise
19-23 642
Exercise
19-24 643
Exercise
19-25 644
On Your Own 645
Exercise
19-26 645
Exercise
19-27 645
Exercise
19-28 645
LESSON
20:
USING DATA TABLES
AND PIVOTTABLES
646
Building a One-Variable Data Table
646
Exercise
20-1:
Prepare Formulas and
Input Values
647
Exercise
20-2:
Create a Data Table
648
Exercise
20-3:
Format the Data Table
650
Exercise
20-4:
Insert an En Dash and
a Pointer
650
Exercise
20-5:
Delete, Edit, and Copy a
Data Table
652
Building a Two-Variable Data Table
652
Exercise
20-6:
Set Up Input Values
and the Formula
653
Exercise
20-7:
Create and Format the
Data Table
653
Analyzing Data in a PivotTable
654
Exercise
20-8:
View Data in a PivotTable
655
Exercise
20-9:
Pivot Fields in the PivotTable
Field List Pane
656
Creating a PivotTable
658
Exercise
20-10:
Create a PivotTable
658
Exercise
20-11:
Use PivotTable Tools
Options
659
Exercise
20-12:
Edit Field Settings
659
Using Multiple Calculations
661
Exercise
20-13:
Use Multiple Fields and
Functions
662
Exercise
20-14:
Add a Calculated Field
663
Exercise
20-15:
Set How Values are Shown
664
Exercise
20-16:
Refresh Data
665
Creating a PivotChart
665
Exercise
20-17:
Create a PivotChart for
an Existing PivotTable
665
Exercise
20-18:
Create a PivotChart from
the List
668
Lesson
20
Summary
669
Concepts Review
670
True/False Questions
670
Short Answer Questions
670
Critical Thinking
671
Skills Review
671
Exercise
20-19 671
Exercise
20-20 672
Exercise
20-21 673
Exercise
20-22 675
Lesson Applications
676
Exercise
20-23 676
Exercise
20-24 676
Contents
xiii
Exercise
20-25
Exercise
20-26
On
Your Own
Exercise
20-27
Exercise
20-28
Exercise
20-29
677
677
678
678
678
678
UNIT
6
APPLICATIONS
Unit Application
6-1
Unit Application
6-2
Unit Application
6-3
Unit Application
6-4
679
679
679
680
680
Unit
7
Exploring
Macros,
Templates, and
Workgroups
LESSON
21:
WORKING WITH
MACROS
682
Running and Viewing a Macro
682
Exercise
21 -1 :
Run a Macro
683
Exercise
21-2:
Open the Visual Basic Editor
684
Editing and Printing a Macro
685
Exercise
21-3:
Edit a Macro
685
Exercise
21-4:
Use a Macro Keyboard Shortcut
686
Exercise
21-5:
Add a Comment and Print a
Macro
687
Recording a Macro
688
Exercise
21-6:
Record a Macro with
Absolute References
688
Exercise
21-7:
Delete a Macro
690
Exercise
21-8:
Use Relative References in
a Macro
690
Exercise
21-9:
Review Macro Code
691
Assigning a Macro to a Button
692
Exercise
21-10:
Display the Developer Tab
692
Exercise
21 -11 :
Draw a Button
692
Exercise
21 -12 :
Delete a Button
693
Creating a Macro Workbook
694
Exercise
21 -13 :
Record Macros
694
Exercise
21-14:
Save, Hide, and Use a
Macro Workbook
695
Lesson
21
Summary
696
Concepts Review
697
True/False Questions
697
Short Answer Questions
697
Critical Thinking
698
Skills Review
698
Exercise
21-15 698
Exercise
21-16 699
Exercise
21-17 700
Exercise
21-18 701
Lesson Applications
703
Exercise
21-19 703
Exercise
21-20 703
Exercise
21-21 704
Exercise
21-22 704
On Your Own
705
Exercise
21-23 705
Exercise
21-24 705
Exercise
21-25 705
LESSON
22:
USING TEMPLATES
706
Using an Installed Template
706
Exercise
22-1:
Create a Workbook Based
on an Installed Template
707
Exercise
22-2:
Edit and Save a Workbook
Based on a Template
707
Adding Worksheet Protection
708
Exercise
22-3:
Edit an Installed Template
708
Exercise
22-4:
Change the Locked Property
710
Exercise
22-5:
Protect the Worksheet
711
Exercise
22-6:
Update Properties
711
Exercise
22-7:
Save a Template
713
Exercise
22-8:
Use View Side by Side
714
Exercise
22-9:
Delete a Template
715
Using an Online Template
715
Exercise
22-10:
Download an Online Template
715
Exercise
22-11:
Edit and Save a Template
716
Exercise
22-12:
Use and Delete a Template
718
Creating a User Template
718
Exercise
22-13:
Build a Template
719
Exercise
22-14:
Add a Formula and Hide Zeros
719
Exercise
22-15:
Add Data Validation
Exercise
22-16:
Use a Validation Input
Message
Exercise
22-17:
Add Conditional Formatting
and a Comment
Exercise
22-18:
Protect the Sheet with
a Password
Exercise
22-19:
Create a Templates Folder
Exercise
22-20:
Create a Workbook from
a Template
Exercise
22-21 :
Remove Protection and the
Password
720
721
722
722
723
724
725
Using Workbook Protection
725
Exercise
22-22:
Create a Workbook Template
725
Exercise
22-23:
Add Sheet and Workbook
Protection
726
Exercise
22-24:
Delete a Folder and Files
727
Lesson
22
Summary
Concepts Review
True/False Questions
Short Answer Questions
Critical Thinking
Skills Review
Exercise
22-25
Exercise
22-26
Exercise
22-27
Exercise
22-28
Lesson Applications
Exercise
22-29
Exercise
22-30
Exercise
22-31
Exercise
22-32
729
730
730
730
731
731
731
732
734
735
737
737
737
738
738
XIV
Contents
On Your Own
739
Exercise
22-33
739
Exercise
22-34
739
Exercise
22-35
739
LESSON
23:
USING WORKGROUP
FEATURES
740
Creating a Shared Workbook
740
Exercise
23-1:
Create a Shared Workbook
741
Tracking Changes
742
Exercise
23-2:
Set Change History Options
743
Exercise
23-3:
Activate Change Highlighting
744
Exercise
23-4:
Track and Highlight Changes
744
Exercise
23-5:
Add Comments in a Shared
Workbook
745
Printing a Change History Sheet
746
Exercise
23-6:
Display and Print a History
Worksheet
746
Comparing and Merging Workbooks
747
Exercise
23-7:
Display the Compare and
Merge Button
747
Exercise
23-8:
Compare and Merge Workbooks
748
Accepting or Rejecting Changes
749
Exercise
23-9:
Accept or Reject Changes
749
Exercise
23-10:
Reset the User Name and
Quick Access Toolbar
750
Lesson
23
Summary
751
Concepts Review
752
True/False Questions
752
Short Answer Questions
Critical Thinking
Skills Review
Exercise
23-11
Exercise
23-12
Exercise
23-13
Exercise
23-14
Lesson Applications
Exercise
23-15
Exercise
23-16
Exercise
23-17
Exercise
23-18
On Your Own
Exercise
23-19
Exercise
23-20
Exercise
23-21
UNIT
7
APPLICATIONS
Unit Application
7-1
Unit Application
7-2
Unit Application
7-3
Unit Application
7-4
APPENDIX
GLOSSARY
INDEX
752
753
753
753
754
755
756
758
758
758
759
759
760
760
760
760
761
761
762
762
763
A-1
G-1
1-1 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Stewart, Kathleen |
| author_facet | Stewart, Kathleen |
| author_role | aut |
| author_sort | Stewart, Kathleen |
| author_variant | k s ks |
| building | Verbundindex |
| bvnumber | BV035078992 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.4.M523 |
| callnumber-search | HF5548.4.M523 |
| callnumber-sort | HF 45548.4 M523 |
| callnumber-subject | HF - Commerce |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)87755659 (DE-599)BVBBV035078992 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000zc 4500</leader><controlfield tag="001">BV035078992</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20091105</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">081001s2008 xxuad|| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2007011392</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780073519210</subfield><subfield code="9">978-0-07-351921-0</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780073294674</subfield><subfield code="9">978-0-07-329467-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)87755659</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV035078992</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HF5548.4.M523</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Stewart, Kathleen</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Office Excel</subfield><subfield code="b">a professional approach</subfield><subfield code="c">Kathleen Stewart</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Excel 2007</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Microsoft Office Excel 2007</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boston [u.a.]</subfield><subfield code="b">McGraw-Hill</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">Getr. Zählung</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Professional approach series</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Excel 2007</subfield><subfield code="0">(DE-588)7558101-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Excel 2007</subfield><subfield code="0">(DE-588)7558101-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0710/2007011392-d.html</subfield><subfield code="3">Publisher description</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0710/2007011392-t.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bayreuth</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016747261&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016747261</subfield></datafield></record></collection> |
| id | DE-604.BV035078992 |
| illustrated | Illustrated |
| index_date | 2024-07-02T22:06:28Z |
| indexdate | 2024-08-20T00:32:21Z |
| institution | BVB |
| isbn | 9780073519210 9780073294674 |
| language | English |
| lccn | 2007011392 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016747261 |
| oclc_num | 87755659 |
| open_access_boolean | |
| owner | DE-703 |
| owner_facet | DE-703 |
| physical | Getr. Zählung Ill., graph. Darst. |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | McGraw-Hill |
| record_format | marc |
| series2 | Professional approach series |
| spelling | Stewart, Kathleen Verfasser aut Microsoft Office Excel a professional approach Kathleen Stewart Excel 2007 Microsoft Office Excel 2007 Boston [u.a.] McGraw-Hill 2008 Getr. Zählung Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Professional approach series Includes index. Microsoft Excel (Computer file) Wirtschaft Business Computer programs Electronic spreadsheets Excel 2007 (DE-588)7558101-2 gnd rswk-swf Excel 2007 (DE-588)7558101-2 s DE-604 http://www.loc.gov/catdir/enhancements/fy0710/2007011392-d.html Publisher description http://www.loc.gov/catdir/enhancements/fy0710/2007011392-t.html Table of contents only Digitalisierung UB Bayreuth application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016747261&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Stewart, Kathleen Microsoft Office Excel a professional approach Microsoft Excel (Computer file) Wirtschaft Business Computer programs Electronic spreadsheets Excel 2007 (DE-588)7558101-2 gnd |
| subject_GND | (DE-588)7558101-2 |
| title | Microsoft Office Excel a professional approach |
| title_alt | Excel 2007 Microsoft Office Excel 2007 |
| title_auth | Microsoft Office Excel a professional approach |
| title_exact_search | Microsoft Office Excel a professional approach |
| title_exact_search_txtP | Microsoft Office Excel a professional approach |
| title_full | Microsoft Office Excel a professional approach Kathleen Stewart |
| title_fullStr | Microsoft Office Excel a professional approach Kathleen Stewart |
| title_full_unstemmed | Microsoft Office Excel a professional approach Kathleen Stewart |
| title_short | Microsoft Office Excel |
| title_sort | microsoft office excel a professional approach |
| title_sub | a professional approach |
| topic | Microsoft Excel (Computer file) Wirtschaft Business Computer programs Electronic spreadsheets Excel 2007 (DE-588)7558101-2 gnd |
| topic_facet | Microsoft Excel (Computer file) Wirtschaft Business Computer programs Electronic spreadsheets Excel 2007 |
| url | http://www.loc.gov/catdir/enhancements/fy0710/2007011392-d.html http://www.loc.gov/catdir/enhancements/fy0710/2007011392-t.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016747261&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT stewartkathleen microsoftofficeexcelaprofessionalapproach AT stewartkathleen excel2007 AT stewartkathleen microsoftofficeexcel2007 |