MIS Interview Tips for Excel/VBA/Access/SQL
By eXceLiTems
50 MS Excel VBA Interview Questions
You may already have seen it or may be still looking for it, here I tried creating a space where you can see consolidated view of excel and VBA questions generally asked in Interview. You may add your own questions and answers too in the comment section to help others.
Ques 01. What is the difference between ByVal and ByRef and which is default ?
Ques 02. What is the meaning of Option Explicit and Option Base?
Ques 03. What are various data type and their size?
Ques 04. Difference between ActiveWorkbook and ThisWorkbook.
Ques 05. Code to find a Last used Row in a column or Last used column of a Row.
Ques 06. Difference between ActiveX and Form Controls.
Ques 07. What is the difference b/w Functions and Subroutines?
Ques 08. How to debug a VBA code?
Ques 09. Draw basic Excel Object Model.
Ques 10. What are properties, methods, events and objects?
Ques 11. How to hide a worksheet so that a user cannot unhide it?
Ques 12. Union is used for _____________ ?
Ques 13. Which are the 2 macro languages and which do you use ?
Ques 14. Can you lock cells such that only specific users can modify them?
Ques 15. How can you add a drop-down list to a cell so the user can choose a value from the list?
Ques 16. How can you increase the number of rows in a worksheet?
Ques 17. How can you increase the number of columns in a worksheet?
Ques. 18. How will you distribute a workbook such that it can't be copied using macro or anything?
Ques 19. Your colleague created a dashboard and when you enter a value, it appears with two decimal places. For example, when you enter 265 it shows up as 2.65. What's wrong?
Ques 20. How can you prevent a user for adding or deleting sheets?
Ques 21. What types of workbook protection are available?
Ques 22. The Font dialog box allows you to select different Fonts, their style, their size, and some other special effects. How do you bring up this Font dialog box?
Ques 23. What is ADO, OLEDB & ODBC?
Ques 24. How to set the custom paper size in Excel Object through VB?
Ques 25. What is the method for returning more than one values from a function in VB?
To view the answers click here --> 50 Excel VBA Oral Interview Questions
Excel Items
- How to use MS Excel Macro Recorder ?
What is a macro? A macro is a set of computer instructions that you can record and associate with a shortcut key combination or a macro name. Then, when you press the shortcut key combination or... - 4 months ago
- MS Excel & VBA: Contact for Corporate Trainings
What makes us one of the best Corporate Excel Trainer? 1. Our Course Content (as given below) 2. Microsoft Certified Professionals / Microsoft awarded "Most Valuable Professional" 3. Training... - 8 months ago
- We need Work ! We want to help you ! Let's Connect :)
- Do you have work and running short of time? - Looking for expertise in the dashboard automation, Excel, Report making or any Excel/VBA work? - Looking for some affordable... - 8 months ago
- 15 Essential MS Excel VBA Puzzles for Interview
Thanks for the humongous response to our 50 Excel VBA Oral Interview questions and 3 Things to remember before you go for an Excel Interview. This really motivated us to bring this article for you.... - 8 months ago
- Relative and Absolute References in Excel Formulas
When the reference is made to the Absolut Vodka, it's called absolute reference and when the reference is made to some family member, it's called Relative reference.. Hahhahaa...Just kidding..On... - 8 months ago
- Online MS Excel Training: Quicker Excel
For Whom? This MS Excel training is not for beginners, professional or expert users but for all EXCEL users. What is it? This will not teach you MS Excel but take you one-level up. How can I... - 8 months ago
- Split the Text with Newline Characters (Alt + Enter)
Splitting the text is a common problem though the kind of split and degree of split may vary problem to problem. There are several ways to solve the split problem depending upon the problem like... - 8 months ago
- Monthly Calendar Planner Template
Tonight, I tried my hands on calendars and planners and sure, I come up with an elegant calendar which can be used as planner too but agree many of you won't consider it as a perfect one. So, I'll... - 10 months ago
Comments
No comments yet.
