Pre-Course Evaluation for Excel 2: Formatting and Functions

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
Realign cell entries.
Reset font options for cell entries.
Reset the number format of cell entries.
Add a border and shading to a worksheet.
Change the page setup for a worksheet.
Preview a worksheet.
Insert a manual page break into a worksheet.
Print selected worksheet entries.
Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT).
Find and replace a specific entry in a worksheet.
Create and apply a style.
Use options in the Paste Special dialog box.
Use alignment options in the Format Cells dialog box.
Enter an absolute cell reference into a formula.
Use the IF function.
Enter an absolute column or absolute row cell reference into a formula.