Key Applications (IC3 GS5 Exam 2)

Exploring Common Application Features in Microsoft Office

• Creating New Empty Documents with Microsoft Office
• The Basics of Using Microsoft Office Applications
• The Basics of Formatting Your Microsoft Office Files
• Working with Multimedia Files in Microsoft Office
• Summary

Using Microsoft Word

• Configuring the Layout of Your Documents
• Organizing the Data in Your Documents
• Summary

Using Microsoft Excel

• Navigating among Worksheets, Workbooks, and Cells
• Changing the Alignment and the Positioning of Cells
• Changing the Size of Cells
• Formatting How Cells Are Displayed
• Adding and Removing Rows and Columns
• Merging or Unmerging Cells
• Using Number Formats in Microsoft Excel Workbooks
• Sorting and Filtering Data
• Using Common Formulas and Functions
• Adding Charts and Graphs
• Summary

Using Microsoft PowerPoint

• Adding and Removing Slides When Creating Presentations
• Changing the Order of Your Slides
• Changing the Design and the Background of Your Presentations
• Adding and Formatting the Text in Your Presentations
• Changing the Layout of Your Slides
• Adding Shapes and Pictures to Your Slides
• Adding Tables to Your Presentations
• Formatting the Tables in Your Presentations
• Adding Charts to Your Presentations
• Adding Video and Other Multimedia Files to Your Presentations
• Adding Animations to Your Presentation
• Setting Transitions between Slides and Viewing Your Presentations
• Summary

Using Microsoft Access

• Adding, Modifying, and Removing Data in a Microsoft Access Database
• Using Search in a Microsoft Access Database
• Using Stored Queries in a Microsoft Access Database
• Running Predefined Reports in a Microsoft Access Database
• Creating Simple Reports in a Microsoft Access Database
• Creating Simple Forms in a Microsoft Access Database
• Summary

Collaborating with Others When Working in Microsoft Office

• Adding Comments to Your Microsoft Office Files
• Reviewing the Comments That Were Added to a Document
• Tracking Changes in a Microsoft Word Document
• Reviewing Changes in a Microsoft Word Document
• Sharing Your Work Files Using Email
• Storing Documents Using Network Attached Storage Solutions
• Storing Documents Using Cloud Storage Solutions
• Summary

Appendix A: Objective Mappings