THE FOLLOWING IC3 GS4: KEY APPLICATIONS EXAM OBJECTIVES ARE COVERED IN THIS CHAPTER:
✓ Common Features and Commands
■ Demonstrate the use of keyboard shortcut keys or “hot keys” to invoke application features in an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to move, copy, and paste user data within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to reveal or hide user data from view within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to print user data from within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product and control the configuration in which the data is presented or printed as listed in the objective.
■ Demonstrate how to check spelling within user data, find and replace portions of user data, and use the Undo and Redo features to alter user data within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to move user data using the Drag and Drop features within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to control presentation and configuration of user data within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application.
■ Identify the various sources of help, built-in, online, context-sensitive, help lines, chat services, coworkers, help desks, etc. available to get assistance in learning how to use an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Describe how each source of help is accessed, what kind of help can be found at each source, and which resources are available when.
✓ Selecting
■ Demonstrate how to select user data using the features listed in the objective within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to sort user data using the features built into an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
✓ Formatting
■ Demonstrate how to organize, configure, and/or format user data from within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product using a ’styles’ or ’styles-like’ feature in such a way as to control the look, feel, and other display characteristics with which the data is presented on-screen or printed.
■ Demonstrate how to control the font face display features listed in the objective from within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product in such a way as to control the look, feel, and other display characteristics with which the user data is presented on-screen or printed.
■ Basic text formatting
✓ Navigating
■ Demonstrate how to launch and terminate an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Further demonstrate how to open an application data file and make it available for editing within an application program and how to close an application data file so that it is no longer immediately available to an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to save user data in an application data file using the same and/or different file names and path information from within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to create a new empty application data file, either blank, or using an available templates provided with the application from within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to manipulate OS and application windows to automatically resize while using an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Describe how to search for specific subsets of user data within a larger set of user data in an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product.
■ Demonstrate how to display user data from within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product and control the size, orientation, portion of data displayed and other display configuration settings in which the data is presented as listed in the objective, including ways to save, change, and delete those settings.
■ Views
✓ Working with multimedia files
■ Demonstrate how to adjust the display of pictures, videos, audio, or other multimedia content within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product according to the action listed in the objective.
■ Demonstrate how to incorporate and display pictures, videos, audio, or other multimedia content within an application such as a word processor, spreadsheet, presentation package, database manager, or other software application product according to the action listed in the objective.
We will begin by showing how to start the Microsoft Office application that you want to use and how to create your first empty file. You will then learn how to save your work and how to work with multiple Microsoft Office windows at the same time.
Then we will take a deep dive into more complex aspects of working with data: selecting it, copying it, and moving it around your files. You will learn how to find a specific subset of your data, how to replace it, how to improve the spelling of your files, and how to change the way you view them. Then we will demonstrate how to print your files when you have finished working with them.
The next portion of this chapter will be about formatting your files and improving the way they look so that you can communicate more effectively when you share them with others.
Finally, we will demonstrate the basic ways you can add multimedia files to your Microsoft Office documents and presentations, along with the adjustments you can make so that your multimedia files will display to their best advantage. There’s a lot of ground to cover, so let’s get started.
Creating New Empty Documents with Microsoft Office
The first step you need to go through when creating any Microsoft Office file is to learn how to start the Microsoft Office application that you want to use and how to create an empty file. Then you can start working with it. When you have finished, you need to know how to save your work so that it is not lost.
Chances are that you will need to work with multiple files at the same time and use data from multiple sources. That’s why it is good to know how to work with multiple application