TestOut
Office Pro
Certification Objectives
Microsoft Word
2.2 Creating Documents
- Create a new blank document.
- Open a downloaded document and enable editing.
- Move the insertion point.
- Enter text into a document.
- Select words, lines, and paragraphs.
- Delete text.
- Copy and cut text to the Clipboard.
- Paste formatted and unformatted text from the Clipboard.
- Clear the Clipboard.
- Undo or redo an action.
- Close a document.
- Reorganize the content in a document.
- Paste text from a website into a Word document.
2.3 Managing and Printing Documents
- Modify document properties.
- View document statistics.
- Save a Word document in various formats, including PDF and plain text.
- Print a custom range of pages in a document.
- Print from a non-default printer.
- Collapse and pin the ribbon.
- Use ScreenTip help.
- Scroll through a document.
- Prepare a document to be uploaded to the Web.
- Prepare a document to be distributed within a company.
2.4 Modifying Fonts
- Bold, italicize, or underline a selection of text.
- Modify the case of a word.
- Change the font color of selected text.
- Apply a superscript.
- Apply a subscript.
- Change the font size of selected text.
- Change the font of selected text.
- Apply a Text Effect to selected text.
- Apply Text Highlighting to selected text.
- Format the fonts in a resume.
- Create a math worksheet.
2.5 Formatting Paragraphs
- Align a paragraph to the left, right, or center of the page.
- Show and hide formatting symbols.
- Clear formatting within a selection.
- Change the line spacing for paragraphs.
- Change the spacing before and after a paragraph.
- Change paragraph indents.
- Apply a border to a paragraph.
- Apply shading to a paragraph.
- Set orphan/widow paragraph control options.
- Create a numbered list.
- Create a bulleted list.
- Customize bullets.
- Adjust the indent level for lists.
- Format a series of lists in a document.
2.6 Formatting Pages
- Add a watermark to a page.
- Add a page border.
- Create and format multiple columns on a page.
- Insert and modify tab stops.
- Add dot leaders to tabs.
- Modify page margins.
- Modify page orientation.
- Insert a page break.
- Insert a column break.
- Align text vertically on a page.
- Format a report as a draft.
- Format only part of a document into two columns.
- Insert manual page breaks where needed in a document.
2.7 Editing Documents
- Find and replace a particular word within a document.
- Turn automatic spelling and grammar checking on and off.
- Use the spelling and grammar checker.
- Use the thesaurus to find synonyms.
- Count the total words in a document.
- Correct errors while typing with AutoCorrect.
- Customize AutoCorrect settings.
- Modify an AutoCorrect entry.
- Remove a hyperlink from text.
- Identify default AutoCorrect changes that might need to be modified.
- Ignore spelling and grammar suggestions when appropriate.
2.8 Inserting Illustrations and Other Elements
- Insert a picture from a file.
- Insert a picture from the Internet.
- Resize a picture or graphic.
- Move and align an image.
- Modify picture styles.
- Insert a symbol.
- Insert a shape.
- Insert the current date into a document.
- Delete a picture or graphic.
- Modify text wrap settings for visual appeal.
2.9 Creating and Formatting Tables
- Insert a blank table into a document.
- Add additional columns to an existing table.
- Add additional rows to an existing table.
- Modify cell alignment.
- Split or merge table cells.
- Format table cells.
- Convert a table to text.
- Enter or delete table data.
- Apply a table style.
- Resize table columns to fit contents.
- Center or align a table.
- Delete rows and columns.
- Format the header row and other table style options.
- Align table data for better readability.
2.10 Using Themes, Styles, and Templates
- Create a document from an existing template.
- Remove content controls in a template.
- Modify the theme font.
- Apply heading styles to paragraphs.
- Modify text formatting using Format Painter.
- Change the theme for a document.
- Select a style set for a document.
- Edit an existing style.
2.11 Managing References
- Insert a new citation source for a document.
- Edit a citation to add a page number.
- Insert a bibliography of current sources for a document.
- Insert a footnote at the bottom of the page.
- Insert an endnote.
- Modify the number format of footnotes.
- Edit a citation source.
- Convert a citation to static text.
- Import a citation source into the current document.
- Update a bibliography.
- Cite sources for an academic paper using the MLA, Chicago, and APA citation styles.
2.12 Managing Headers, Footers, and Sections
- Insert information into the header or footer, including date and time, page number, and filename.
- Suppress the page number on the first page of a document.
- Restart page numbering for a new section.
- Close the header and footer.
- Insert a Next Page section break.
- Format a section with a different page orientation.
- Begin numbering on a page other than the first.
Microsoft Excel
3.2 Creating and Managing Workbooks
- Open a workbook.
- Create a new blank workbook.
- Change workbook properties.
- Enable editing to exit the Protected View.
- Insert and delete worksheets.
- Navigate between worksheets.
- Save a workbook in Excel format, in a character-separated values format (both tabs and commas), and as a PDF file.
- Rename worksheets.
- Reorder and color worksheet tabs.
- Move and copy a worksheet.
- Import data from a comma-separated text file.
- Collapse and pin the ribbon.
- Import data from various applications into Excel.
3.3 Organizing and Entering Data
- Select a single cell and a range of cells.
- Enter worksheet titles.
- Enter column and row titles.
- Freeze column and row titles and panes.
- Enter text and numbers into cells.
- Use the Copy and Cut commands on cell ranges.
- Use paste options.
- Insert rows and columns into a sheet.
- Insert multiple rows in one operation.
- Delete and clear rows and columns.
- Hide and unhide rows and columns.
- Undo and redo actions.
- Manage a worksheet that contains a large data set.
- Insert new data between rows or columns.
3.4 Changing Properties and Printing Worksheets
- Lock and unlock cells.
- Protect worksheets and workbooks from changes.
- Preview and print a worksheet.
- Set and clear the print area for a worksheet.
- Change worksheet margins.
- Create and modify a worksheet header.
- Create a worksheet footer.
- Change worksheet orientation for printing.
- Scale a worksheet to be printed on a single page.
- Add print titles.
- Prevent particular cells from being modified.
- Print a particular section of worksheet data.
- Include relevant worksheet properties in a printout.
- Optimize the printing of a worksheet.
3.5 Formatting Cells
- Apply font style, size, and color changes to cells.
- Apply cell styles.
- Change the fill color (shading).
- Merge and center a range of cells.
- Apply number formatting to cells.
- Apply the percent style to cells.
- Increase and decrease decimal spaces.
- Enter and format dates.
- Adjust column widths (including AutoFit).
- Resolve the ###### error message.
- Adjust row heights.
- Align cell content.
- Rotate cell content.
- Clear cell formatting.
- Apply borders and border colors.
- Apply Word Wrap.
- Format cells as column or row totals.
- Adjust columns to display both numeric and textual data properly.
- Merge cells.
3.6 Entering Simple Formulas
- Enter a formula using the keyboard.
- Use the mouse to reference cells in a formula.
- Copy a formula using the fill handle.
- Copy a formula using the Clipboard.
- Sum a column or row using AutoSum.
- Use the MAX, MIN, AVERAGE, and MEDIAN functions.
- Use arithmetic operations properly in formulas.
- Add columns and rows of data.
- Copy formulas to cells that require similar calculations.
- Perform simple arithmetic that references cell values.
- Use AutoFill to enter data that follow a predictable pattern.
3.7 Using Advanced Functions
- Enter a function using the Insert Function box.
- Display and hide formulas.
- Enter a formula using absolute references.
- Enter a formula using relative references.
- Use the IF function.
- Use COUNTIF, SUMIF, and AVERAGEIF.
- Use functions with multiple arguments.
- Copy a formula with absolute references.
- Copy a formula with relative references.
- Correct or ignore error messages, as appropriate.
- Select appropriate functions to perform conditional operations.
- Determine when to use an absolute reference in a formula.
- Verify that the desired values have been properly referenced within a formula.
3.8 Analyzing Data in Charts
- Select a data source for a chart.
- Add a data series to an existing chart.
- Insert a clustered column chart.
- Create a pie chart.
- Move a chart on a worksheet.
- Move a chart to its own worksheet.
- Resize a chart.
- Modify a chart style and type.
- Format chart elements.
- Show and hide chart elements.
- Use recommended charts.
- Insert a chart to show changes over time.
- Insert a chart to display the aggregate of a set of values.
- Modify chart layouts to better visualize data.
3.9 Analyzing Data in Tables
- Create a table.
- Apply table styles.
- Insert table rows and columns.
- Add a total row.
- Sort a table.
- Remove duplicate rows.
- Filter a table using AutoFilter options.
- Apply highlight cell rules for conditional formatting.
- Apply data bars for conditional formatting.
- Determine when a data set should be converted to a table.
- Sort rows of data based on the values in particular columns.
- Use both text and number filters to display only desired information.
- Conditionally format cells that contain the most important data.
Microsoft PowerPoint
4.2 Creating and Managing Presentations
- Create a new blank presentation.
- Create a presentation using a template.
- Delete slides.
- Reorder slides.
- Duplicate slides.
- Save presentations in various formats.
- Copy and paste slides.
- Change presentation properties (e.g., author).
- Create new slides.
- Hide slides.
- Collapse and pin the ribbon.
- Add and remove sections in a presentation.
- Reorganize and modify an existing presentation.
- Organize a long presentation into relevant sections.
4.3 Formatting Textual Content
- Increase or decrease list levels.
- Modify a bulleted list style.
- Enter text into a placeholder.
- Add text to a shape.
- Change fonts and font styles.
- Change font colors and sizes.
- Align paragraph text.
- Change line spacing.
- Align text within a placeholder.
- Clear text formatting.
- Use Autofit to shrink text on overflow.
- Divide content into multiple slides.
- Use italics or a different font color to emphasize important content.
4.4 Designing Slides
- Change the presentation theme.
- Use theme variants.
- Apply font and color themes.
- Change the size of slides.
- Insert a fill or picture into the slide background.
- Modify background transparency.
- Insert a slide with a particular layout.
- Change slide layouts.
- Keep the design of slides consistent across an entire presentation.
- Select the slide size based on the delivery platform.
- Select themes, styles, and images that complement the presentation topic.
4.5 Using the Slide Master
- Insert a new slide master.
- Insert a new slide master layout.
- Modify text placeholders on a slide master.
- Insert a graphic into a slide master.
- Modify the font style in a slide master.
- Insert a placeholder.
- Delete a placeholder.
- Change the size of a placeholder.
- Copy and paste slide elements.
- Insert the slide number and date into slide footers.
- Determine when a new slide master or slide master layout is needed for a presentation.
- Modify an existing slide master layout to meet the needs of a presentation.
- Use slide master layouts to keep content consistent across slides.
4.6 Formatting Illustrations and Tables
- Insert a table.
- Modify table layouts and design.
- Apply Quick Styles to drawing objects.
- Apply fill colors to drawing objects.
- Align and distribute objects.
- Add SmartArt diagrams.
- Convert a bulleted list into a SmartArt diagram.
- Change the stacking order of selected objects.
- Add WordArt to a new placeholder.
- Insert a shape.
- Select and modify SmartArt to graphically represent processes and organizational structures.
- Maintain a style for graphics that is consistent with the overall theme of a presentation.
- Use WordArt without detracting from the professionalism of a presentation.
4.7 Formatting Pictures and Other Media
- Add pictures within content placeholders.
- Use the Picture Styles gallery.
- Change the size of images.
- Change the shape of a picture (e.g. crop option).
- Format picture borders.
- Insert videos.
- Adjust video brightness and contrast.
- Add video playback options.
- Resize a video.
- Add online pictures (i.e. clip art).
- Insert an audio file.
- Add a hyperlink to text.
- Incorporate high quality and relevant images into a presentation.
- Format images to match the overall theme of a presentation.
- Adjust the timing and visual quality of videos.
4.8 Applying Animations and Transitions
- Apply animation effects (entrance, exit, and emphasis).
- Modify the start timing of animations.
- Change the sequence of animations.
- Customize the direction of animations.
- Preview and test animations.
- Apply slide transitions.
- Modify the duration and timing of transitions.
- Test transitions.
- Adjust the timing of animations to match the flow of a presentation.
4.9 Delivering Presentations
- Check the spelling in presentations.
- Use the thesaurus pane.
- Add speaker notes to a presentation.
- Deliver a slide show presentation.
- Navigate a slide show in Presenter View.
- Use presentation tools.
- Preview and print handouts.
- Print speaker notes.
- Add headers and footers to notes and handouts.
- Format and print handouts to help the audience retain important information.
Explore TestOut Pro Certifications