Pre-Course Evaluation for Excel 4: Advanced Features

The following evaluation will assist in determining your current knowledge of the material presented in the following course. If you already know how to perform the specified operation using Microsoft Excel 2003, put an X in the Yes column next to that operation; otherwise put an X in the No column next to the operation. Once you have finished, count your yes and no answers. If you have answered yes to 90% of the questions, you can skip this class and move on to the next class.

OPERATION	YES	NO
Record and run a personal macro.
Record and run a workbook macro.
Edit a macro.
Add a macro button to a worksheet.
Open a new module in the Visual Basic Editor.
Display a data prompt during macro execution.
Use a conditional statement in a macro.
Use a control loop in a macro.
Place a combo box on a worksheet.
Place a check box on a worksheet.
Link a control to worksheet data.
Create a new toolbar.
Add a button to a toolbar.
Assign a macro to a toolbar button.
Create a new menu.
Add an item to a menu.
Assign a macro to a menu item.