Advanced Excel Tests

TheNorthernTrain
TheNorthernTrain Posts: 1,049
edited August 2011 in The hub
Right in my quest to find a job I have got through to a stage in one of my applications where I have a 10 minute timed Advanced Excel Test.

The company running it is called Fast Path, has anybody ever done one of their tests? Or know what it is likely to be testing?

I would consider my self fairly good at using excel but only in terms of statistical analysis and on basic formulas but i'm going to hazard a guess that they will be testing on stuff like vlookups and the more complicated matters - i mean they do call it advanced I suppose. :roll:
MmmBop

Go big or go home.

Comments

  • not heard of Fast Path but vlook ups are easy. simplest way of doing them is using the function box & applying the logic of
    a) what am i trying to look up
    b) in what range am i trying to find it
    c) what column number is the result i want
    d) false

    just remember that in the range (b) what you're trying to look up (a) has to be in the first column of your range

    hope that helps/makes sense!!