Microsoft Excel 2013 is one of the most powerful tools in office 2013 and a candidate having an overall awareness of excel 2013 is definitely a boon to a busy office. The questions on this section are written from the eyes of an interviews who want candidate with an overall awareness.
Question 2: If Macro is for automating repeating jobs in excel, what is VBA?
If you are preparing for an interview, it is advised to go through all questions and practical questions. Based on your current skill level you don’t even need to try simple questions. But there will be all kind of questions presented here.
Each article on Microsoft Excel Interview Questions Series contains 5 questions and its explanations. Some of them are just theory questions and some of them may be like a logical question. That needs to be implemented in real time. Questions from all areas of excel 2013 like formulas, VBA, macros, charts, templates; dashboards are covered here and tried to group by same nature. Sometimes questions are intermixed and no specific order is followed.
Question 1: What macros are in excel?
Answer: Macros are a set of instruction to excel to implement certain logic which may take lot of time if we do it manually. Macros can be used to execute repeating jobs without any manual intervention. Macros are written using a language called VBA. All the works that we do it manually in excel can also be performed using a macro.
Question 2: If Macro is for automating repeating jobs in excel, what is VBA?
Answer: VBA is the language used for writing macros and macros are a set of VBA instructions capable of executing some job. Though both are interconnected they are different.
Question 3: How to write an excel formula into a cell using VBA. Is it possible?
Answer: Yes. Using VBA we can write formulas into an excel cell and the formula will start function immediately after the VBA code execution.
Below VBA code implement a formula into selected cell:
Complex formulas also can be implemented in the same manner. i.e convert the formula to a string and assign it to active cell.
Answer: Yes. Using VBA we can write formulas into an excel cell and the formula will start function immediately after the VBA code execution.
Below VBA code implement a formula into selected cell:
Sub Insert_formula() Dim frmla as string frmla = “=SUM(R2C10:R20C10)” ActiveCell.FormulaR1C1 = frmla End sub
Complex formulas also can be implemented in the same manner. i.e convert the formula to a string and assign it to active cell.
Question 4: What is Option explicit? Why is it required.
Answer: “Option explicit” is a keyword used in VBA coding on top of module file. This keyword forces mandatory declaration of variables while writing macros. Writing Option explicit is a good practice since it ensures variables and data types are predefined.
Answer: “Option explicit” is a keyword used in VBA coding on top of module file. This keyword forces mandatory declaration of variables while writing macros. Writing Option explicit is a good practice since it ensures variables and data types are predefined.
Question 5: Where we write VBA code and how to debug a VBA code.
Answer: VBA is written in VBA editor of excel. VBA editor can be activated by pressing F11. If we want to execute the code step by step, we can use F8. We can debug VBA code using break points and F5. This will execute a piece of code continuously and stops at the break point. Values of the variable while debugging can be displayed in the “immediate” window of the vba editor.
Microsoft Excel Interview Questions Series
NOTE: If you have any doubt in any question feel free to comment, if you like these questions please share with your friend and if you have any question that we need to be consider in our question series, share with us.
Answer: VBA is written in VBA editor of excel. VBA editor can be activated by pressing F11. If we want to execute the code step by step, we can use F8. We can debug VBA code using break points and F5. This will execute a piece of code continuously and stops at the break point. Values of the variable while debugging can be displayed in the “immediate” window of the vba editor.
Microsoft Excel Interview Questions Series
- Microsoft Excel Interview Questions Series - Part 1 [Interview Question]
- Microsoft Excel Interview Questions Series - Part 2 [Interview Question]
- Top 10 Excel Interview Questions for Job Seekers
NOTE: If you have any doubt in any question feel free to comment, if you like these questions please share with your friend and if you have any question that we need to be consider in our question series, share with us.
