MS Excel 2003 – Intermediate covers the areas that the average user of Excel should be able to perform.  The topics covered are working with workbooks, data manipulation, working with formulas and auto sum, formatting cells and more.  This test includes 15 interactive questions and allows 5 tries per question.  Test questions may be skipped and a review session is provided at the end of the test.  The score report will outline each question, whether it was correct or incorrect.  For any incorrect answer the test will provide study tips.

Test Outline:

Editing & Formatting

• Hiding Columns

• Wrapping Text

• Fill Series

• Formulas

• Centering Cells

• Moving Sheets

Printing

• Print Area

Analysis

• Functions
• Formulas
• Auto sum
• Charts

Tools & Automation

• Creating Range Name
• Protecting Cells
• Freezing Panes