MIS Executive Interview Questions and Answers
Prepare for questions on lookups, pivot tables, SQL, totals that do not match and automating reports, with answers you can adapt to your own work.
MIS executive interview questions usually test three things: whether you can work with data in Excel and often SQL, whether you check your numbers before sending them, and whether you can meet reporting deadlines without cutting corners. Expect a practical test as well. Many employers give you a dataset and ask for a pivot table, a lookup or a short report within a time limit.
How to prepare for MIS executive interview questions
- Excel. Practise lookups (VLOOKUP, INDEX and MATCH, and XLOOKUP if the employer uses Microsoft 365 or Excel 2021 or later), SUMIFS and COUNTIFS, pivot tables, removing duplicates and conditional formatting.
- SQL. Be ready to write a SELECT with WHERE, GROUP BY and a JOIN. Many MIS roles pull data with SQL before it goes into Excel.
- Reporting. Know how you would build a daily or weekly report, how you would check it and how you would automate it with Power Query or a macro.
- Your own work. Pick two reports you have built and be ready to explain the source data, the checks and who used them.
Freshers can use college projects, an internship or a labelled practice dataset. Say what the data was and what you did with it. Experienced candidates should describe their own part in a report and avoid sharing confidential figures from a current employer.
Introduce yourself in an MIS interview
Give your current role or qualification, the tools you use most and one report someone relied on. For example: "I am an MIS executive at a lending company, where I prepare the daily collections report in Excel from SQL data. I automated its refresh with Power Query, so it is ready by 9 every morning." The one-minute template in the self introduction guide helps you organise it.
Make your resume match your answers
The tools, dates and reports on your resume should match what you say. The MIS executive resume sample shows how to describe reports with their purpose and frequency. Check your own resume against it before the interview.
Interview questions & answers
Excel
1.What is the difference between VLOOKUP and XLOOKUP?
VLOOKUP searches the first column of a range and returns a value from a column to its right, chosen by column number. If you leave out the last argument it uses approximate match, which can return a wrong value from unsorted data, so set it to FALSE for an exact match. XLOOKUP can return a value from either side, uses exact match by default and has its own argument for a value that is not found. It is not available in Excel 2016 or Excel 2019, so check which version the employer uses.
Microsoft Support: VLOOKUP function and XLOOKUP function
2.How would you summarise sales by region and month?
Format the data as a table and check that the dates are real dates, not text. Insert a pivot table with region in rows, month in columns and sales in values, then group the dates by month. Before sharing, check the pivot's grand total against the sum of the source column. If the data grows every day, build the pivot on the table so new rows are included when you refresh.
Microsoft Support: overview of PivotTables and PivotCharts
3.How do you remove duplicates without losing data?
Work on a copy first. Decide what makes a row a duplicate, such as the same customer ID, or the same ID and date. Flag possible duplicates with COUNTIFS or conditional formatting and review them before removing anything, because some are real, such as two orders from one customer on the same day. Record how many rows you removed and why, so the count can be explained later.
4.When would you use SUMIFS instead of a pivot table?
Use SUMIFS when a report needs a fixed layout that updates by itself, such as a monthly summary that managers read in the same format every time. It adds values that meet several conditions, for example sales for one branch in one month. A pivot table is quicker for exploring data and changing the view. Many reports use both: a pivot to check the figures, and SUMIFS to fill the final template.
SQL
1.How would you write a query for total sales per branch in one month?
Explain each part as you write it. For September 2026, a query could be SELECT branch, SUM(amount) AS total_sales FROM sales WHERE sale_date >= '2026-09-01' AND sale_date < '2026-10-01' GROUP BY branch ORDER BY total_sales DESC; Using "earlier than the first day of the next month" includes sales recorded with a time on the last day, which a filter ending on 30 September can miss. Mention that table and column names depend on the company's database.
2.What is the difference between an INNER JOIN and a LEFT JOIN?
An INNER JOIN returns only the rows that match in both tables. A LEFT JOIN returns every row from the first table and leaves the second table's columns empty (NULL) where there is no match. In MIS work this matters. Joining sales to a customer table with an INNER JOIN drops any sale whose customer record is missing, and the report total falls without warning. Compare row counts before and after a join.
Accuracy
1.Your report total does not match the finance team's figure. What do you do?
Do not adjust your number to make it match. First confirm that both figures cover the same period, filters and definitions, such as whether cancelled orders are included. Then compare at a lower level, by day or by branch, to find where the difference starts. Explain the cause to the finance team, agree which definition is correct and note it for future reports.
2.How do you check a report before sending it?
Compare totals with the source system and the row count with the previous run. Look for blanks, negative values and sudden jumps. Compare the main figures with last week or last month and make sure you can explain any large change. Check that filters and date ranges are correct. For an important report, ask a colleague to review a sample before it goes out.
Automation
1.How would you automate a daily report?
Write down the manual steps first. Then remove the repetitive ones: use Power Query to import and clean the source files, formulas or a pivot table for the calculations, and a single refresh to update everything. If the data comes from a database, a saved SQL query can replace manual exports. Keep a short note of the steps so someone else can run the report when you are away.
Dashboards
1.What makes a good MIS dashboard?
It answers the questions its readers actually ask, usually on one screen. Ask the manager which three or four numbers they check first and build around those. Show the period and when the data was last refreshed, use the same definitions as other reports and avoid decorative charts. After a few weeks, check whether people open it. A dashboard nobody uses needs to change.
Deadlines
1.A manager wants a report by evening that usually takes two days. What do you do?
Ask what decision the report supports and which parts are needed today. Offer a shorter version with the key figures, clearly marked as preliminary, and agree when the full version will follow. Do not skip your checks to save time, because a fast wrong number causes more trouble than a late correct one. If even the short version is at risk, tell the manager early.
Role fit
1.What would you ask before joining?
Ask which reports you will own, who uses them and which decisions depend on them. Ask about the tools and versions (Excel, SQL, Power BI), where the data comes from and how often it refreshes. Ask how data access and confidential information are handled. The answers tell you whether the role is mainly reporting, mainly data cleaning or a step toward analysis.
Practise the practical questions on a real dataset, then say two or three of the other answers aloud. You can paste an answer into the free interview answer grader to check that it gives a clear example. Before you apply, run a free resume review to see whether your reports and tools are easy to find on your resume.
Check your own material with the Free interview answer grader.
