Excel Test or Exams

[the_crooked_toe]

My company is looking for an excel exam to test people coming into a new position. I am looking for a test that a user would only have to know formulas and not VBA. Some sort of test where someone with a little above average knowledge of Excel could do moderatly easy.

if anyone has any tests or website links to download some tests it would be greatly appreciated.

 

[the_crooked_toe]

bump

 

[the_crooked_toe]

bump

 

[NateO]

You bumped your thread after a whopping 8 minutes?

I might think 24 hours might be a little more reasonable, you couldn't have been off the first page by then in this forum...

Intermediate could mean a wild host of things to anyone, I would think most intermediate users would have some working knowledge of VBA, while it may be limited...

In any event, here's Aaron Blood's scale:

http://www.xl-logic.com/user_scale.html

Perhaps you can use those specs to create a test from there.

 

[NateO]

Here's DK's VBA test, while I realize it's not what you're looking for:

http://www.mrexcel.com/board2/viewtopic.php?t=119631

I'd hate to see Ivan's test!!

 

[fairwinds]

FWIW

Here is one test I did not agree to take the other day

http://www.mrexcel.com/board2/viewtopic.php?t=221304&highlight=

 

[XLGibbs]

FWIW

Here is one test I did not agree to take the other day

http://www.mrexcel.com/board2/viewtopic.php?t=221304&highlight=

LOL.Kind of obvious that one.

 

[Elerner]

Reading the one guys opinion on someones level of excel usage, he mentioned able to make your own functions. How do you make a new function in excel?

 

[NateO]

Hello,

There's a couple of ways, actually. Here are two:

1) Create a VBA UDF (User Defined Function). E.g.,

http://www.mrexcel.com/board2/viewtopic.php?p=1071649#1071649

You can call this in a cell as such: =rndLong(6)

2) Another way is to create c-code in an XLL add-in, such as Laurent Longre's Morefunc.xll

Hope this helps.

 

[Elerner]

Haha, thanks a lot. That seems a little complicated for me right now. Only recently have I been using more "advanced" (not really advanced) functions in excel. Hopefully one day I learn how to do that.

Have a good day!