CPE Study Guide

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