Excel exam prep
The links below will help you to prepare for the Excel exam. Each one will open in a new window.

The exam is very similar to the practice exam. Review the steps in the practice exam to get a feel for the real thing.

Most of the mistakes that I have seen are not related to Excel skills. You have done a good job learning how to use the program. Instead, they are related to direction following. Often points are lost because the font wasn't changed or uppercase and bold text was forgotten. Take your time on the exam and review each instruction to make sure that you complete the task.

How to create formulas in Excel

How to use the average function.

Format numbers as currency.

Wrapping text.

Sorting data.

Align text- vertically.

Align text- horizontally.

Hiding columns.

How to use Autofit.

Simple filtering.

Filtering a range of text.

Filter for more than piece of data.

Print gridlines.

Print row and column headings.