I prefer "in".
If someone says to me
You should do well in the test, my immediate interpretation is that the speaker considers I have studied well enough. He could say
You will do well, but nobody is ever sure.
Also interpretable as advisability, but here I'd be inclined to put it more strongly:
You must do well in the test.