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
- 137351 reads
Name as many ways as you can to make Excel calculate something
Unless the answer isn't every function from absolute to year (is there a Z?), pivot tables, recorded Macros, VBA etc I'm not sure what the question is asking. Can you expand?
Excel Calculation
ok, I'll start u off with some easy ones:
... there are tonnes... the question is really to see how deep your understanding of Excel is
For example... would you know that when you have the formula entry screen up, tabbing through the arguments will cause a calculation of the function to occur.
Would u know that double clicking on a column heading can cause several types of calculation to occur...?
etc...
Not well known
Application.Evaluate()
Worksheet.Evaluate()
will both evaluate a statement you pass in as if it were a formula
Application.Volatile
Application.Volatile
Another one
Application.Calculation = xlCalculationAutomatic
Application.Calculate
Excel Calculation
6. shift + F9
7. F2 a cell then enter
1. Dates
Name as many Date functions as you can in both Excel and VBA.
Date & Time Date (VBA) Date
Date & Time Date (VBA) Date function returns the current system date. Th...
Date & Time DateAdd (VBA) DateAdd function returns a date after which a cert...
Date & Time DateDif DateDif function returns the difference between tw...
Date & Time DateDiff (VBA) DateDiff function returns the difference between t...
Date & Time DatePart (VBA) DatePart function returns a specified part of a gi...
Date & Time DateSerial (VBA) DateSerial function returns a date given a year, m...
Date & Time DateValue DateValue function returns the serial number of a ...
Date & Time Day Day function returns the day of the month (a numbe...
Date & Time Days360 Days360 function returns the number of days betwee...
Date & Time Hour Hour function returns the hour of a time value (fr...
Date & Time Minute Minute function returns the minute of a time value...
Date & Time Month Month function returns the month (a number from 1 ...
Date & Time MonthName (VBA) MonthName function returns a string representing t...
Date & Time Now Now function returns the current system date and t...
Date & Time Second Second function returns the second of a time value...
Date & Time Time Time function returns the decimal number for a par...
Date & Time TimeSerial (VBA) TimeSerial function returns a time given an hour, ...
Date & Time TimeValue TimeValue function returns the serial number of a ...
Date & Time Today Today function returns the current system date. Th...
Date & Time Weekday Weekday function returns a number representing the...
Date & Time WeekdayName (VBA) WeekdayName function returns a string representing...
Date & Time Year Year function returns a four-digit year (a number ...
Date function for VBA and Excel
Date, Date Value, day, days360, today,weekday,year
to add more: month, datedif,
to add more:
month, datedif, datediff