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) 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.

---

5) How would you format a cell? What are the options?

A cell can be formatted by using the format cells options. There are 6 format cells options:

• Number
• Alignment
• Font
• Border
• Fill
• Protection

---

6) 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.

---

7) 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.

---

8) How would you add comments to a cell?

To add a comment to a cell, you right click the cell and choose insert comment from the cell menu. Type your comment in the comment area provided. A red triangle at the top right hand corner of a cell indicates that there is a comment linked to that particular cell. To remove a comment from a cell, right lick the cell and then select delete comment from the cell menu.

---

9) What are charts in MS Excel?

Charts are used to enable graphical representation of the data in Excel. A user can use any chart type, including column, bar, line, pie, scatter, etc. by selecting an option from Insert tab?s Chart group.

---

10) What is Freeze Panes in MS-Excel?

Freeze Panes are used to lock any row or column. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.