Excel knowledge for Finance jobs?

[PRE]

[ QUOTE ]
[ QUOTE ]
I was just given an Excel test in an interview today. If you want I can try getting my hands on it for you. PM me

[/ QUOTE ]
Wow what did they ask you and what job were you interviewing for?

[/ QUOTE ]

I went into the interview thinking it was an Assistant Trader position for a prop trading firm, but they told me when I got there that it was for an Operations Trade Support position where you basically make the life of traders easier. Long story short, I decided to go through with it since I was already there and I ended up being there for close to 3 hours.

The test included 6 assignments (all on individual tabs of one Excel file). Each assignment comprised a few different tasks, from basic formatting to using functions to using macros. All in all, I thought it was pretty ridiculous. I didn't even know that I was being timed and they told me time was up when I was only half way through because I was taking my time doing crap like picking the right background color that it wanted. Even if you didn’t know how to do the stuff on the test, it was something that could be learned in less than two hours.