Exam Topics

Important Details:

• The exam uses Excel 2007
• The exam is for people who have already learned Excel 2007
• The "Help" feature will not be available

The exam covers the following topics or features:

• Apply Number Formatting
• Apply Font & Alignment Formatting
• Sorting data (multi-level sorts)
• Copy a Chart Move Data, Add Borders, Rotate Text
• Move, Copy, Paste cell contents
• Display & Print Formulas
• Scale a Worksheet for Printing – fit-to-page; print a single page
• Use of common Functions (SUM, IF, COUNTIF, AVERAGE, VLOOKUP)
• Create & Sort a Table of data
• Convert a Table to a range of data
• Using a Custom AutoFilter with a Table
• Subtotal of data in a List of Data and in a Table
• Importing a Text File
• Create a Two-Variable Data Table
• Identify & Remove Duplicate Rows
• Apply Conditional Formatting, using Custom Formats & Data bars
• Insert, Move, Name, a Rename a Worksheet
• Copy Formulas
• Insert Columns & Insert Rows
• Freeze & Unfreeze panes
• Display multiple worksheets and workbooks in the same window
• Insert a Comment
• Use of Range Names (Named ranges)