
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 16: What is option base in vba 2013?
Answer: by default arrays declared in VBA starts from 0. If you want to change the lower limit of an array to 1, we can use this ‘option base’ feature. This is applied on module level. This statement must appear in a module before any procedures. Option Base can appear only once in a module and must precede array declarations that include dimension
Question 17: How to return multiple values in vba function?
Answer: Functions can return only one variable.So if we want to return multiple values of same type , we have to use an array. Each array location can hold one value. The problem with array is it can hold only kind of data type. If we want to transfer multiple data types, we have to define A ‘user defined’ datatype which can hold all types of values which we want and pass this ‘user defined’ datatype back to the caller
Answer: Functions can return only one variable.So if we want to return multiple values of same type , we have to use an array. Each array location can hold one value. The problem with array is it can hold only kind of data type. If we want to transfer multiple data types, we have to define A ‘user defined’ datatype which can hold all types of values which we want and pass this ‘user defined’ datatype back to the caller
Question 18: How to recalculate all formula once values are updated?
Answer: If an excel workbook is not set for ‘automatic recalculation” we have to recalculate formula once cell value is updated. F9 is used to recalculate all the formula in the excel workbook and SHIFT +F to recalculate formula only for the active sheet
Answer: If an excel workbook is not set for ‘automatic recalculation” we have to recalculate formula once cell value is updated. F9 is used to recalculate all the formula in the excel workbook and SHIFT +F to recalculate formula only for the active sheet
Question 19: What is excel object model?
Answer: BY excel object model , we refer the hierarchy of excel objects.excel object based on hierarchy is mentioned below
Answer: BY excel object model , we refer the hierarchy of excel objects.excel object based on hierarchy is mentioned below
- excel application object
- excel workbook object
- excel sheet object
- exccel range object
- excel row and column object
- excel cell object
- cell property oblect
Question 20: How to manipulate a protected sheet using VBA?
Answer: If a sheet is protected we can’t manipulate the sheet with VBA. In order to do that , you have to first un protect the sheet using a VBA command, do manipulation as required, then protect the sheet with same password.
Microsoft Excel Interview Questions Series
- Microsoft Excel Interview Questions Series - Part 1 [Interview Question]
- Microsoft Excel Interview Questions Series - Part 2 [Interview Question]
- Microsoft Excel Interview Questions Series - Part 3 [Interview Question]
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.