Excel Interview Questions for MIS Executive Roles (With Practical Answers)
The Excel questions MIS interviewers actually ask, with answers that show you can build and maintain real reports, plus how to handle the practical test.
MIS (management information system) executives keep a business’s numbers flowing: daily sales reports, attendance trackers, collection summaries, stock positions and the monthly review deck. Almost all of it runs on Excel, so interviews for these roles test Excel heavily, and often with a laptop in front of you. These Excel interview questions for MIS roles are the ones that come up again and again, with answers that show you can do the work, not just name functions.
They reflect what we teach and practise in our Advanced Excel course, where every topic is tied to a real report.
Quick answer: MIS interviews test lookups (XLOOKUP, INDEX MATCH), conditional totals (SUMIFS, COUNTIFS), pivot tables, date functions, data cleaning, validation and dashboards, usually with a short practical test. Answer each question with the function, a real example and one pitfall you would watch for. Practise on one realistic dataset until you can build a summary report in 15–20 minutes.
What MIS interviewers are really checking
Behind every question are four things:
- Accuracy. Can you produce numbers that tie back to the source?
- Speed. Can you do it without hunting through menus?
- Repeatability. Will your report still work next month with new data?
- Communication. Can you explain what the numbers mean to a manager?
Keep these in mind and your answers will naturally include the “why”, which is what separates a good candidate from a list of shortcuts.
Lookup and matching questions
1. How would you bring a customer’s region from another sheet into the sales sheet?
“I’d use XLOOKUP: =XLOOKUP(B2, Customers[CustomerID], Customers[Region], "Not found"). It looks up the ID, returns the region and shows ‘Not found’ instead of #N/A, which makes gaps easy to filter. In older files I’d use INDEX MATCH, which also doesn’t break when columns are inserted.”
If you want a deeper comparison to quote from, see XLOOKUP vs VLOOKUP vs INDEX MATCH.
2. Your VLOOKUP returns #N/A for values that clearly exist. Why?
Three usual causes:
- Extra spaces: fix with
TRIM. - Numbers stored as text in one sheet and numbers in the other: convert with
VALUEor Text to Columns. - Approximate match by accident: the last argument was left blank, so it wasn’t
FALSEor0.
Mention that you check with =A2=Sheet2!A2 or LEN to spot hidden differences. Interviewers love a systematic answer.
3. How do you find which IDs are in this month’s list but missing from last month’s?
“=COUNTIF(LastMonth[ID], A2)=0 flags new IDs. In Microsoft 365 I’d use =FILTER(ThisMonth[ID], COUNTIF(LastMonth[ID], ThisMonth[ID])=0) to list them in one go.” Reconciliations like this are a daily MIS task.
Conditional totals and counts
4. Total sales for the East region in March, for one product
=SUMIFS(Sales[Amount], Sales[Region], "East", Sales[Product], "Notebook", Sales[Date], ">="&DATE(2026,3,1), Sales[Date], "<="&EOMONTH(DATE(2026,3,1),0))
Point out that you’d put the region, product and month in input cells and reference them, so the same formula serves every combination.
5. SUMIF vs SUMIFS?
SUMIF takes one condition, with the sum range last. SUMIFS takes many conditions, with the sum range first. “I use SUMIFS everywhere for consistency, even with one condition.”
6. How do you count unique customers who ordered this month?
In Microsoft 365: =COUNTA(UNIQUE(FILTER(Sales[CustomerID], MONTH(Sales[Date])=3))). In older versions, a pivot table with the data added to the Data Model, using Distinct Count. Knowing both shows you can work with whatever version the company has.
Pivot table questions
7. Build a region-by-month summary from 20,000 rows. Walk me through it.
“Convert the data to a Table with Ctrl+T, insert a PivotTable, Region in Rows, Date in Columns grouped by Months and Years, Amount in Values as Sum, number format through Value Field Settings, then a slicer for Product. Because it’s built on a Table, a refresh picks up new rows.” Our pivot table tutorial walks through every step if you need to rehearse.
8. The pivot shows Count of Amount instead of Sum. Why?
There are blanks or text in the Amount column. Fix the source, refresh, and change the summary to Sum.
9. How would you show each branch’s share of total sales?
Add Amount to Values twice and set the second to Show Values As > % of Grand Total (or % of Column Total for share within a month).
Date and time questions
MIS reports are full of dates, so expect at least one.
| Task | Function | Example |
|---|---|---|
| Month-end date | EOMONTH |
=EOMONTH(A2,0) |
| Working days between two dates | NETWORKDAYS |
=NETWORKDAYS(A2,B2,Holidays) |
| Ageing of an invoice | Subtraction | =TODAY()-InvoiceDate |
| Month name for a report | TEXT |
=TEXT(A2,"mmm-yy") |
| Financial year (April start) | IF with MONTH |
=IF(MONTH(A2)>=4,YEAR(A2),YEAR(A2)-1) |
10. How would you build a receivables ageing report?
“Add a Days Overdue column with =TODAY()-DueDate, then a bucket column with IFS: 0–30, 31–60, 61–90, 90+. A pivot with Customer in Rows, Bucket in Columns and Amount in Values gives the ageing summary.” This is a classic MIS question in finance teams.
Data cleaning and quality
11. You receive a CRM export with messy names, extra spaces and mixed date formats. What do you do?
“First, keep the raw file untouched. Then I’d load it into Power Query, trim and clean text, set proper types for dates and numbers, remove duplicates and close and load to a Table. Next month I just replace the file and click Refresh.” If they don’t use Power Query, mention TRIM, PROPER, Text to Columns and Remove Duplicates as the manual route.
12. How do you stop people entering wrong values in a shared tracker?
Data Validation: dropdown lists from a Table for branch names, date ranges for dates, whole numbers for quantities, plus an input message. Protect the sheet with formula cells locked and input cells unlocked.
13. How do you check your report is correct before sending it?
A strong answer: “I tie the report total back to the source total, spot-check three or four figures by double-clicking pivot values, check row counts after any merge, and compare with last period to catch anything that jumped unexpectedly.”
Reporting and dashboard questions
14. What makes a good one-page MIS dashboard?
- Three to five key numbers at the top (for example sales, target achievement, collections)
- One trend chart and one comparison chart
- Slicers for period and branch
- Conditional formatting for exceptions only, not rainbow tables
- A “data as of” date
15. How would you automate a daily report?
Power Query for the data, a pivot or formula layer for the summary, and a refresh. For tasks like emailing or saving copies, a small VBA macro or Power Automate flow. Mention that you’d document the steps so someone else can run it if you’re on leave.
The practical test: how to handle it
Many MIS interviews end with a 20–40 minute task. Typical ones:
- Summarise a sales sheet by region and month, with totals and % share
- Match two lists and highlight mismatches
- Build an attendance or ageing summary
- Clean a messy export and create a pivot
How to approach it:
- Read the whole task first and list the outputs they want.
- Convert data to a Table before anything else.
- Do the core numbers first, formatting last.
- Check totals against the source.
- Label clearly and leave a short note of assumptions.
Finishing a correct, plain report beats a beautiful half-finished one.
Questions you can ask them
- Which reports does the team send daily, weekly and monthly?
- Where does the data come from: ERP, CRM, Google Sheets?
- Which Excel version does the team use? Is Power BI in the picture?
- How much of the current reporting is manual?
These show you are thinking about the job, not just the interview.
A 7-day prep plan
| Day | Practise |
|---|---|
| 1 | Lookups and the #N/A fixes |
| 2 | SUMIFS and COUNTIFS with input cells |
| 3 | Pivot tables, grouping and % of total |
| 4 | Dates: EOMONTH, NETWORKDAYS, ageing |
| 5 | Power Query clean-up of a messy export |
| 6 | A one-page dashboard with slicers |
| 7 | Two timed practical tests, explained out loud |
For a broader view of what to learn after the interview, read our guide to advanced Excel skills employers want. Microsoft’s Excel help and learning pages explain each function in detail.
Learn it with Omebly
Omebly Academy’s Advanced Excel course is live and mentor-led, with recordings and weekly one-to-one reviews.
- Core (3 months, $699): formula mastery, text and date functions, XLOOKUP and dynamic arrays; pivot tables, Power Pivot and Power Query; dashboards, financial models and VBA macros. Two capstones.
- Professional (6 months, $1,199): adds advanced modelling, scenario analysis, Office Scripts and Power Automate, with four capstones (including a one-click monthly reporting pipeline), mock interviews and portfolio review.
- Career (12 months, $1,999): adds SQL and Power BI for Excel users, a live client-style reporting project and placement assistance (CV and LinkedIn help, mock interviews, portfolio review, referrals where possible; no job guarantee).
You receive an Omebly certificate of completion with your projects listed.
Preparing for an interview soon? Contact us or message us on WhatsApp.
Frequently asked questions
What Excel skills are needed for an MIS executive?
Lookups (XLOOKUP or INDEX MATCH), SUMIFS and COUNTIFS, pivot tables, date functions, data cleaning, conditional formatting, data validation and basic charts. Power Query and simple macros are a strong advantage.
Is there a practical test in MIS interviews?
Often, yes. Many MIS interviews include a short task on a laptop, such as summarising a sales sheet, matching two lists or building a small report. Practise doing these against the clock.
Should I say VLOOKUP or XLOOKUP in an interview?
Know both. Explain that XLOOKUP is more flexible and safer when columns move, but that VLOOKUP and INDEX MATCH still appear in older files you may have to maintain.
Do MIS roles need VBA?
Not always, but basic macros help with repeat tasks. Many teams now use Power Query for cleaning and refresh, which needs no code. Being able to explain when you would use each is a good sign.
How do I prepare for an MIS Excel interview in a week?
Take one realistic sales or attendance dataset and practise the questions in this guide daily: lookups, SUMIFS, pivots, dates, cleaning and a one-page summary. Time yourself and say your steps out loud.
Written by
Nazmul Hussain, Managing Director & Technical Head, Omebly. 10+ years building websites and apps for clients in India, the Gulf, the UK and the US, and mentoring at Omebly Academy. LinkedIn · GitHub
Follow Omebly
New guides, work and launches on every channel.
