Nobody’s going to ask you to build a macro in a fresher interview. That’s not what Excel rounds are about. They want to see if you can sort a messy dataset, clean it up, use the right formula without freezing, and put together a basic summary. That’s it. Four things. If you can do those confidently, you’re already beating most of the competition.
Over 75% of entry-level operations, MIS, and admin roles in India list Excel as a required skill. And the questions? Almost always the same 30. Here they are.
Excel Basics Questions
1. What is the difference between a workbook and a worksheet?
Workbook = the file. Worksheet = one tab inside that file. A single workbook can hold multiple worksheets.
Sample Answer 1
“Sir/Ma’am, a workbook is the Excel file itself. A worksheet is one tab inside it. In my college project, I kept 3 worksheets in one workbook: raw data, calculations, and the summary report.”
2. What is a cell, and what is a cell reference?
A cell is one box. A1, B5, D10. A cell reference is the address you type into formulas to point to that box.
Sample Answer 1
“A cell is a single box, like A1. A cell reference is the address I use inside formulas. In =SUM(A1:A50), A1 and A50 are references telling Excel which range to add.”
3. What are relative, absolute, and mixed references?
Shows up in almost every Excel interview. Matters when you copy formulas.
● Relative (A1): Shifts when you copy the formula somewhere else. ● Absolute ($A$1): Stays locked no matter where you paste it. ● Mixed ($A1 or A$1): Locks one direction but not the other.
Sample Answer 1
“Sir/Ma’am, if I’m applying a tax rate across 100 rows and the rate lives in F1, I’d write $F$1 so it stays fixed. The sales cell stays relative so it shifts down each row. Write the formula once, copy it 100 times, nothing breaks.”
When does this actually matter? Anytime you’re using one formula across a table but need a single value (tax rate, exchange rate, target number) to stay constant.
4. How do you remove duplicates?
Data → Remove Duplicates. Pick the columns to check. Done.
But here’s what most freshers miss. Don’t remove duplicates blindly from the entire dataset. Same customer can buy 3 times in one day. Those aren’t duplicates. Those are real transactions.
Sample Answer 1
“I’d use Remove Duplicates, but first I’d figure out what defines uniqueness. If Email is the unique ID, I remove duplicates on that column only, not the whole row. And I always work on a copy. Never the original.”
5. Sorting vs. filtering?
Sorting rearranges row order. A to Z, biggest to smallest, newest first. Filtering hides rows that don’t match. The data’s still there. Just temporarily invisible.
Sample Answer 1
“Sorting changes the order. Filtering changes visibility. 10 cities of sales data: I’d filter to see only Mumbai, or sort by revenue to find the top performer.”
6. What data cleaning steps do you follow in Excel?
This question separates freshers who’ve touched real data from freshers who’ve only done textbook exercises.
● TRIM to kill extra spaces (the silent lookup killer). ● UPPER, LOWER, PROPER for text case. ● Fix numbers stored as text (happens constantly with pasted data). ● Remove duplicates carefully, on the right column. ● Text to Columns to split combined values. ● Check for blanks and weird date formats.
Sample Answer 1
“Sir/Ma’am, first thing with any dataset: TRIM. Invisible spaces break VLOOKUP and COUNTIF silently. Then duplicates, text case, dates stored as text. In my college sales project, I spent the first 30 minutes just cleaning. That’s normal. That’s how real data works.”
Formula and Function Questions
7. SUM, AVERAGE, MIN, MAX, COUNT, COUNTA.
One-liners. Every fresher should have these cold.
● SUM adds numbers. AVERAGE gives the mean. MIN/MAX find extremes. COUNT counts numeric cells. COUNTA counts all non-empty cells including text.
Sample Answer 1
“The one that trips freshers up: COUNT vs. COUNTA. Column full of names? COUNT gives 0 because there are no numbers. COUNTA gives the actual count. Caught me once during a college project.”
8. COUNT vs. COUNTIF?
COUNT counts numbers. COUNTIF counts cells matching a condition. =COUNTIF(B:B,”Yes”) counts every “Yes” in column B.
Sample Answer 1
“COUNT is unconditional. COUNTIF adds a filter. At my internship, I used COUNTIF on a daily tracker to count ‘Delivered’ vs. ‘Pending’ orders. Faster than filtering and counting manually.”
9. The IF function.
Checks a condition. Returns one thing if true, another if false. =IF(C2>=60,”Pass”,”Fail”).
Sample Answer 1
“Decision formula. C2 is 60 or above? Pass. Below? Fail. Used it in a college attendance tracker to flag anyone below 75%.”
10. IF with AND, IF with OR.
AND = all conditions must be true. OR = at least one must be true.
● =IF(AND(C2>=60, D2>=75), “Eligible”, “Not Eligible”) ● =IF(OR(C2>=90, D2=”Distinction”), “Honours”, “Regular”)
Sample Answer 1
“In a grading sheet, I needed both exam score above 60 AND attendance above 75. AND handles that. If either condition qualified someone for honours, OR handles that.”
11. VLOOKUP and its limitations.
Searches the first column of a table, returns a value from another column. Formula: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE).
Three limitations interviewers love hearing:
● Can’t look left. Only searches the leftmost column. ● Column index breaks if you insert or delete columns. ● Defaults to approximate match. You need FALSE for exact match.
Sample Answer 1
“Sir/Ma’am, VLOOKUP’s biggest problem is it only looks right. If the value I need is to the left of my search column, VLOOKUP can’t help. INDEX-MATCH or XLOOKUP solve that.”
12. XLOOKUP vs. VLOOKUP.
XLOOKUP looks in any direction. No column index number to break. Defaults to exact match. Cleaner syntax.
Sample Answer 1
“=XLOOKUP(lookup_value, lookup_array, return_array). No column number, no direction restriction, defaults to exact match. If the company runs Microsoft 365 or Excel 2021+, XLOOKUP is the better option every time.”
13. INDEX and MATCH in one line.
MATCH finds the position. INDEX returns the value at that position. Together they replace VLOOKUP with more flexibility.
Sample Answer 1
“=INDEX(B:B, MATCH(“Ravi”, A:A, 0)). MATCH locates Ravi in column A, INDEX grabs the corresponding value from B. Works in any direction. That’s the advantage.”
14. SUMIF and SUMIFS.
SUMIF = sum with 1 condition. SUMIFS = sum with 2+ conditions.
● =SUMIF(City_range, “Mumbai”, Sales_range) ● =SUMIFS(Sales_range, City_range, “Mumbai”, Channel_range, “Online”)
Sample Answer 1
“SUMIFS for my college e-commerce project: total sales for Mumbai, Online channel only. Faster than filtering twice and summing manually.”
15. CONCAT and TEXTJOIN.
Both combine text. CONCAT joins without a separator. TEXTJOIN lets you pick one (comma, space, hyphen) and can skip blanks.
Sample Answer 1
“=TEXTJOIN(‘, ‘, TRUE, A2, B2) gave me ‘Mumbai, Maharashtra.’ Useful for building addresses or creating composite IDs.”
16. LEFT, RIGHT, MID.
Extract parts of text. LEFT grabs from the start. RIGHT from the end. MID from any position.
Sample Answer 1
“Product code ‘MUM-ELC-0045.’ LEFT(A2,3) gets the city code ‘MUM.’ MID(A2,5,3) gets the category ‘ELC.’ Used this to break down invoice numbers in a college project.”
17. TRIM.
Removes extra spaces. Sounds boring until you’ve spent 20 minutes figuring out why your VLOOKUP returns #N/A when the value is clearly right there.
Sample Answer 1
“TRIM is the first thing I try when a lookup fails for no obvious reason. 9 times out of 10, it’s an invisible space. TRIM fixes it in one step.”
18. Common Excel errors.
● #N/A: Value not found. Lookup issue. ● #VALUE!: Wrong data type. Text where a number should be. ● #REF!: Formula points to a cell that got deleted. ● #DIV/0!: Dividing by zero or blank.
Sample Answer 1
“When I see an error, I check in this order: references first, then data types, then missing values. Catches the problem in under a minute almost every time.”
Pivot Table and Reporting Questions
19. What is a PivotTable?
Summarises large data into readable reports. 10,000 rows become a 1-page summary: sales by city, orders by product, revenue by month. That’s why every company uses them.
Sample Answer 1
“Sir/Ma’am, in my college project I had 10,000 rows of sales data. PivotTable turned that into a summary showing 3 out of 12 cities accounted for 60% of revenue. Took about 2 minutes to build.”
20. How do you create one?
Select data → Insert → PivotTable → drag fields into Rows, Columns, Values, Filters.
Sample Answer 1
“Select the range. Insert → PivotTable. New sheet. Drag City into Rows, Sales into Values (as Sum), Month into Filters. Under 2 minutes.”
21. Sum vs. Count in a PivotTable.
Sum adds values. Total revenue. Count counts rows. Number of orders.
Sample Answer 1
“Drag Sales into Values, you see total revenue by city. Drag Order ID into Values, you see how many orders per city. Same data, different question. Interviewers like it when you explain it this way.”
22. What’s a Slicer?
Clickable visual filter for a PivotTable. Buttons instead of dropdowns. Non-technical people love them because you just click to filter.
Sample Answer 1
“Slicers make dashboards usable for people who don’t know how PivotTable filters work. One button per city, click to filter. Useful when sharing reports with managers.”
23. How do you refresh a PivotTable?
Right-click → Refresh. PivotTables don’t auto-update. If the source data changed, you refresh manually. If new rows were added, update the data source range too (or use an Excel Table so it expands automatically).
Sample Answer 1
“Right-click, Refresh. If the data range grew, I also update the source. Or I use an Excel Table as the source from the start so it auto-expands.”
Charts and Formatting Questions
24. Which chart for what?
● Trends over time: Line chart. ● Comparing categories: Bar or column chart. ● Proportion of a whole: Pie chart. But honestly, bar charts are clearer once you have more than 3 or 4 slices.
Sample Answer 1
“12 months of sales trends? Line chart. Which city performed best? Bar chart. Market share split? Pie, but only if it’s 3 to 4 segments. Beyond that, pie charts turn into a mess.”
25. Conditional Formatting.
Changes how cells look based on rules. Colours, icons, data bars. Highlights patterns without touching the actual data.
Sample Answer 1
“Overdue dates go red. Sales below target go yellow. Top 10% get green. During my project I used a colour scale on 500 rows to spot bottom performers instantly. Took 30 seconds to set up.”
Practical Workplace Excel Questions
26. Two customer email lists. How do you find what’s missing from list B?
XLOOKUP each email from List A against List B. Whatever returns “Not Found” or #N/A is missing. Filter for those.
Sample Answer 1
“Helper column: =XLOOKUP(A2, ListB_range, ListB_range, ‘Not Found’). Filter for ‘Not Found.’ That’s my missing list. Or Conditional Formatting to highlight differences. Either works.”
27. How do you keep data entry consistent?
Data Validation. Dropdown lists. Users pick from set options instead of typing freehand. Prevents “Mumbai” vs. “mumbai” vs. “Bombay” from wrecking your reports.
Sample Answer 1
“Dropdowns for any column with a fixed set of values. Lock headers. Protect structure. No more spelling variations breaking downstream formulas.”
28. Split “Full Name” into First and Last Name?
Simple case: Text to Columns, space as delimiter. Complex names with middle initials? LEFT + FIND formula combo. Really messy data? Power Query.
Sample Answer 1
“Text to Columns if it’s clean ‘First Last’ format. If there are middle names or initials, =LEFT(A2, FIND(‘ ‘,A2)-1) for the first name. Messy patterns, Power Query handles it better.”
29. Dates stored as text. How do you fix them?
Happens all the time with pasted or imported data. Dates look fine but formulas ignore them.
Quick check: real dates align right. Text dates align left. Fix with Text to Columns (date format), DATEVALUE(), or multiply by 1 for numeric text.
Sample Answer 1
“Cell alignment tells you instantly. Left-aligned? It’s text. I fix with Text to Columns set to Date, or =DATEVALUE(A2). Hit this exact problem during my internship importing web portal data.”
30. Excel file is slow. What do you do?
This tells the recruiter you’ve actually worked with big files. Textbook-only freshers have never experienced a slow spreadsheet.
● Kill volatile formulas (INDIRECT, OFFSET) where you can. ● Convert finished formulas to values. ● Cut back Conditional Formatting rules (they recalculate on every edit). ● Use Tables and PivotTables instead of heavy array formulas. ● Split the file if it’s above 50 MB.
Sample Answer 1
“Sir/Ma’am, first I check for volatile formulas and excessive Conditional Formatting. Both recalculate constantly. Then convert final formulas to values. My college project had a 40,000-row file that froze every few seconds. Replaced 3 INDIRECT formulas with direct references and it ran fine.”
Excel Shortcuts Every Fresher Should Know
Don’t need 50. These 10 are enough:
● Ctrl + C / V / X: Copy, paste, cut. Basic but interviewers notice if you mention them like muscle memory. ● Ctrl + Z / Y: Undo, redo. ● Ctrl + F: Find. ● Ctrl + Shift + L: Toggle filters. The single most useful daily shortcut. ● Ctrl + Arrow keys: Jump to the edge of data. ● Ctrl + Shift + Arrow keys: Select big ranges fast. ● Alt + =: Auto-sum. ● F2: Edit a cell directly.
If you remember only one: Ctrl + Shift + L. Toggling filters fast makes you look like someone who lives in Excel, not someone who opened it for a college assignment once.
How NOT to Answer Excel Interview Questions
● Don’t say “I know Excel” and then blank on every function. 8 out of 10 freshers say this. It means absolutely nothing without a follow-up. ● Don’t guess syntax. Say what the formula does logically (“I’d use a lookup to match this column against that one”) and admit you’d verify syntax. A wrong formula with fake confidence is worse than an honest “let me check.” ● Don’t claim Power Query or VBA unless you’ve genuinely used them. One follow-up question is all it takes. ● Don’t panic at errors. Walk through your process: check references, check data types, check for blanks. That method matters more than instant answers. ● Don’t just name a function. “I’d use SUMIFS” is okay. “I’d use SUMIFS because I need to sum based on 2 conditions, city and product” is what actually gets you the job.
Frequently Asked Excel Interview Questions for Freshers Discussion Interviews
What Excel topics matter most for freshers? IF, COUNTIF, SUMIF/SUMIFS, VLOOKUP or XLOOKUP, text functions (TRIM, LEFT, RIGHT), PivotTables, data cleaning. These 7 cover 90% of interview questions.
Do freshers get asked about PivotTables? Yes. Especially for ops, MIS, analyst-adjacent roles. Know what it is, how to build one, how to refresh it. That’s enough.
Is VLOOKUP still relevant in 2026? Still asked. But interviewers want you to know its limits and mention XLOOKUP or INDEX-MATCH as alternatives. “VLOOKUP can’t look left, so I’d use XLOOKUP” scores well.
What if I don’t know a formula? Explain the logic. “I’d break the problem into steps, figure out if it needs a lookup or conditional sum, and check documentation for syntax.” Calm problem-solving beats panicked guessing.
Fastest way to practise before an interview? 50-row table. Name, City, Product, Sales, Date. SUMIFS by city. One PivotTable. One chart. Conditional Formatting on high values. That exercise covers 80% of what they test.
Which roles ask Excel questions? Operations, MIS, sales support, HR ops, customer support reporting, admin, junior analyst. If the posting mentions “Excel” or “MIS,” expect 3 to 5 questions minimum.
