Skills inventory for Excel 2003: Intermediate

Use the following form to gauge students’ skill level entering the class (students have copies in the introductions of their student manuals). For each skill listed, have students rate their familiarity from 1 to 5, with five being the most familiar. Emphasize that this is not a test. Rather, it’s intended to provide students with an idea of where they’re starting from at the beginning of class. If a student is wholly unfamiliar with all the skills, he or she might not be ready for the class. A student who seems to understand every skill, on the other hand, might need to move on to the next course in the series.

Skill	1	2	3	4	5
Zooming in and out on a large worksheet
Freezing and unfreezing panes
Hiding and unhiding data, and creating outlines
Setting print titles and page breaks, and using Page Break Preview
Navigating, managing, and printing multiple worksheets
Creating 3-D formulas to link worksheets and workbooks
Adding a Watch window
Using the Consolidate command to summarize data
Linking workbooks, creating external links, and redirecting links
Changing View, General, and Calculation settings
Customizing toolbars and menus
Adding borders and shading to cells
Applying number, date, and time formats
Creating, modifying, and applying styles
Merging and splitting cells, and changing cell orientation
Sorting and filtering lists
Using advanced filtering options
Using advanced chart formatting options
Creating combination charts and trendlines
Inserting and formatting graphic elements	`
Using auditing features
Adding comments and text boxes
Protecting a worksheet
Using built-in templates, and creating and managing templates