First test numerical (easy) and finance (you have plenty of time that you can also look for answers on-line). Then excel test that was easy, questions:
1) Format all columns titles in Bold
2) Format cell A2 so that the date appears as "23 June 2008"
3) In column F calculate market cap (formula given)
4) Use functions to calculate cells D2-D5 (formulas given)
5) Correct the function in D6 (Standard deviation formula)
6) calculate the weight of each company (formula give)
7) Conditional formatting short task
7) increase to decimals
8)Freeze panes
9) sort the columns by industry and the price (highest price on top), to do with filters.
10) Vlookup function
11) create a chart
I mean the test is easy but I think they correct it quickly and wrong. I did it in 20 mins because was easy for me but they told me that was not completely correct (you have to reach 70%).
They did not even reply after the test, ridiculous.