Interview with a Recruiter

E

edmonton101

I have an excel test at an interview with a recruiter. I have been using
Excel for some time but need to know what kind of skills would the test
consist of. IF anyone has any relevant answers, please reply asap.
 
B

Bob Phillips

I have never taken nor given an Excel test, but I would suggest that if you
know about

- functions (SUMIF, MATCHG, INDEX, VLOOKUP, etc.)
- graphs
- pivot tables
- number formats (currency, percentage, etc.)
- conditional formatting
- data validation
- sorting
- filtering
- Excel options (manual./automatic calculation, etc.)

to a reasonable level you will be okay. Beyond that is getting more than
competent. If it is specifically for Excel you may need more and also VBA,
but remember, as with all interviews, try and wrest the initiative, when
given a lead, take it and offer your knowledge and skills, don't wait to be
asked.

Good luck.
 
G

Gary''s Student

excellent advise Bob. Better to show off what you know than to wait for the
interviewer to probe for areas of ignorance.
 
R

Rowan

I had to do an excel test with a recruiter about 7 years ago. One of the
things they tested was Scenarios - I remember because I had never used
them before and haven't used them since.

Also the test I did was an online program which asked you to perform a
task in Excel and then tracked your response. I found it responded
better to using the Menus e.g Edit>Copy rather than ctrl+c. As I said
that was some time ago so they may be more sophisticated now.

Good luck
Rowan
 
G

Govind

Hi,

My 2 cents. I recently did an excel test which measures productivity as
well. The productivity is more if you use more of keyboard shortcuts
instead of using Menus to navigate.

Regards

Govind.
 
Top