Introduction |
|
xvii | |
Assessment Test |
|
xxix | |
|
Chapter 1 Exploring Common Application Features in Microsoft Office |
|
|
1 | (74) |
|
Creating New Empty Documents with Microsoft Office |
|
|
4 | (14) |
|
Starting and Closing Microsoft Office Applications |
|
|
5 | (1) |
|
Opening and Closing Microsoft Office Files |
|
|
6 | (1) |
|
Creating New Empty Files with Microsoft Office |
|
|
7 | (2) |
|
Saving Your Microsoft Office Files |
|
|
9 | (4) |
|
Working with Several Windows at the Same Time |
|
|
13 | (5) |
|
The Basics of Using Microsoft Office Applications |
|
|
18 | (37) |
|
Keyboard Shortcuts for Using the Ribbon Productively |
|
|
18 | (4) |
|
Selecting, Copying, and Moving Data When Using Microsoft Office Applications |
|
|
22 | (9) |
|
Dragging and Dropping Data When Using Microsoft Office Applications |
|
|
31 | (1) |
|
Finding and Replacing Data in Your Microsoft Office Documents |
|
|
32 | (3) |
|
Checking the Spelling of Your Microsoft Office Documents |
|
|
35 | (3) |
|
Undoing Your Changes and Mistakes When Working with Microsoft Office Documents |
|
|
38 | (1) |
|
Hiding Your Data from Tables and Charts |
|
|
39 | (2) |
|
Selecting Non-adjacent Cells in Microsoft Excel Tables |
|
|
41 | (2) |
|
Sorting Data When Working with Microsoft Excel Files |
|
|
43 | (2) |
|
Adjusting the Way You View Microsoft Office Files |
|
|
45 | (4) |
|
Adjusting the Size and the Orientation of Your Microsoft Office Files |
|
|
49 | (2) |
|
Printing Your Documents from Microsoft Office |
|
|
51 | (1) |
|
Where to Get Help with Using Microsoft Office |
|
|
52 | (3) |
|
The Basics of Formatting Your Microsoft Office Files |
|
|
55 | (7) |
|
Formatting the Text in Your Documents |
|
|
55 | (3) |
|
Using Styles to Format Your Documents |
|
|
58 | (4) |
|
Working with Multimedia Files in Microsoft Office |
|
|
62 | (7) |
|
Adding Multimedia Files to Your Presentations |
|
|
62 | (4) |
|
Adjusting the Pictures Used in Your Presentations |
|
|
66 | (3) |
|
|
69 | (1) |
|
|
70 | (1) |
|
|
71 | (1) |
|
|
72 | (3) |
|
Chapter 2 Using Microsoft Word |
|
|
75 | (40) |
|
Configuring the Layout of Your Documents |
|
|
76 | (20) |
|
Adjusting Line and Paragraph Spacing in Your Documents |
|
|
76 | (3) |
|
Aligning the Text in Your Documents |
|
|
79 | (4) |
|
Organizing Your Documents into Columns |
|
|
83 | (1) |
|
Setting the Margins of Your Documents |
|
|
84 | (3) |
|
Displaying the Ruler When Editing Documents |
|
|
87 | (1) |
|
Indenting the Text in Your Documents |
|
|
88 | (4) |
|
Using Tabs to Control Where the Text Is Placed in Your Documents |
|
|
92 | (4) |
|
Organizing the Data in Your Documents |
|
|
96 | (15) |
|
Creating Bulleted and Numbered Lists |
|
|
97 | (1) |
|
Sorting Single-Level Lists |
|
|
98 | (2) |
|
|
100 | (3) |
|
Adding or Removing Rows and Columns in Your Tables |
|
|
103 | (1) |
|
Merging and Splitting Cells in Your Tables |
|
|
104 | (3) |
|
Adding Page Numbers to Your Documents |
|
|
107 | (4) |
|
|
111 | (1) |
|
|
111 | (1) |
|
|
111 | (1) |
|
|
112 | (3) |
|
Chapter 3 Using Microsoft Excel |
|
|
115 | (48) |
|
Navigating among Worksheets, Workbooks, and Cells |
|
|
116 | (6) |
|
Navigating between Worksheets |
|
|
117 | (1) |
|
|
118 | (4) |
|
Changing the Alignment and the Positioning of Cells |
|
|
122 | (3) |
|
Changing the Size of Cells |
|
|
125 | (3) |
|
Formatting How Cells Are Displayed |
|
|
128 | (2) |
|
Adding and Removing Rows and Columns |
|
|
130 | (3) |
|
Merging or Unmerging Cells |
|
|
133 | (2) |
|
Using Number Formats in Microsoft Excel Workbooks |
|
|
135 | (2) |
|
Sorting and Filtering Data |
|
|
137 | (5) |
|
|
138 | (2) |
|
|
140 | (2) |
|
Using Common Formulas and Functions |
|
|
142 | (9) |
|
Using Mathematical Operators |
|
|
143 | (2) |
|
Using Relative and Absolute References |
|
|
145 | (3) |
|
|
148 | (3) |
|
|
151 | (8) |
|
|
153 | (2) |
|
|
155 | (2) |
|
|
157 | (2) |
|
|
159 | (1) |
|
|
159 | (1) |
|
|
160 | (1) |
|
|
161 | (2) |
|
Chapter 4 Using Microsoft PowerPoint |
|
|
163 | (36) |
|
Adding and Removing Slides When Creating Presentations |
|
|
165 | (3) |
|
Changing the Order of Your Slides |
|
|
168 | (1) |
|
Changing the Design and the Background of Your Presentations |
|
|
169 | (3) |
|
Adding and Formatting the Text in Your Presentations |
|
|
172 | (3) |
|
Changing the Layout of Your Slides |
|
|
175 | (2) |
|
Adding Shapes and Pictures to Your Slides |
|
|
177 | (3) |
|
Adding Tables to Your Presentations |
|
|
180 | (3) |
|
Formatting the Tables in Your Presentations |
|
|
183 | (3) |
|
Adding Charts to Your Presentations |
|
|
186 | (2) |
|
Adding Video and Other Multimedia Files to Your Presentations |
|
|
188 | (2) |
|
Adding Animations to Your Presentation |
|
|
190 | (3) |
|
Setting Transitions between Slides and Viewing Your Presentations |
|
|
193 | (2) |
|
|
195 | (1) |
|
|
196 | (1) |
|
|
196 | (1) |
|
|
197 | (2) |
|
Chapter 5 Using Microsoft Access |
|
|
199 | (22) |
|
Adding, Modifying, and Removing Data in a Microsoft Access Database |
|
|
200 | (5) |
|
Using Search in a Microsoft Access Database |
|
|
205 | (3) |
|
Using Stored Queries in a Microsoft Access Database |
|
|
208 | (2) |
|
Running Predefined Reports in a Microsoft Access Database |
|
|
210 | (1) |
|
Creating Simple Reports in a Microsoft Access Database |
|
|
211 | (6) |
|
|
217 | (1) |
|
|
218 | (1) |
|
|
218 | (1) |
|
|
219 | (2) |
|
Chapter 6 Collaborating with Others When Working in Microsoft Office |
|
|
221 | (22) |
|
Adding Comments to Your Microsoft Office Files |
|
|
222 | (3) |
|
Reviewing the Comments That Were Added to a Document |
|
|
225 | (1) |
|
Tracking Changes in a Microsoft Word Document |
|
|
226 | (2) |
|
Reviewing Changes in a Microsoft Word Document |
|
|
228 | (3) |
|
Sharing Your Work Files Using Email |
|
|
231 | (3) |
|
Storing Documents Using Network Attached Storage Solutions |
|
|
234 | (2) |
|
Storing Documents Using Cloud Storage Solutions |
|
|
236 | (2) |
|
|
238 | (1) |
|
|
238 | (1) |
|
|
239 | (1) |
|
|
240 | (3) |
Appendix A Answers to Review Questions |
|
243 | (6) |
Appendix B Using the Practice Files |
|
249 | (4) |
Index |
|
253 | |