🚀 Top 100 Excel Interview Questions

🧠 Excel Basics & UI

1. What is Microsoft Excel and what is it mainly used for?
2. What is the difference between a workbook and a worksheet?
3. What is a cell, row, and column?
4. How do you rename, insert, or delete a worksheet?
5. How do you select a range, entire row, or entire column?
6. How do you copy, paste, and cut data?
7. How do you use Zoom, Freeze Panes, and Split Window?
8. How do you hide/unhide rows and columns?
9. How do you insert/delete rows and columns without breaking formulas?
10. How do you save, open, and share an Excel file (including via OneDrive/SharePoint)?

📊 Formatting & Data Entry

11. How do you format numbers as currency, percentage, or date?
12. How do you wrap text and merge cells?
13. How do you resize columns and rows to fit content?
14. How do you apply bold, italic, borders, and background colors?
15. How do you AutoFit column width and row height?
16. How do you print and set page layout (margins, gridlines, headers/footers)?
17. How do you protect a sheet or workbook with a password?
18. How do you use “Format as Table” and why is it useful?
19. How do you use conditional formatting (highlight cells, data bars, color scales, icons)?
20. How do you apply custom number formats?

🧮 Formulas & Functions (Beginner)

21. How do you write a basic arithmetic formula starting with =?
22. What are relative, absolute, and mixed references (A1, $A$1, A$1)?
23. How do you use SUM, AVERAGE, MIN, MAX, COUNT, COUNTA?
24. How do you calculate percentage and percentage change?
25. How do you use ROUND, ROUNDUP, and ROUNDDOWN?
26. How do you calculate current date and time (TODAY, NOW)?
27. How do you calculate the difference between two dates?
28. How do you use IF for simple logical conditions?
29. How do you handle errors using IFERROR or IFNA?
30. How do you nest multiple IF statements?

🔍 Lookups, Logic & Math

31. How do you use VLOOKUP and what are its limitations?
32. How do you use HLOOKUP?
33. How do you use INDEX + MATCH for flexible lookups?
34. How do you use XLOOKUP (if available)?
35. How do you use IF with AND / OR conditions?
36. How do you use SUMIF, SUMIFS for conditional sums?
37. How do you use COUNTIF, COUNTIFS for conditional counts?
38. How do you use AVERAGEIF, AVERAGEIFS?
39. How do you use COUNTBLANK, COUNTUNIQUE‑style techniques?
40. How do you use SUMPRODUCT for weighted calculations?

🗓️ Date, Time & Text Functions

41. How do you extract YEAR, MONTH, DAY from a date?
42. How do you calculate days between two dates?
43. How do you calculate workdays between two dates (NETWORKDAYS)?
44. How do you use DATEDIF for years/months/days?
45. How do you use TRIM to remove extra spaces?
46. How do you join text from multiple cells (CONCAT, &, CONCATENATE)?
47. How do you split text with TEXTSPLIT or LEFT/RIGHT/MID?
48. How do you find text inside a string (FIND, SEARCH)?
49. How do you replace or remove part of a string (SUBSTITUTE, REPLACE)?
50. How do you change case (UPPER, LOWER, PROPER)?

📊 Data Analysis & Conditional Formatting

51. How do you sort data by one or multiple columns?
52. How do you use AutoFilter and custom filters?
53. How do you filter by blanks, non‑blanks, or specific values?
54. How do you remove duplicates from a list?
55. How do you use conditional formatting with formulas?
56. How do you highlight top/bottom N values?
57. How do you standardize and clean messy data (e.g., “Yes / yes / Y” → “Yes”)?
58. How do you use Text‑to‑Columns and Flash Fill for quick cleaning?
59. How do you create subtotals and grouped views?
60. How do you build a simple KPI or summary table?