trainingtrains Logo

91-9990449935

 0120-4256464

JavaTpoint

MS Excel Interview Questions

There are given top frequently asked MS Excel interview questions and answers that has been asked in many companies. Let's see the list of top Excel interview questions.

1) What is Microsoft Excel?

Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and analyzing data. It is developed by Microsoft.

2) What are cells?

The area where data is stored is known as cell.

3) Does each cell have unique address?

Yes, each cell has a unique address depends on the row and column value of the cell.

4) What is Ribbon?

The ribbon specifies an area which runs along the top of the application and contains menu items and toolbars available in Excel. The ribbon has various tabs that contain groups of commands for use in the application.

5) Is it possible to hide or show the ribbon?

You can hide or show (minimize or maximize) the ribbon by pressing CNTRL F1.

6) How to prevent someone from copying the cell from your worksheet?

If you want to protect your worksheet from being copied, go into Menu bar > Review > Protect sheet > Password.

By entering password you can prevent your worksheet from getting copied.

7) How to sum up the rows and column number quickly in the Excel sheet?

The SUM function is used to get the total sum of the rows and columns, in an excel worksheet.

8) How can you add cells, rows or columns in Excel?

If you want to add a cell, row or column in Excel, right click the cell you want to add to and after that select insert from the cell menu. The insert menu makes you able to add a cell, a column or a row and to shift the cells affected by the additional cell right or down.

9) How can you resize the column?

There are two ways to resize a column:

  1. To change the width of one column, drag the boundary on the right side of the column until you find your desirable width.
  2. Select the Format from the home tab, and in Format, select the AUTOFIT COLUMN WIDTH under cell section. Click on this to change the cell size.

10) What are the several report formats in Excel?

There are three report formats in Excel:

  • Compact
  • Report
  • Tabular

11) Is it possible to make Pivot table using multiple sources of data?

If the multiple sources are different worksheets from the same workbook, then you can use these multiple sources of data to make Pivot table.

12) What is the use of comment? How to add comments to a cell?

Comments are used for a lot of reasons:

  • Comments are used to clarify the purpose of the cells.
  • Comments are used to clarify a formula used in the cell.
  • Comments are used to leave notes for others users about a cell.

To add a comment: Right click the cell and choose insert comment from the cell menu. Type your comment.

13) What does the red triangle indicate at the top right hand corner of the cell?

The red triangle at the top right hand corner of a cell indicates that there is a comment linked to the particular cell. If you put your cursor on it, it will show the comment.

14) How can you check whether the Pivot table is modified or not?

To check whether the Pivot table is modified or not, you should use the "PivotTableUpdate" in worksheet containing the pivot table.

15) What does the IF function in Excel?

IF function is used in Excel to check whether certain conditions are true or false. If the condition is true then it will give the result accordingly and if the condition is false the result or output will be different.

16) What filter should we use, if you want more than two conditions or if you want to analyze the list using database function?

You should use "Advanced Criteria Filter" to analyze the list or test more than two conditions.

17) What are the advantages of using formula in Excel sheet?

Formula makes it easy to calculate the numbers in Excel sheet. It also calculates automatically the number replaced by another number or digit. It is used to make complex calculations easy.

18) What is the order of sequence of operating mathematical operation in Excel?

The order of sequence is written as BEDMAS:

  • Brackets
  • Exponents
  • Division
  • Multiplication
  • Addition
  • Subtraction

19) What is the use of LOOK UP function in MS Excel?

The LOOK UP function is used to return a value from an array.

20) What is a Macro in Excel? How to create an Excel Macro?

Excel Macro is the set of instructions that is recorded by users for repetition purposes. It is created by the users for repetitive instructions and functions they perform on a regular basis.