I designed a spreadsheet to do these basic formulas, but what I wanted my
students to do was look at my spreadsheets and try assess what I was trying
to work out, so they fill in the formulas, get the right answer and the
spreadsheet immediately gives them an answer, works wonders for evaluating
new employees.

email me at and I will send you a copy.

"Dave" wrote:

What is a good source for some free tests (with answers) that can be used to
test someone's knowledge of excel which could include some basic use of
simple formulae (sum, average, etc) as well as some intermediate functions
(such as if functions) and pivot tables etc.

Thanks in advance