Excel interview questions for accountants in 2026 test formula knowledge, data handling, and real-world accounting tasks. Most hiring managers ask about VLOOKUP, pivot tables, conditional formatting, and basic financial functions. This guide covers the most frequently asked questions - with answers you can use in an interview, not just memorise.
Why Excel Skills Matter in Accounting Interviews
Walk into any accounts role interview in India today and the first question is almost always Excel-related. Not because Excel is exciting - it isn't - but because it handles every daily task: reconciliations, salary sheets, GST tallies, MIS reports, vendor tracking.
Students who trained at HCI and joined companies like Genpact and HCL consistently tell us that Excel proficiency was the deciding factor in getting shortlisted. Entry-level roles focus on formulas. Senior and MIS roles add pivot tables, data validation, and financial functions.
Excel Interview Questions: Quick-Reference Table
| Category | Common Questions | Frequency in Interviews |
|---|---|---|
| Formulas & Functions | VLOOKUP, SUMIF, COUNTIF, IF, IFERROR | Very High - asked in almost every interview |
| Pivot Tables | Creating, grouping, slicers, refreshing data | High - especially for MIS and reporting roles |
| Data Management | Sorting, filtering, removing duplicates, data validation | Medium - common in data entry and accounts roles |
| Financial Functions | PMT, NPV, SUM, AVERAGE, MIN/MAX | Medium to High - finance and banking roles |
| Shortcuts & Navigation | Ctrl+T, F4, Alt+=, Ctrl+Shift+L | Medium - tests practical working speed |
Formula and Function Questions
1. What does VLOOKUP do, and where would you use it in accounting?
VLOOKUP searches for a value in the leftmost column of a table and returns a value from a specified column in the same row. In accounting, use it to match invoice numbers against a payment register, or pull employee names into a salary sheet. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). Always use FALSE as the last argument in accounting work - it means exact match.
2. What is the difference between VLOOKUP and XLOOKUP?
XLOOKUP is the modern replacement available in Excel 2021 and Microsoft 365. It searches in any direction, doesn't require column counting, and handles errors more cleanly. VLOOKUP is still essential because many Indian offices run Excel 2016 or 2019. Know both - if an interviewer asks about XLOOKUP, explaining the difference and confirming you know both is the right answer.
3. How does SUMIF work? Give an accounting example.
SUMIF adds values in a range that meet one condition. Example: =SUMIF(A:A,"Sales",B:B) totals all expenses in column B where column A says "Sales". SUMIFS handles multiple conditions - for instance, summing Sales expenses for a specific month. Heavily used in departmental expense reports and vendor payment summaries.
4. What is the IFERROR function and why is it useful?
IFERROR catches formula errors and replaces them with a value you specify. Without it, a VLOOKUP that can't find a match throws #N/A - which breaks downstream calculations and looks unprofessional in shared reports. With IFERROR: =IFERROR(VLOOKUP(...),"Not Found"). In payroll or GST sheets where missing data is sometimes expected, this keeps output clean.
5. What is the difference between absolute and relative cell references?
A relative reference (A1) shifts when you copy a formula elsewhere. An absolute reference ($A$1) stays fixed regardless of where you paste. In accounting, absolute references appear constantly - for example, multiplying a column of values by a single tax rate stored in one fixed cell. Press F4 while clicking a reference to toggle between relative and absolute.
6. What does COUNTIF do?
COUNTIF counts cells in a range that meet a condition. Use it to count unpaid invoices, employees in a department, or transactions above a threshold. COUNTIFS handles multiple conditions. Common in audit support work and exception-reporting tasks where you need counts, not sums.
Pivot Table Questions
7. What is a pivot table and when would you use one?
A pivot table summarises large datasets into a compact report - no formulas needed. Drag fields into rows, columns, and values areas and Excel aggregates the data. In accounting, pivot tables are standard for monthly expense summaries, GST category breakdowns, and vendor payment analysis. Any dataset with more than a few hundred rows benefits from a pivot table rather than manual SUMIF formulas.
8. How do you refresh a pivot table when source data changes?
Right-click inside the pivot table and select Refresh. If new rows fall outside the original range, update the source via PivotTable Analyze → Change Data Source. The cleaner solution - worth mentioning in an interview - is to format source data as an Excel Table (Ctrl+T) before building the pivot. Tables expand automatically, so new rows are always included on refresh.
9. How do you group data by month in a pivot table?
Right-click any date in the row area and choose Group, then select Months (and Years if data spans multiple years). If grouping is greyed out, dates are stored as text rather than proper Excel dates - fix this using DATEVALUE or by reformatting the source column. This is a common real-world problem worth mentioning.
Want to master Excel for your next accounting job?
HCI's Advanced Diploma in Financial Accounting (ADFA) and MDCAA courses cover Advanced Excel, Tally Prime, GST, and MIS reporting - exactly what hiring companies test. Book a free counselling session to find the right course for your goal.
Data Management and Shortcuts
10. How do you remove duplicate entries from a dataset?
Data tab → Remove Duplicates. Select which columns to check - Excel removes rows where all selected columns match. For financial data, always review before deleting: two transactions on the same date for the same amount aren't always duplicates. Safer approach: flag with COUNTIFS first, review, then delete confirmed duplicates manually.
11. What is conditional formatting?
Conditional formatting changes a cell's colour or style based on its value. In accounts, use it to highlight overdue invoices in red, flag expenses over budget in orange, or mark the top 10% of values. It makes exceptions visible at a glance without scanning rows manually - and interviewers notice when you can describe a practical use case.
12. What are some Excel shortcuts every accountant should know?
| Shortcut | Action | When to Use It |
|---|---|---|
| Ctrl + T | Convert range to Table | Before building pivot tables or charts |
| Alt + = | AutoSum | Summing a column or row instantly |
| F4 | Toggle absolute reference / repeat last action | Locking cell references in formulas |
| Ctrl + Shift + L | Toggle AutoFilter | Quick filtering on any data range |
| Ctrl + 1 | Format Cells dialog | Number, date, and currency formatting |
| Ctrl + D | Fill Down | Copying a formula down a column |
Accounts-Specific Questions
13. How would you build a simple bank reconciliation in Excel?
List book transactions in one column, bank statement transactions in another. Use VLOOKUP or MATCH to identify entries that appear in both. Unmatched entries on either side are your reconciling items. Add conditional formatting to highlight unmatched rows, and a running balance column using SUM with an absolute reference for the opening balance.
14. What is the difference between #N/A and #VALUE! errors?
#N/A means the formula couldn't find what it was looking for - most often a VLOOKUP with no matching entry. Usually a data issue: mismatched formats, extra spaces, or a missing entry. #VALUE! means the formula received the wrong data type - like adding a text cell to a number. Both are fixable; the question tests whether you can diagnose them calmly.
15. What is Power Query, and have you used it?
Power Query (Data tab → Get & Transform) imports, cleans, and reshapes data from multiple sources without formulas. In accounting, it combines monthly files, removes blank rows, and standardises formats - tasks that would take hours manually. Increasingly asked in MIS Analyst and senior accounts roles. Available in Excel 2016 and above.
How HCI Prepares Students for Excel Interviews
At Hindustan Computer Institute, MS Excel is taught as a working tool - not a list of functions to memorise. In the ADFA course, students build actual MIS reports, salary sheets, and GST summary tables during training, so interview questions feel familiar by the time they sit one.
HCI is ISO 9001:2015 certified and MSME-registered under the Government of India. Students who take the ADFA or MDCAA also learn Tally Prime and Marg ERP alongside Excel - exactly the combination most accounts job listings ask for. With 2,500+ students trained across J&K, Billawar, Kathua, and Samba, the Excel skills practised in class are the same ones that come up in those interviews.
Accounts interviewers want someone who can think clearly with data, handle errors without freezing, and learn new tools efficiently. Those qualities come from practice - not from cramming the night before. If you want structured practice with real accounting datasets, book a free counselling session at HCI. No pressure, no sales pitch - just an honest conversation about where to start.
Author: Dinesh Sharma, Founder & CEO, Hindustan Computer Institute (MS Excel, AI Tools & Computer Applications expert)
Last Updated: June 2026
