Nick's guide to Excel / VBA Interview Questions
I have hosted hundreds of Excel / VBA interviews, and I can work out very quickly how good someone is.
The biggest blunder to make in an interview is to say something like: "Oh, that's easy, I can do that in 5 minutes with the compiler and help files"
Well, in my interview, you have no compiler and no help files, so don't ignore syntax, or rely too much on help files.
You wouldn't turn up to a French interview with a dictionary and translate every word now would you ?
; - >
Here are some Excel VBA interview questions I might ask you.. Add a comment if you think you have a good answer.
»
- Nick's blog
- Login or register to post comments
- 131456 reads
Ans 5
Nop
Ans 5
why ?
Ans 5
there's a small oversight in the references
VLOOKUP(C2,E2:F8,2,0)
VLOOKUP(C2,E2:F8,2,0)
It would say this was wrong...
i think its
VLOOKUP(C2,E3:F8,2,false)
that is E3 instead of E2
4. Excel function
Write an Excel function that calculates the first day of the current month
The first day of the current month right now is: 01-Jan-2009
Ans: 4. Excel function
=TEXT(WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW()),1)),"DDDD")
or
=TEXT(WEEKDAY(DATE(YEAR(Today()),MONTH(Today()),1)),"DDDD")
or
=TEXT(WEEKDAY((MONTH(Today())&"/1/"&YEAR(today()))*1),"DDDD")
or
=TEXT(WEEKDAY(DATE(YEAR(a1),MONTH(a1),1)),"DDDD")
or
=TEXT(WEEKDAY((MONTH(A1)&"/1/"&YEAR(A1))*1),"DDDD")
-Boss (a) Bhaskar-
Ans 4 or may be this
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))-DAY(TODAY()-1),"dddd")
=TEXT(WEEKDAY(A1),"dddd
=TEXT(WEEKDAY(A1),"dddd").
Enter your date in cell A1.
=TEXT (MONTH (TEXT (TODAY(),"MM"
=TEXT(MONTH(TEXT(TODAY(),"MM")),"DDDD")