Office Pro Objectives
 

TestOut Office Pro Exam Objectives

The Office Pro exam covers the basics of Word, Excel, and PowerPoint.

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