Excel Interview Questions and Answers

Last updated on Mar 07, 2022
  • Share
Excel Interview Questions

It is a software offering various features to calculate, format, organize data with formulas with the help of a spreadsheet system. MS Office Suite is the parent of MS Excel and used to create spreadsheets. Spreadsheets are documents displayed in a significant tabular form laid out in rows and columns. We have a broad spectrum of Excel Interview Questions which can help you land to your dream job. MS Excel is a software program developed by Microsoft in the year 1985.

Advantages of using MS Excel

  • Make a comparison of data easy
  • Summarization, organization, and structuring of data is less time consuming
  • Ease of building great charts
  • Sorting and filtering of the information takes a fraction of seconds
  • Visual display of data then using graphs, pie charts

Most Frequently Asked Excel Interview Questions

Here in this article, we will be listing frequently asked Excel Interview Questions and Answers with the belief that they will be helpful for you to gain higher marks. Also, to let you know that this article has been written under the guidance of industry professionals and covered all the current competencies.

Q1. What is Excel and what is it used for?

Ms Excel is a spreadsheet program and one of the components of the Microsoft Office Suite. MS Excel is productivity software which creates and edits spreadsheets with a file extension of .xlsx or .xls. In it, data is laid out in big tables in a number of columns and rows and shows extreme power and versatility.

As Excel is a spreadsheet program, there are various uses of Microsoft Excel., we can use it to-
  • make numbers,
  • grids of text
  • use specified calculations to perform functions on the numbers
  • records income, plan budgets, expenditures, external sources, stock market, feeds, etc

Pull in data and runs the data through the formulas for updating information in real time

Q2. What are the advantages of Microsoft Excel?
  • Make a comparison of data easy
  • Summarization, organization, and structuring of data is less time consuming
  • Ease of building great charts
  • Sorting and filtering of the information takes a fraction of seconds
  • Visual display of data then using graphs, pie charts
Q3. Explain the main features of MS Excel?
MS Excel has several features like-
  • Use graphing tools
  • Perform basic calculations
  • create macros and pivot table
Q4. Why do we use formulas in Excel?

Formulas are used in MS Excel due to their trait of performing several tasks and operations automatically. Also, the users are allowed to use cell references or type numbers directly into the formulas. This lets the formulas to use whatever data is contained in the reference cells.

Q5. What are the basic formulas in Excel?
Basic formulas in MS Excel are
1. SUM

=SUM(number1, [number2], …)

Example: =SUM(B2:G2)


=AVERAGE(number1, [number2], …)

Example: =AVERAGE(A1:A10)


=COUNT(value1, [value2], …)

Example: COUNT(A1:C1)


=COUNTA(value1, [value2], …)

Example: COUNTA(A:A)

5. IF

=IF(logical_test, [value_if_true], [value_if_false])

Example: =IF(C2



Example: TRIM(A4)

7. MIN

=MIN(number1, [number2], …)

Example: =MIN(B2:C11)

8. MAX

=MAX(number1, [number2], …)

Example: =MAX(B2:C11)


Q6. How can you resize the column?

Resizing the column requires the row height to be changed to fit into the content. Then, you need to select the rows that you modify. Click Format on the home tab, in Cells. Then, under Cell size, click on AutoFit Row Height.

Q7. How do I freeze panes in Excel 2017?

Freeze panes are used when we need to keep a spreadsheet’s area scrolling to another worksheet’s area, visit View tab. There, you can freeze panes, and split panes for creating window separation of the same worksheet.

Steps of freezing rows and columns-
1. Freezing of the first column
  • Select View>Freeze Panes > Freeze First Column
2. Freezing of the first two columns-
  • Now, select the third column
  • Select View> Freeze Panes> Freeze Panes

To freeze rows and columns, you need to select the right of the columns and below the rows in order to make the screen visible.

Q8. How you can format cells in Excel?
Formatting of the cells in MS Excel is done in the following steps-
  • Open your MS Excel
  • Select a cell or a group of cells to be formatted
  • Now, click on Format Cells Window
  • Select the formatting options for the cell
  • Click on Save
Q9. What are absolute and relative cell references?

Both relative and absolute references behave indifferently when they are copied and filled to other cells. Change in the corresponding reference takes place with the copying of the formula to another cell. But, on the other hand, absolute references there are no changes here when they are copied.

Q10. How to do an IF-THEN formula in Excel?
Formula or syntax of the if-then statement in MS Excel-

IF (Logic_Test, Value_if_True, Value_if_False) where expression to be evaluated is denoted by Logic_Test.


For example;-

IF (C5<=40,”Fail,” “Pass”) where C5 contains minimum marks required to pass a test.

Latest version Excel

The latest version of Excel is v16.0 came in Excel 2016. There are several other versions of MS Excel, which vary with their functionality and characteristics. The development of history becomes an essential topic in MS Excel Interview Questions.

Reviewed and verified by Best Interview Question
Best Interview Question

With our 10+ experience in PHP, MySQL, React, Python & more our technical consulting firm has received the privilege of working with top projects, 100 and still counting. Our team of 25+ is skilled in...