# Excel Interview Questions and Answers

Last updated on Mar 07, 2022
• Share

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.

Q21. How do you enter a complicated formula in Excel?

In order to perform a complex function, there is a standard order of operations in it. The first step is to put the specified portion of the formula in parentheses. For example, we need to add the contents of cell C5 and C6, then multiplying it with the data of B6. The derived formula would be =(C5+C6)*B6.

Q22. What is the use of subtotal function in Excel?

In spreadsheets of MS Excel, sometimes data from more than one category is available and SUBTOTAL function helps in getting the totals of various columns of data of different categories.

SUBTOTAL = (method, range1, [ange2..range_n])

Q23. Is there a shortcut key for AutoSum in Excel?

Yes, there is a shortcut key for AutoSum in Excel. All are required to be done is highlighting all the cells whose data is to be added. After that press Alt and = (together)

Q24. What is pivot cache in Excel VBA?

Pivot Cache is generated with the creation of the Pivot Table. It is a data source’s replica holding object. Pivot Cache is a part of the workbook and pivot table. Every time any changes are required in the pivot table, pivot cache is used instead of the table.

Q25. What is a waterfall chart in Excel?

There is a special type of Excel column chart used to mark the change of the value from its starting position to the end no matter whether it increases or decreases. This Excel column chart is known as Waterfall chart in Excel.

Q26. How to sort numerically in Excel?

There are some steps for sorting numerically in Excel. The first step is the selection of the cell in the column which you want to sort. Next is selecting the data tab and clicking “ascending command’ for sorting smallest to largest of the digits. Whereas, you can select the descending command to sort the data from the largest to the smallest. This is the simple way of getting the data sorted numerically.

Q27. Why is VBA used in Excel?

VBA is Visual Basic for Applications is an event-driven programming language developed for the personalized applications containing VB for API. Basically, VBA is one of the programming languages of MS Excel and other office programs. The basic feature of VBA is keeping a check and controlling the functionality of MS Excel and other MS Office applications.

Q28. What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?

Substitute is used to replace one or more instances of a text string or a character. We should use Excel Substitute function when we know the replaceable text.

On the other hand, we use the Replace function in Excel for changing the characters of a text string in a specified position.