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