Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Typical excel interviewing questions
I am about to interview a person tomorrow. The job rely heavily on usage of
excel and I am wondering what are the best way to check the candidates skill? |
#2
|
|||
|
|||
for starters...
ask him/her: what's an array formula? what is a pivot table used for? what does ctrl/enter do if 1 cell is selected? what's a userform? What's a relative reference? A mixed reference? An absolute reference? Why use these what does workbook protection do? how many sheets can a workbook hold by default; how many is the maximum? What happens if the first character you type is a forward slash (/)? "Interview" wrote in message ... I am about to interview a person tomorrow. The job rely heavily on usage of excel and I am wondering what are the best way to check the candidates skill? |
#3
|
|||
|
|||
Bob,
Good ones. As for the slash first character, it's only when it's specified in Tools - Options - Transition. It seems to me that if the OP (Interview) seriously wants to test the skill of the applicants, he should have them take a qualification test, or hire a good Excel person to do the interview. It's pretty lame to ask questions if the interviewer has no subject knowledge. -- Earl Kiosterud www.smokeylake.com "Bob Umlas" wrote in message ... for starters... ask him/her: what's an array formula? what is a pivot table used for? what does ctrl/enter do if 1 cell is selected? what's a userform? What's a relative reference? A mixed reference? An absolute reference? Why use these what does workbook protection do? how many sheets can a workbook hold by default; how many is the maximum? What happens if the first character you type is a forward slash (/)? "Interview" wrote in message ... I am about to interview a person tomorrow. The job rely heavily on usage of excel and I am wondering what are the best way to check the candidates skill? |
#4
|
|||
|
|||
=vlookup() and =index(match()) are very useful, too.
You could ask about them, too. Maybe what their favorite excel based web sites are and if they ever visit the MS Newsgroups--it might be a way of finding out if they can find a solution for something that they've never seen. Interview wrote: I am about to interview a person tomorrow. The job rely heavily on usage of excel and I am wondering what are the best way to check the candidates skill? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
what book do you recomende for formulas & advance excel questions | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
SPAM in Excel General Questions | Excel Discussion (Misc queries) |