Skip Navigation

Pre-Training Assessment for Excel 3

This assessment tool is for your own use, to help you determine if you have mastered the skills needed to participate successfully in Excel 3.

In addition to the skills needed for Excel 1 and 2, I know how to:

automatically fill many cells with identical contents	Yes	No	Not sure
automatically fill many cells with a series of numbers	Yes	No	Not sure
enter a formula in a cell	Yes	No	Not sure
use AutoSum to total a column of numbers	Yes	No	Not sure
copy a formula from one cell to another so that the formula's cell references change relative to the destination (known as "relative referencing")	Yes	No	Not sure
copy a formula, keeping the cell references the same at the destination (known as "absolute refrencing")	Yes	No	Not sure
split the Excel screen, vertically and horizontally	Yes	No	Not sure
freeze and unfreeze the panes of a split screen	Yes	No	Not sure
hide and unhide rows and columns	Yes	No	Not sure
group and outline a set of rows or columns	Yes	No	Not sure
remove a group of cells from an outline	Yes	No	Not sure
hide and restore outlined cells	Yes	No	Not sure

In Excel 3, we assume that you have mastered key concepts covered in Excel 1 and 2. We want you to use your time effectively, and to get the most out of each course you take.

If you answered "No" or "Not sure" to more than a few of the above questions, consider one or more of the following:

re-take CAL PACT's "Excel 1" and "Excel 2" courses
review the documentation and notes from "Excel 1" and "Excel 2"
use your Excel manual or online help files to learn more
ask someone to show you how to perform these operations

For more information about CAL PACT, send email to calpact@berkeley.edu.
URL: http://calpact.berkeley.edu /info/assessments/excel3.html , page modified: Monday, 25-Jun-2007 09:23:48 PDT