Hi Chandoo ,
I think I can give one reason. And before I give the reason , let me admit that I got 61 %.
The reason I got 3 questions wrong is because I did not check all the correct answers in the 3 questions which had multiple answers ; I think this is unfair. This is like asking a person whether they know the route from city A to city B , and then penalising them for not giving all the possible routes !
Excel for most of us is a tool ; just as a dictionary is a tool. I don't think even the greatest wordsmith around would know all the words in the dictionary or would at all have used all the words in the dictionary.
I agree that if there is more than one way of doing things , one should know when each of the methods is applicable , which are the situations where each one of them would fail , and which one is most efficient ; but I am sure that most of us would never touch the limitations of Excel unless our job requires us to do something which throws up such a situation.
It would be nice if you could come up with practical problems , give the required answer , and then ask people attempting the quiz to give the names of functions they used to arrive at the answer.
I suggest that each of us tries to come up with good questions , and mails them to you ; probably a month from now , we can have a follow-up quiz.
Narayan