15 Excel interview questions for freshers

1) What is Microsoft Excel and what is it used for?
Answer: A spreadsheet app used for organizing, analyzing, and visualizing data with cells, formulas, charts, and functions.

2) What are workbook, worksheet, and range?
Answer: A workbook is the Excel file; a workbook contains one or more worksheets; a range is a rectangular selection of cells.

3) What are some essential formulas/functions?
Answer: SUM, AVERAGE, COUNT, MIN, MAX, IF, VLOOKUP/XLOOKUP, INDEX, MATCH, CONCATENATE/CONCAT, TEXT.

4) What is relative vs absolute referencing?
Answer: Relative changes when copied; absolute uses $ (e.g., $A$1) and doesn’t shift.

5) What is VLOOKUP and what’s a limitation?
Answer: Looks up a value in the first column of a range and returns a value from another column. Limitation: can only search left-to-right; XLOOKUP/INDEX-MATCH are more flexible.

6) What is the difference between = and == in Excel?
Answer: In Excel, = starts a formula; there is no == operator for comparison like in programming languages.

7) How do you handle errors in formulas?
Answer: Use IFERROR(value, value_if_error) to show a friendly result instead of error messages.

8) What are pivot tables?
Answer: A tool to summarize, analyze, explore, and present data by dragging fields into rows, columns, values, and filters.

9) What is data validation?
Answer: A feature to control what can be entered into a cell (e.g., dropdown lists, date ranges).

10) How do you sort and filter data?
Answer: Data tab → Sort to arrange rows; Filter to show only matching rows with autofilter dropdowns.

11) What is conditional formatting?
Answer: Format cells based on rules (e.g., highlight top 10, cells above a threshold).

12) What are named ranges?
Answer: Assigns a meaningful name to a cell or range to make formulas easier to read and manage.

13) What is a formula auditing tool?
Answer: Shows dependencies and trace precedents/dependents to troubleshoot formulas.

14) How do you protect worksheets/workbooks?
Answer: Review tab → Protect Sheet/Protect Workbook to restrict changes with a password.

15) What are basic chart types and when to use them?
Answer: Column/Bar for comparisons, Line for trends, Pie for parts of a whole, Scatter for relationships.

💬 React with ❤️ for more! 😊