=vlookup() and =index(match()) are very useful, too.

You could ask about them, too.

Maybe what their favorite excel based web sites are and if they ever visit the
MS Newsgroups--it might be a way of finding out if they can find a solution for
something that they've never seen.

Interview wrote:

I am about to interview a person tomorrow. The job rely heavily on usage of
excel and I am wondering what are the best way to check the candidates skill?

--

Dave Peterson