25 Interview Questions and Answers on MS Excel



1. What is Microsoft Excel?
Ans:- Microsoft Excel is a spreadsheet software developed by Microsoft Corporation.

2. What is a cell in Excel?
 Ans:- A cell is the intersection point of a row and a column in Excel. It is the smallest unit in a worksheet where data can be entered.

3. How can you add a new worksheet in Excel?
Ans:- To add a new worksheet, click on the “Insert Worksheet” button in the bottom left corner of the Excel window.

4. What is the shortcut key to save an Excel workbook?
Ans:- The shortcut key to save an Excel workbook is Ctrl + S.

5. What is a function in Excel?
 Ans:- A function is a predefined formula that performs a specific calculation in Excel.

6. What is the shortcut key to insert a new column in Excel?
Ans:- The shortcut key to insert a new column is Ctrl + Shift + +.

7. What is the shortcut key to insert a new row in Excel?
Ans:- The shortcut key to insert a new row is Ctrl + Shift + =.

8. What is the shortcut key to select an entire column in Excel?
Ans:- The shortcut key to select an entire column is Ctrl + Space.

9. What is the shortcut key to select an entire row in Excel?
Ans:- The shortcut key to select an entire row is Shift + Space.

10. What is the purpose of conditional formatting in Excel?
Ans:- The purpose of conditional formatting is to highlight cells that meet certain criteria, such as values that are above or below a certain threshold.

11. What is the shortcut key to insert the current date in Excel?
Ans:- The shortcut key to insert the current date is Ctrl + ;.

12. What is the shortcut key to insert the current time in Excel?
Ans:- The shortcut key to insert the current time is Ctrl + Shift + ;.

13. What is the purpose of the COUNT function in Excel?
Ans:- The purpose of the COUNT function is to count the number of cells that contain numeric values.

14. What is the purpose of the SUM function in Excel?
Ans:- The purpose of the SUM function is to add a range of numbers in Excel.

15. What is the purpose of the AVERAGE function in Excel?
Ans:- The purpose of the AVERAGE function is to calculate the average of a range of numbers in Excel.

16. What is the purpose of the MAX function in Excel?
Ans:- The purpose of the MAX function is to find the maximum value in a range of numbers in Excel.

17. What is the purpose of the MIN function in Excel?
Ans:- The purpose of the MIN function is to find the minimum value in a range of numbers in Excel.

18. What is the purpose of the IF function in Excel?
Ans:- The purpose of the IF function is to test a condition and return one value if the condition is true, and another value if the condition is false.

19. What is the purpose of the VLOOKUP function in Excel?
Ans:- The purpose of the VLOOKUP function is to search for a specific value in the first column of a table and return a corresponding value from a specified column in the same row.

20. What is the purpose of the HLOOKUP function in Excel?
Ans:- The purpose of the HLOOKUP function is to search for a specific value in the first row of a table and return a corresponding value from a specified row in the same column.

21. What is the purpose of the CONCATENATE function in Excel?
Ans:- The purpose of the CONCATENATE function is to join two or more text strings together in Excel.

22. What is the purpose of the LEFT function in Excel?
Ans:- The purpose of the LEFT function is to extract a specified number of characters from the left side of a text string in Excel.

23. What is the purpose of the RIGHT function in Excel?
Ans:- The purpose of the RIGHT function is to extract a specified number of characters from the right side of a text string in