{"id":100470,"date":"2021-10-11T09:00:12","date_gmt":"2021-10-11T03:30:12","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=100470"},"modified":"2021-10-11T10:01:42","modified_gmt":"2021-10-11T04:31:42","slug":"ms-excel-interview-questions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/","title":{"rendered":"MS Excel Interview Questions"},"content":{"rendered":"<p>Following are the most important Excel interview questions that an interviewer might ask. These questions and answers would widely help the candidate to prepare for the interview.<\/p>\n<h3>MS Excel Interview Questions for Beginners<\/h3>\n<p><strong>1.Write a dynamic VBA program to check if a number is a prime number ?<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Sub Button1_Click()\r\nDim div As Integer, num As Integer, i As Integer\r\ndiv = 0\r\nnum = InputBox(\"Enter a number\")\r\nFor i = 1 To num\r\nIf num Mod i = 0 Then\r\n    div = div + 1\r\nEnd If\r\nNext i\r\nIf div = 2 Then\r\n    MsgBox num &amp; \" is a prime number \"\r\nElse\r\n    MsgBox num &amp; \" is not a prime number\"\r\nEnd If\r\nEnd Sub\r\n<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/prime-number.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102229\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/prime-number.png\" alt=\"prime number in excel\" width=\"951\" height=\"501\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/prime-number.png 951w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/prime-number-768x405.png 768w\" sizes=\"auto, (max-width: 951px) 100vw, 951px\" \/><\/a><\/p>\n<p><strong>2. Are there any possibilities to split column data?<\/strong><\/p>\n<p>Yes, we can split the column data into two or more columns. In order to do that click on the cell that you want to split, go to the Text to Columns option under the data tab. After that choose the delimiter options as required. Finally select the column data format and choose the destination to display the split. The final output will appear as a result, separated into multiple columns.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delimiter.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102230\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delimiter.png\" alt=\"excel delimiter\" width=\"1920\" height=\"994\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delimiter.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delimiter-768x398.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delimiter-1536x795.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/other.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102231\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/other.png\" alt=\"delimiter\" width=\"1920\" height=\"970\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/other.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/other-768x388.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/other-1536x776.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delim-op.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102232\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delim-op.png\" alt=\"delimiter output\" width=\"1920\" height=\"989\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delim-op.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delim-op-768x396.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/delim-op-1536x791.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>3. What are the alternative ways to perform calculations other than writing the calculations in a cell?<\/strong><\/p>\n<p><strong>The alternative ways to perform calculations are:<\/strong><\/p>\n<ul>\n<li>AutoSum Function &#8211; In autosum function, the calculation is performed automatically after the user selects the cells on which the calculation has to be done.<\/li>\n<li>Insert Function &#8211; The insert function pops up with a dialog box where we can type the operation name and find it. After choosing the function, we can perform it on the cells in the worksheet.<\/li>\n<li>Formulae from the group &#8211; There are various groups such as Logical, Math &amp; Trig etc in Excel. We can pick a formula from the related group and work with it.<\/li>\n<\/ul>\n<p><strong>4. How to set up the input message in MS-Excel?<\/strong><\/p>\n<p><strong>Setting up the Input message:<\/strong><\/p>\n<p>a. Select the cell and click on the data validation.<\/p>\n<p>b. Go to the input message tab in the box.<\/p>\n<p>c. Fill the title and message as per the requirement and convenience.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-msg.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102233\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-msg.png\" alt=\"input message\" width=\"956\" height=\"499\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-msg.png 956w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-msg-768x401.png 768w\" sizes=\"auto, (max-width: 956px) 100vw, 956px\" \/><\/a><\/p>\n<p>d. Then, press the OK button.<\/p>\n<p>Finally, when you place the cursor on the data validation applied cell, the message will appear in a box as information.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-op.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102234\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-op.png\" alt=\"output\" width=\"1920\" height=\"848\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-op.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-op-768x339.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ip-op-1536x678.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>5. How to set up the custom data validation?<\/strong><\/p>\n<p><strong>Custom Data Validation:<\/strong><br \/>\nThe user can set up the formula as per the requirement and this is known as custom data validation. To set up the custom data validation, click on the data validation option from the drop down under the data tab. Pick the custom as criteria. A window pane appears with the data asking for the formula, type the formula and press the ok button.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/custom-dv.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102235\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/custom-dv.png\" alt=\"custom data validation\" width=\"954\" height=\"496\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/custom-dv.png 954w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/custom-dv-768x399.png 768w\" sizes=\"auto, (max-width: 954px) 100vw, 954px\" \/><\/a><\/p>\n<p><strong>6. Can we circle the invalid data after applying data validation?<\/strong><\/p>\n<p>To circle the invalid data, first enter the dataset, and then after entering the dataset apply the data validation as per the requirement after that click on the data tab and choose the circle invalid data from the ribbon.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/circle-invalid.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102236\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/circle-invalid.png\" alt=\"circle invalid\" width=\"956\" height=\"497\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/circle-invalid.png 956w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/circle-invalid-768x399.png 768w\" sizes=\"auto, (max-width: 956px) 100vw, 956px\" \/><\/a><\/p>\n<p><strong>7. Data validation function is one of the best and most effective functions available in excel but there is also a situation where it does not perform its action. Could you tell when it goes ineffective?<\/strong><\/p>\n<p>Data validation helps the user in setting the rule for the cells in the spreadsheet, not just that it also helps in controlling the value that is being entered in the cell. But there is a scenario where data validation does not apply and that is when the data are replaced on the existing data validated cells and the validation will not be applied if the cells are copied and pasted.<\/p>\n<p><strong>8. What do you know about the wildcards and are they available in excel?<\/strong><\/p>\n<p>Yes,wildcards are available in excel and the wildcards in excel works only on the text data in the sheet. Excel has three main wildcards and they are \u201c *, ?, ~\u201d .<\/p>\n<p>Asterisk(*): This symbol refers to any number of characters.<\/p>\n<p>Question Mark(?): This symbol refers to one single character in the sheet.<\/p>\n<p>Tilde(~): This symbol helps in identifying a wildcard character such as \u201c *, ?, ~\u201d in the text.<\/p>\n<p><strong>9. What are the steps to ungroup the dataset in Excel?<\/strong><\/p>\n<p>To ungroup the dataset in excel click on the ungroup option under the data tab and from there we can choose either its row or column.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ungrp.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102237\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ungrp.png\" alt=\"ungroup in excel\" width=\"957\" height=\"496\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ungrp.png 957w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/ungrp-768x398.png 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/a><\/p>\n<p><strong>10. How does a Slicer work in Excel?<\/strong><\/p>\n<p>We use slicers to filter the data in a pivot table. In order to create a slicer, we have to click on the Design tab, and select Insert Slicer. Then, choose the list of fields for which we want to create slicers.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/insert-slicer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102238\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/insert-slicer.png\" alt=\"insert slicer in excel\" width=\"1920\" height=\"991\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/insert-slicer.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/insert-slicer-768x396.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/insert-slicer-1536x793.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p>In the below example, we have chosen two labels for the slicers. Hence two slicers appear to filter the pivot table.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/apple-slicer.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102239\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/apple-slicer.png\" alt=\"apple slicer in excel\" width=\"1920\" height=\"848\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/apple-slicer.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/apple-slicer-768x339.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/apple-slicer-1536x678.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h3>Intermediate Excel interview Questions and Answers<\/h3>\n<p><strong>11. What are the steps to customise the auto fill list?<\/strong><\/p>\n<p>The steps to follow are-<\/p>\n<p>1- To customise autofill, click on the options under the file tab and select the advanced options.<\/p>\n<p>2- Under the heading of general, go to edit the custom list option and a box appears, where we can enter the new list.<\/p>\n<p>3- After updating the list, click on the add button, then the list will be updated in the custom list and it can be accessed in the sheet from then on.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/edit-custom.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102240\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/edit-custom.png\" alt=\"edit custom in excel\" width=\"962\" height=\"501\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/edit-custom.png 962w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/edit-custom-768x400.png 768w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/a><\/p>\n<p><strong>12.<\/strong> <strong>What do you know about flash fill and how is it helpful in MS-Excel?<\/strong><\/p>\n<p>The main use of flash fill is, it helps in filling out the data automatically. If the pattern of the data is analysed then the preview will be shown in a box. It also merges the cell values and auto fills the other cells and it can also separate a value from a cell. In the below example, we can see how flash fill performs its activity.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/flash-fill.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102241\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/flash-fill.png\" alt=\"flash fill\" width=\"961\" height=\"497\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/flash-fill.png 961w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/flash-fill-768x397.png 768w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/p>\n<p><strong>13. What are the possible ways to find the duplicate values in a column?<\/strong><\/p>\n<p>There are two ways to fetch the duplicate values in a column and they are conditional formatting or by making use of the countif function.<\/p>\n<p><strong>1. Conditional Formatting:<\/strong><br \/>\nTo make use of the conditional formatting, click on the home tab and choose \u201cHighlight cell rules\u201d. Then, finally click on the \u201cDuplicate values\u201d option.<\/p>\n<p><strong>2. Countif():<\/strong><br \/>\nThe user can make use of the countif function to check whether the values in a particular column are repeated.<\/p>\n<p><strong>14.<\/strong> <strong>You need to create a single variable in a code and store multiple names in it. Is that possible to do?<\/strong><\/p>\n<p>Yes, we can do it by creating an array. The following code is a sample of it.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Private Sub Student_names()\r\n   Dim arrNames(0 to 3) as String  \r\n     arrNames(0) = \"Vihaan\" \r\n     arrNames(1) = \"Arjun\" \r\n     arrNames(2) = \"Arya\"\r\n      arrNames(3) = \"Shrishta\"\r\n \r\n End Sub\r\n<\/pre>\n<p><strong>15.<\/strong> <strong>What is the role of nested if condition and write its syntax?<\/strong><\/p>\n<p><strong>Nested IF:<\/strong><br \/>\nThe nested if condition is a function which contains a lot of IF statements inside an IF function and it is used to evaluate in excel when there are more than one condition to be looked after in a dataset. It can also be said that it is a function which starts with an IF function and the other IF functions are added inside the original IF function.<br \/>\n<strong>Nested IF Syntax:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">=IF(logical_test,[value_if_true],[value_if_false],IF(logical_test,[value_if_true],[value_if_false], ...))\r\n<\/pre>\n<p><strong>16.<\/strong> <strong>How can a user remove duplicate values in a range of cells?<\/strong><\/p>\n<p>To delete duplicate values in a column, choose the highlighted cells from conditional formatting and press the delete button from the keyboard. After deleting the values, go to the \u2018Conditional Formatting\u2019 option under the Home tab. Select \u2018Clear Rules\u2019 to remove the rules from the excel sheet.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/dup-val.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102242\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/dup-val.png\" alt=\"duplicate values in excel\" width=\"954\" height=\"476\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/dup-val.png 954w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/dup-val-768x383.png 768w\" sizes=\"auto, (max-width: 954px) 100vw, 954px\" \/><\/a><\/p>\n<p>The user can also delete duplicate values by choosing the \u201cRemove Duplicates\u201d option under the Data tab.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/remove-duplicates.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102243\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/remove-duplicates.png\" alt=\"remove duplicates in excel\" width=\"957\" height=\"493\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/remove-duplicates.png 957w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/remove-duplicates-768x396.png 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/a><\/p>\n<p><strong>17.<\/strong> <strong>What is the formula you can use to fetch data from the dataset?<\/strong><\/p>\n<p>In order to fetch the data from a dataset, we can use the vlookup function. For example, if we are fetching a particular mark in a student mark list then we have to mention the student\u2019s name, table range, the column number, match type \u201c=VLOOKUP(Akkshaya, A2:D25, 3, 0)\u201d . Here 0 represents the exact match.<\/p>\n<p><strong>18.<\/strong> <strong>Can we filter or sort the data from smallest to largest?<\/strong><\/p>\n<p>Yes, we can filter the data as per the requirement. To sort the data from smallest to largest, click on the filter options under the data tab. Then, select the smallest to highest option from the drop down list beside the header cell.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/filter-opt.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102244\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/filter-opt.png\" alt=\"filter option in excel\" width=\"961\" height=\"264\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/filter-opt.png 961w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/filter-opt-768x211.png 768w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/p>\n<p>After choosing the option, the following result appears<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/sorted.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102245\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/sorted.png\" alt=\"sorted data in excel\" width=\"1920\" height=\"711\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/sorted.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/sorted-768x284.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/sorted-1536x569.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>19.<\/strong> <strong>How to create a \u201cnot equal to\u201d operation case in VBA?<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Sub Notequal_Click()\r\n    Dim a As Integer, b As Integer\r\n    num1 = 100\r\n    num2 = 100\r\n    If a &lt;&gt; b Then\r\n            MsgBox (\"True\")\r\n        Else\r\n            MsgBox (\"False\")    \r\n    End If\r\nEnd Sub\r\n<\/pre>\n<p><strong>20.<\/strong> <strong>Can we use a logical operator in VBA code and if so, give me a sample?<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Private Sub log_operator()\r\nDim num1 As Integer, num2 As Integer, output As String\r\n\r\nnum1 = 100\r\nnum2 = 200\r\n\r\nIf num1 &gt;= 100 Or num2 &gt; 200 Then\r\n    output = \"The output cleared the logical function\"\r\nElse\r\n    output = \"It did not pass the condition\"\r\nEnd If\r\n\r\nRange(\"C1\").Value = result\r\n\r\nEnd Sub\r\n<\/pre>\n<h3>Advanced Interview Questions on MS Excel<\/h3>\n<p><strong>21.<\/strong> <strong>What are the steps to change the legend position in the chart?<\/strong><\/p>\n<p>The legend position can be changed as per the user\u2019s convenience through below steps:<\/p>\n<p>1- To change the legend position, click on the chart and then select the \u201c+\u201d symbol from the right side of the chart.<\/p>\n<p>2- From there, go to legend and click on the arrow beside it.<\/p>\n<p>3- Finally, choose on which side it has to appear. The changes will be reflected on the chart.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/legend.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102246\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/legend.png\" alt=\"legend in excel\" width=\"955\" height=\"493\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/legend.png 955w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/legend-768x396.png 768w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\" \/><\/a><\/p>\n<p><strong>22.<\/strong> <strong>When we could use variables for each element, why do we go for a VBA array?<\/strong><\/p>\n<p>We choose the VBA array because it helps in grouping logically related data. For example, if we wanted to save employee records then we can use an array variable with separate location for each category. It is easy to maintain the codes as we use only one variable instead of many variables. Retrieving, sorting and modifying the data in an array is faster and this also means it has a better performance.<\/p>\n<p><strong>23.<\/strong> <strong>How do reports and dashboard vary in Excel?<\/strong><\/p>\n<p><strong>Reports:<\/strong> We use the historical data to form reports and reports include visuals such as tables, graphs,charts and texts etc. The reports that are made are not live.<\/p>\n<p><strong>Dashboards:<\/strong> The dashboards we create in excel are dynamic and live. When we change or update the data in dashboards, the visuals will also be altered and we can see the changes. Dashboard also contains visual displays such as tables, charts and values etc.<\/p>\n<p><strong>24.<\/strong> <strong>Write the code to create a textbox in VBA?<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Private Sub TextBox_Mdo()\r\nTextBox.Text = \"We have created a textbox via code!\"\r\nEnd Sub\r\n<\/pre>\n<p><strong>25.<\/strong> <strong>What are the steps to add a trendline in the chart?<\/strong><\/p>\n<p>The steps to follow to add a trendline are:<\/p>\n<p>1: Click on the chart, then at the right side of the chart click +.<\/p>\n<p>2: Click on the arrow present next to the trendline and choose more options.<\/p>\n<p>3: The format trendline pane will now be visible. Then choose an option from the trendline pane.<\/p>\n<p>4: Select linear trendline options, then to include in the forward forecast specify the number of periods.<\/p>\n<p>5: Finally check mark on display equation on chart and display R-squared value on chart option.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/trend-line.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102247\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/trend-line.png\" alt=\"trend line in excel\" width=\"749\" height=\"299\" \/><\/a><\/p>\n<p><strong>26.<\/strong> <strong>Is there any smart way to return to a particular area of a worksheet?<\/strong><\/p>\n<p>We can return to a specific area of a worksheet by referencing the specific area by name box. When we type the range name on the cell address, it takes us to the specific area of a worksheet.<\/p>\n<p><strong>27.<\/strong> <strong>Can we debug a macro code?<\/strong><\/p>\n<p>Yes, we can debug a macro code and this situation comes when there are chances of users to commit mistakes in the code and that leads to error. So to overcome the error in the code, we can debug the code just as we do to any other coding language. We can also know about the errors and eventually we can correct them.<\/p>\n<p>To debug a macro code, click on the macros option under the developer tab and select the \u201cstep into\u201d option from the box. Once you select it, the code automatically opens up in Microsoft Visual Basics for Applications.<\/p>\n<p><strong>28.<\/strong> <strong>Can we provide Dynamic Range in \u2018Data Source\u2019 of Pivot Tables?<\/strong><\/p>\n<p>Yes, we can provide the data source in dynamic range for the pivot tables. When we provide it dynamically, the table automatically adds the new records in the summary and we can see the changes once the table is refreshed. To provide the range, select the table under the insert tab and give a name to the table if you want.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/table.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102248\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/table.png\" alt=\"table in excel\" width=\"1920\" height=\"985\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/table.png 1920w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/table-768x394.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/table-1536x788.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<p><strong>29.<\/strong> <strong>Write a code using a function to calculate the quadrant of a number in VBA<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Function quadrant (ByVal my_num As Integer) As Integer\r\n my_num =  my_num *  my_num\r\nquadrant =  my_num\r\nmsgbox(\u201cThe quadrant value of a number is:\u201d quadrant)\r\nEnd Function\r\n<\/pre>\n<p><strong>30.Can we create hyperlinks in Excel? What is the procedure to insert it?<\/strong><\/p>\n<p>Yes, we can create hyperlinks in excel. Hyperlink is a function which helps the user to open the document stored in that particular link and we can also use hyperlinks to navigate in and between the sheet also.<\/p>\n<p>In order to insert a hyperlink in excel, go to the hyperlink option under the insert tab. When you click on it, the list of files and documents appear, we can either choose from it or we can just browse for the required information.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/hyperlink.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-102249\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/hyperlink.png\" alt=\"hyperlink in excel\" width=\"956\" height=\"497\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/hyperlink.png 956w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/10\/hyperlink-768x399.png 768w\" sizes=\"auto, (max-width: 956px) 100vw, 956px\" \/><\/a><\/p>\n<h3>Summary:<\/h3>\n<p>This article would help the candidate to clear the doubts about Microsoft Excel interview questions and will also be very helpful to crack the interviews.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Following are the most important Excel interview questions that an interviewer might ask. These questions and answers would widely help the candidate to prepare for the interview. MS Excel Interview Questions for Beginners 1.Write&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":102120,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24129],"tags":[25391,25389,25390],"class_list":["post-100470","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-excel","tag-excel-interview-questions-and-answers","tag-ms-excel-interview-questions","tag-ms-excel-interview-questions-with-answers"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MS Excel Interview Questions - DataFlair<\/title>\n<meta name=\"description\" content=\"Check MS Excel Interview Questions with Answers for beginners, intermediate &amp; expert level. These questions are commonly asked in interviews\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS Excel Interview Questions - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Check MS Excel Interview Questions with Answers for beginners, intermediate &amp; expert level. These questions are commonly asked in interviews\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-11T03:30:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-11T04:31:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/09\/ms-excel-interview-questions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS Excel Interview Questions - DataFlair","description":"Check MS Excel Interview Questions with Answers for beginners, intermediate & expert level. These questions are commonly asked in interviews","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"MS Excel Interview Questions - DataFlair","og_description":"Check MS Excel Interview Questions with Answers for beginners, intermediate & expert level. These questions are commonly asked in interviews","og_url":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2021-10-11T03:30:12+00:00","article_modified_time":"2021-10-11T04:31:42+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/09\/ms-excel-interview-questions.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9"},"headline":"MS Excel Interview Questions","datePublished":"2021-10-11T03:30:12+00:00","dateModified":"2021-10-11T04:31:42+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/"},"wordCount":2069,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/09\/ms-excel-interview-questions.jpg","keywords":["excel interview questions and answers","MS Excel Interview Questions","MS Excel Interview Questions with answers"],"articleSection":["MS Excel Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/","url":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/","name":"MS Excel Interview Questions - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/09\/ms-excel-interview-questions.jpg","datePublished":"2021-10-11T03:30:12+00:00","dateModified":"2021-10-11T04:31:42+00:00","description":"Check MS Excel Interview Questions with Answers for beginners, intermediate & expert level. These questions are commonly asked in interviews","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/09\/ms-excel-interview-questions.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/09\/ms-excel-interview-questions.jpg","width":1200,"height":628,"caption":"ms excel interview questions"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/ms-excel-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MS Excel Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/ms-excel\/"},{"@type":"ListItem","position":3,"name":"MS Excel Interview Questions"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/b49855299264df5e27e3ec6c2cd9fde9","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef46b745ddad2fad690af626c6ef29b91809ad0a9f5ef398d07817d8cad042f5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team is a group of passionate educators and industry experts dedicated to providing high-quality online learning resources on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. With years of experience in the field, the team aims to simplify complex topics and help learners advance their careers. At DataFlair, we believe in empowering students and professionals with the knowledge and skills needed to thrive in today\u2019s fast-paced tech industry. Follow us for Free courses, expert insights, tutorials, and practical tips to boost your learning journey.","url":"https:\/\/data-flair.training\/blogs\/author\/datafbdad\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/100470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=100470"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/100470\/revisions"}],"predecessor-version":[{"id":102250,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/100470\/revisions\/102250"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/102120"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=100470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=100470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=100470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}