CPE Study Guide

Suggested Study by Topic

BASICS

Creating, modifying, saving, and printing a document

EDITING

  • Spelling check
  • Insert page number
  • Insert special character
  • Insert date/time
  • Insert page and section break
  • Use word count
  • Use Equation editor

FORMATTING

  • Formatting text
  • Formatting paragraph
  • Formatting document
  • Bullet and numbered list
  • Adding border and shading
  • Working with tabs
  • Header and footer
  • Set margins
  • Multiple columns
  • Create and work with Styles
  • Insert a Table of Contents
  • Insert and work with hyperlinks

WORKING WITH TABLES

  • Creating and formatting a table
  • Moving and positioning a table
  • Create table from existing text

WORKING WITH GRAPHICS

  • Inserting and resizing an image
  • Wrap text around an image
  • Creating WordArt
  • Save document as a web page

BASICS

  • Enter data
  • Enter labels
  • Copy
  • Paste
  • Paste Special
  • Working with multiple sheets

DATA MANIPULATION

  • Formulas
  • Entering fomulas
  • Copy a formula with relative and absolute cell references
  • Calculation with dates

Functions

  • Financial: PMT, FV
  • Statistical: Average, Max, Min, Count, CountA
  • Logical: IF
  • Date/Time: NOW

Sort and Filtering

  • Sorting with multiple fields
  • Filtering with AND and OR conditions
  • Subtotaling data

FORMATTING

  • Row height and column width
  • Format cells
  • Freeze column/rows when viewing
  • Repeat print column/rows

CHARTS

  • Create chart: Pie, Line, Bar, Column

BASICS

  • Create a presentation
  • Inserting, deleting, and moving slides
  • Applying a design template
  • Formatting text (color, alignment, bullets, etc.)
  • Working with ClipArt
  • Insert an animation
  • Insert a sound clip
  • Inserting, arranging, formatting objects on a slide

SLIDE MASTER

  • Create a new slide master
  • Formatting the slide master
  • Applying the slide master

SLIDE SHOWS

  • Applying slide transactions
  • Applying animation schemes
  • Animating objects
  • Timing the slide show
  • Creating and printing speaker notes

BASICS

  • Creating a database
  • Creating a table
  • Inserting data
  • Viewing database, table, data from different views

TABLES AND RECORDS

  • Modifying table field properties
  • Inserting, modifying, deleting, and finding records
  • Sorting records
  • Filtering records by selection
  • Previewing and printing table data

TABLE RELATIONSHIPS

  • Assign primary key
  • Assign primary key with multiple fields
  • Creating and modifying relationships

QUERY (Query by Example)

  • Creating, saving, and running a query
  • Creating a query with multiple tables
  • Creating and formatting a calculated field
  • Using functions in query expressions

FORMS AND REPORTS

  • Creating a form using a wizard
  • Modify form controls
  • Setting form properties
  • Creating a report using a wizard
  • Adding sorting and grouping levels
  • Adding a calculated control to a report
  • Adding a control to calculate total