MS EXCEL INTERVIEW QUESTION



1. What are database functions e.g. what would be the difference Between SUM ( ) and DSUM ( )?
2. How are array functions useful?
3. What is the syntax for VLOOKUP ( ) / HLOOKUP ( ) function?
4. What functions can be used to lookup data on both the sides of
Criteria mentioned (INDEX ( ) / OFFSET (  ))
5. Name any error handling formulas included in Excel built in
6. What is difference between Find and search?
7. What is difference between Delete and Clear Contents?
8. What is difference between Substitute and Replace?
9. What is difference between Count and CountA?

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions