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
Restrict cell entries to specific numbers, dates or times.
Restrict cell entries to specific entries in a list.
Create a custom number format.
Apply conditional formatting to a worksheet.
Define a range name.
Use a range name in a formula.
Use the VLOOKUP, HLOOKUP, DSUM and DAVERAGE functions.
Create a new workbook template.
Edit a workbook template.
Add subtotals to worksheet data.
Group and outline data.
Track changes in a workbook.
Respond to proposed changes and comments in a workbook.
Protect a shared workbook and an unshared workbook.
Apply workbook security settings.
Modify default settings.