Office Pro

Certification Objectives
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 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

Copyright © 2023 TestOut Corp. Copyright © CompTIA, Inc. All rights reserved.

| Privacy Policy | Accessibility | License Agreement

Microsoft, MCA, Office, Excel, Word, and Windows are the trademarks of Microsoft. Cisco and CCNA are the trademarks of Cisco. Certified Ethical Hacker and CEH are the trademarks of the EC-Council. Neither TestOut nor CompTIA have any affiliation with any of these companies, and the products and services advertised herein are not endorsed by any of them.