
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 11: How to split a string based on a delimiter?
Answer: We need a variable of variant data-type to hold the result. Then we can use ‘split’ command with a delimiter to split the sentence.
here delimiter is space ” “. After execution, values(0) will have value ‘this’ . alues(1) will have value ‘is’.values(3) will have value ‘sentense’
Answer: We need a variable of variant data-type to hold the result. Then we can use ‘split’ command with a delimiter to split the sentence.
Dim values as variant values =split( “this is a sentense”,” “)
here delimiter is space ” “. After execution, values(0) will have value ‘this’ . alues(1) will have value ‘is’.values(3) will have value ‘sentense’
Question 12: How to hide a worksheet so that somebody can’t unhide it?
Answer: We know that by setting ‘visible’ property of a sheet to true or false, we can hide an excel sheet. by Using Sheet’s visible property “xlSheetVeryHidden” we can hide it permanently . if we want to hide a sheet named “my_sheet”, please execute a vba code Sheets(“my_sheet”).Visible = xlSheetVeryHidden. it will super hide your worksheet of the workbook
Answer: We know that by setting ‘visible’ property of a sheet to true or false, we can hide an excel sheet. by Using Sheet’s visible property “xlSheetVeryHidden” we can hide it permanently . if we want to hide a sheet named “my_sheet”, please execute a vba code Sheets(“my_sheet”).Visible = xlSheetVeryHidden. it will super hide your worksheet of the workbook
Question 13: What is events in excel and give some sample events in excel?
Answer: Events are actions performed by users action or by other VBA code. ‘Event procedures’ are subroutines which are triggered at the time of events. Example of events will be ‘activating a sheet’, ‘closing a workbook’, ‘changing a value in cell’ ect. We can write macro which needs to run every time these event happens in excel
Answer: Events are actions performed by users action or by other VBA code. ‘Event procedures’ are subroutines which are triggered at the time of events. Example of events will be ‘activating a sheet’, ‘closing a workbook’, ‘changing a value in cell’ ect. We can write macro which needs to run every time these event happens in excel
Question 14: How to find last used row in excel sheet?
Answer: First we have to identify a column where there is no empty cell in the column.
range(Selection, Selection.End(xlToRight)).Select
range(Selection, Selection.End(xlDown)).Select
Answer: First we have to identify a column where there is no empty cell in the column.
- Then select any cell in the colum .
- Press down the’cntrl’ key
- And press ‘down arrow.
range(Selection, Selection.End(xlToRight)).Select
range(Selection, Selection.End(xlDown)).Select
Question 15: What are the different type of protection available in excel 2013?
Answer: Excel gives many kind of protection. We can protect the excel file itself from viewing using a password. Apart from this, we can protect each of the sheets from viewing or being edited we can protect sheets being edited by only certain persons. Other can do whatever they wanted. we can protect a row, column, cell being edited. we can protect our macro logic also from viewing by others using a password
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: Excel gives many kind of protection. We can protect the excel file itself from viewing using a password. Apart from this, we can protect each of the sheets from viewing or being edited we can protect sheets being edited by only certain persons. Other can do whatever they wanted. we can protect a row, column, cell being edited. we can protect our macro logic also from viewing by others using a 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.