Muutke küpsiste eelistusi

IC3: Internet and Computing Core Certification Key Applications Global Standard 4 Study Guide [Pehme köide]

  • Formaat: Paperback / softback, 300 pages, kõrgus x laius x paksus: 235x188x16 mm, kaal: 526 g
  • Ilmumisaeg: 29-May-2015
  • Kirjastus: Sybex Inc.,U.S.
  • ISBN-10: 1118991729
  • ISBN-13: 9781118991725
Teised raamatud teemal:
  • Pehme köide
  • Hind: 31,59 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Paperback / softback, 300 pages, kõrgus x laius x paksus: 235x188x16 mm, kaal: 526 g
  • Ilmumisaeg: 29-May-2015
  • Kirjastus: Sybex Inc.,U.S.
  • ISBN-10: 1118991729
  • ISBN-13: 9781118991725
Teised raamatud teemal:
Master word processing, spreadsheets, and presentations ahead of the IC3 exam

IC3: Internet and Computing Core Certification Key Applications Study Guide is your ideal study guide when you want to focus on the Key Applications exam module in preparation for the IC3. This book covers common features and functions, word processing, spreadsheets, and presentations, all presented in a clear, concise style. Hands-on examples and self-paced exercises show you how to perform critical tasks needed to pass the exam, and the companion website offers a diverse set of study tools including the Sybex test engine, a preassessment test, hundreds of practice questions, videos, and access to over one hundred electronic flashcards. Test your skills and solidify your understanding of Key Applications for the IC3.

  • Master the functions common to all programs, and the most common features
  • Review the basics of word processing, with formatting and automation
  • Understand spreadsheets, and how to manipulate data with formulas
  • Brush up on the creation and formatting of simple presentations

When you are serious about certification, IC3 provides the practice that inspires self-confidence.

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)
Summary
69(1)
Exam Essentials
70(1)
Key Terms
71(1)
Review Questions
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)
Creating Tables
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)
Summary
111(1)
Exam Essentials
111(1)
Key Terms
111(1)
Review Questions
112(3)
Chapter 3 Using Microsoft Excel
115(48)
Navigating among Worksheets, Workbooks, and Cells
116(6)
Navigating between Worksheets
117(1)
Navigating between Cells
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)
Sorting Data
138(2)
Filtering Data
140(2)
Using Common Formulas and Functions
142(9)
Using Mathematical Operators
143(2)
Using Relative and Absolute References
145(3)
Using Functions
148(3)
Adding Charts and Graphs
151(8)
Inserting a Line Chart
153(2)
Inserting a Pie Chart
155(2)
Inserting a Bar Graph
157(2)
Summary
159(1)
Exam Essentials
159(1)
Key Terms
160(1)
Review Questions
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)
Summary
195(1)
Exam Essentials
196(1)
Key Terms
196(1)
Review Questions
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)
Summary
217(1)
Exam Essentials
218(1)
Key Terms
218(1)
Review Questions
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)
Summary
238(1)
Exam Essentials
238(1)
Key Terms
239(1)
Review Questions
240(3)
Appendix A Answers to Review Questions 243(6)
Appendix B Using the Practice Files 249(4)
Index 253
Ciprian Adrian Rusen is a recognized Windows Consumer Expert – Microsoft Most Valuable Professional (MVP). He has published several books about Windows and Microsoft Office, and he's an active tech blogger at http://www.7tutorials.com. At 7 Tutorials, he also provides complete tutorials for Windows, Windows Phone, and Xbox One users.