I took an eval test on Excel that I got 3 things wrong. One I had the definition backwards (ascend as compared to descend) so I think that one was fair, but the only way to "pass" a question was to do the task as the computer would accept the answer. Two of the tasks I knew 2-3 ways to do them, but on this version of Excel, there obviously was a 1 or 2-click way to do it, but I couldn't find it.
I thought the test was bogus because it tested your ability to know a specific software shortcut and not know how to complete the given task.