Excel Interview Prepration

Excel interview questions and answers help you prepare for your interview! If you have any more specific questions or need further assistance, feel free to ask. Good luck!



Excel interview questions and answers! Below are some frequently asked questions along with their respective answers:

Q: What is Microsoft Excel, and what is it used for?

A: Microsoft Excel is a powerful spreadsheet application developed by Microsoft. It is used for various purposes, including data organization, analysis, manipulation, and visualization. Excel is widely used in businesses, finance, accounting, engineering, and many other fields to perform calculations, create charts, and manage large sets of data.


Q: How do you freeze panes in Excel?

A: Freezing panes in Excel allows you to keep specific rows and/or columns visible while scrolling through a large dataset. To freeze panes, follow these steps:

   1. Select the cell below the row(s) you want to freeze and to the right of the column(s) you want to freeze.

   2. Go to the "View" tab on the Excel ribbon.

   3. Click on the "Freeze Panes" dropdown menu.

   4. Choose either "Freeze Panes" to freeze both rows and columns or "Freeze Top Row" to freeze the top row, or "Freeze First Column" to freeze the leftmost column.


Q: How can you remove duplicates in Excel?

A: To remove duplicates in Excel, follow these steps:

   1. Select the range of cells where you want to remove duplicates.

   2. Go to the "Data" tab on the Excel ribbon.

   3. Click on the "Remove Duplicates" button in the Data Tools group.

   4. A dialog box will appear, showing all columns in the selected range. Choose the columns that you want to check for duplicates.

   5. Click "OK," and Excel will remove duplicate values based on the selected columns.


Q: How do you create a chart in Excel?

A: To create a chart in Excel, follow these steps:

   1. Select the data range that you want to include in the chart.

   2. Go to the "Insert" tab on the Excel ribbon.

   3. Click on the type of chart you want to create (e.g., column chart, line chart, pie chart, etc.).

   4. Excel will insert the chart into your worksheet. You can customize the chart by using the "Chart Tools" on the ribbon.


Q: What are the different types of cell references in Excel?

A: In Excel, there are three types of cell references:

   - Relative Reference: The default reference type, which changes when copied or filled to other cells. For example, if you have a formula "=A1+B1" in cell C1 and copy it to C2, it will become "=A2+B2."

   - Absolute Reference: The reference that remains constant when copied or filled to other cells. It is denoted by adding a dollar sign ($) before the column letter and row number. For example, "$A$1."

   - Mixed Reference: A reference that has either the column or row fixed but not both. You can have "$A1" (column A fixed) or "A$1" (row 1 fixed).


Q: How do you create a drop-down list in Excel?

A: To create a drop-down list in Excel, follow these steps:

   1. Create a list of items you want to include in the drop-down in a range of cells (e.g., A1:A5).

   2. Select the cell where you want the drop-down list to appear (e.g., B1).

   3. Go to the "Data" tab on the Excel ribbon.

   4. Click on "Data Validation" in the Data Tools group.

   5. In the Data Validation dialog box, choose "List" from the "Allow" dropdown.

   6. In the "Source" field, enter the range of cells that contain your list (e.g., =$A$1:$A$5).

   7. Click "OK," and a drop-down arrow will appear in cell B1, allowing you to choose from the list of items.

These are just Frequently asked QnA In interview for more data analysis or data visualisation related questions feel free to comment or write ✍️ us we Discover Talent Presents always here to help you out


Announcement - if incase you are looking for any certification training tutorial do subscribe us on YouTube channel which ease you to achieve certification for the Excel training