![]() It is a function which allows to put multiple IF functions inside and allows to evaluate multiple criteria and returns the outcomes. It is a function which horizontally lookups and gets the relative data from a table or range. It is a function which vertically lookups and gets the relative data from a table or range.ġ4. It returns a value from a range or array.ġ3. It is a lookup function in excel which searches for a value in an array and returns a relative position.ġ2. It returns a value from a range at a given position. What is the shortcut to reference the cell? What’s the shortcut to split the excel sheet?ĩ. What’s the shortcut of Paste Special Values?Ĩ. It allows to colour the cells, based upon conditions.ħ. Sum if, sums the values based upon criteria and count if counts the values based on criteria. What’s the difference between sum if and count if? What is the way to count a string in excel?ĥ. It is an application to use for calculation, visualization and analytics.Ģ. So learn VBA with the help of this VBA (Visual Basic for Applications) Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any VBA (Visual Basic for Applications) Interview Question or answer by the comment feature available on the page. VBA Frequently Asked Questions in various VBA (Visual Basic for Applications) Interviews asked by the interviewer.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |