✅ 15 Excel Interview Questions for Freshers 📊🧠

1️⃣ What is Microsoft Excel used for?
Answer: Excel is a spreadsheet program used for data entry, analysis, calculations, and visualization.

2️⃣ What is a cell in Excel?
Answer: A cell is the intersection of a row and column where data is entered (e.g., A1, B2).

3️⃣ What is the difference between a workbook and a worksheet?
Answer: A workbook is the entire Excel file. A worksheet is a single tab/sheet within that file.

4️⃣ What are formulas in Excel?
Answer: Formulas are expressions used to perform calculations using cell references and operators.

5️⃣ What is the difference between a formula and a function?
Answer: A formula is manually written; a function is a built-in command like SUM(), AVERAGE().

6️⃣ What does the VLOOKUP function do?
Answer: Searches for a value in the first column of a table and returns data from another column.

7️⃣ What is the difference between absolute and relative cell references?
Answer: Relative references (A1) change when copied; absolute references (A1) stay fixed.

8️⃣ What is conditional formatting?
Answer: It highlights cells based on rules (e.g., color cells above 100 in red).

9️⃣ How do you create a chart in Excel?
Answer: Select data → Insert → Choose chart type (e.g., bar, line, pie).

1️⃣0️⃣ What is a Pivot Table?
Answer: A tool to summarize, group, and analyze large data sets interactively.

1️⃣1️⃣ What is the IF function?
Answer: A logical function: IF(condition, value_if_true, value_if_false).

1️⃣2️⃣ What is the use of data validation?
Answer: Restricts data entry to specific types (e.g., numbers only, dropdown lists).

1️⃣3️⃣ How do you protect a worksheet?
Answer: Go to Review → Protect Sheet → Set password and options.

1️⃣4️⃣ What is the CONCATENATE function used for?
Answer: Combines text from multiple cells into one. (Now replaced by TEXTJOIN or CONCAT).

1️⃣5️⃣ What are Excel shortcuts you should know?
Answer:
- Ctrl + C: Copy
- Ctrl + V: Paste
- Ctrl + Z: Undo
- Ctrl + Shift + L: Toggle filter

Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

💬 React with ❤️ if this helped you!