Interview with a Recruiter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
excellent advise Bob. Better to show off what you know than to wait for the
interviewer to probe for areas of ignorance.
 
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
 
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.
 
Hi Govind,

That is an interesting comment. I would think that is so subjective. Person
ally I am shortcuts person, but I always thought it was because I was
brought up in pre-GUI days, my younger colleagues are far more
mouse-oriented.

Regards

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top