Excel Interview Prep — MIS Executive

By Ravindra Bagale · Last updated: 31 October 2026

Friends, mIS desk mode: refresh checklist, KPI dictionary, slicers, exceptions and control totals. Reliability beats fancy charts.

Fictional sample data for learning. Industry flavour: National retail MIS desk (Mumbai / Manchester) ₹ / £. Brands and people are made up for practice.

Why → What → How

Why: Excel interviews are not memory tests of every function name. They check if you can clean a small sheet, write a correct formula, and explain the result in plain English.

What: This page has 28 real interview-style questions for MIS Executive. Each one has a short answer, vertical steps, a tiny example, a common wrong answer, and a follow-up question.

How — study plan:

Skim all question titles once (10 minutes).
Download the practice workbook and open sheet About this data.
Answer aloud, then type the formula in the file.
Check the yellow cells on sheet Answers only after you try.
Revise with the three cards and take the quiz.

Download practice file: practice-mis-interview.xlsx (includes About this data, practice sheets, Answers).

Ravindra Bagale's Tip

Friends, put control totals on every pack — that habit gets you hired and trusted.

Ravindra Bagale's Tip

Define the KPI before you chart it. Dictionary first, colours later.

Questions (28)

Q1 · Theory

What is an MIS refresh discipline?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Same steps every time: land files → refresh queries → refresh pivots → check control totals → save dated copy → send pack.

How — tiny example (vertical steps):

Write steps on About.
Never skip controls.

Formula: (checklist)
Result: reliable pack
What it means: Trustworthy MIS.

Common wrong answer: Refreshing only the sheet you see.

Follow-up they often ask: What do you log after refresh?

Q2 · Theory

Why a standardised template?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Same columns and sheet names every month so Power Query and Pivot do not break.

How — tiny example (vertical steps):

Freeze header names.
Version the template.

Formula: (template)
Result: stable schema
What it means: Less firefighting.

Common wrong answer: Renaming City to Town in month 7.

Follow-up they often ask: How do you communicate a schema change?

Q3 · Theory

KPI dictionary sheet — what is on it?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): KPI name, definition, formula, owner, source, refresh timing, good/bad direction.

How — tiny example (vertical steps):

One row per KPI.
Link dashboard to dictionary.

Formula: (KPI dict)
Result: definitions
What it means: No ambiguous metrics.

Common wrong answer: Putting definitions only in a WhatsApp chat.

Follow-up they often ask: Who owns each KPI?

Q4 · Practical

Build a Pivot + slicer pack for City and Month.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): One Pivot, slicers for City and Month, sync if multiple pivots.

How — tiny example (vertical steps):

Insert slicers.
Report connections if needed.

Formula: (slicers)
Result: interactive MIS
What it means: Manager self-serve.

Common wrong answer: Ten separate filtered sheets instead of slicers.

Follow-up they often ask: How do you reset all slicers?

Q5 · Theory

Month folder automation via Power Query?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Drop new month file in folder; From Folder query picks it up on Refresh All.

How — tiny example (vertical steps):

Stable file name pattern.
Combine files.

Formula: (From Folder)
Result: auto month
What it means: Less manual append.

Common wrong answer: Copy-pasting into a master every month.

Follow-up they often ask: What if schema drifts?

Q6 · Formula

Exception report with FILTER.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): FILTER rows where KPI breaches a threshold for a follow-up list.

How — tiny example (vertical steps):

=FILTER(data, variance<-0.1).

Formula: =FILTER(A2:F100,E2:E100<-0.1)
Result: exceptions
What it means: Action list.

Common wrong answer: Sending the full dump without exceptions.

Follow-up they often ask: How do you email only exceptions?

Q7 · Theory

Version control of MIS workbooks?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Date in file name, OneDrive history, change log on About, never edit prior locked months in place without a copy.

How — tiny example (vertical steps):

MIS_Sales_2026-10-31.xlsx

Formula: (version)
Result: audit trail
What it means: Recoverable packs.

Common wrong answer: Overwriting yesterday without backup.

Follow-up they often ask: Who can edit prod files?

Q8 · Theory

Email-ready PDF summary steps?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Set print area, one page wide, export PDF, check page breaks, attach with short commentary.

How — tiny example (vertical steps):

Page Layout → break preview.
Export PDF.

Formula: (PDF)
Result: CFO pack
What it means: Readable offline.

Common wrong answer: Emailing a 40-sheet workbook as the only deliverable.

Follow-up they often ask: What goes in the email body?

Q9 · Formula

Data validation for MIS input form.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Lists for City/Status, whole numbers for qty, dates for order date — stop junk at entry.

How — tiny example (vertical steps):

Data Validation lists.

Formula: (DV)
Result: clean inputs
What it means: Better upstream data.

Common wrong answer: Free text for status codes.

Follow-up they often ask: How do you cascade region→city?

Q10 · Scenario

Numbers changed after you sent the pack — what do you do?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Re-open dated file, compare control totals, find which source refreshed, issue a revision note.

How — tiny example (vertical steps):

Diff controls.
Revise PDF with version B.

Formula: (revision)
Result: honest correction
What it means: Professional MIS.

Common wrong answer: Quietly resending without saying what changed.

Follow-up they often ask: How do you prevent silent refresh?

Q11 · Theory

One workbook vs many linked workbooks?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Prefer one workbook with multiple sheets/queries when possible. Links break on path changes.

How — tiny example (vertical steps):

Document any remaining links.

Formula: (architecture)
Result: fewer breaks
What it means: Stable refresh.

Common wrong answer: 20 workbooks linked across personal drives.

Follow-up they often ask: How do you find external links?

Q12 · Formula

TEXT for report labels (month name).

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): =TEXT(date,"mmm-yyyy") for headers that stay readable in PDFs.

How — tiny example (vertical steps):

=TEXT(EOMONTH(TODAY(),-1),"mmm-yyyy").

Formula: =TEXT(A1,"mmm-yyyy")
Result: Oct-2026
What it means: Report header.

Common wrong answer: Typing month name manually each time.

Follow-up they often ask: Locale issues with TEXT?

Q13 · Practical

Control total panel on a dashboard.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Cells that must match: row count, sum amount, distinct cities — compared to source.

How — tiny example (vertical steps):

=COUNTA / =SUM / =COUNTA(UNIQUE()).

Formula: =SUM(Amount)
Result: control
What it means: Green = matched.

Common wrong answer: Decorative KPIs with no control.

Follow-up they often ask: Conditional format green/red?

Q14 · Theory

What is a data contract with the ops team?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Written agreement on columns, types, arrival time, and who fixes bad files.

How — tiny example (vertical steps):

Publish the contract on the About sheet.

Formula: (contract)
Result: clear ownership
What it means: Fewer surprises.

Common wrong answer: Accepting any CSV shape every week.

Follow-up they often ask: What happens on breach?

Q15 · Formula

COUNTIF late rows for SLA MIS.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): COUNTIF Status="Late" or Mins>threshold.

How — tiny example (vertical steps):

=COUNTIF(Status,"Late").

Formula: =COUNTIF(F:F,"Late")
Result: late count
What it means: SLA KPI.

Common wrong answer: Counting Late after filtering another city without SUBTOTAL.

Follow-up they often ask: Late % formula?

Q16 · Theory

Colour standards in MIS?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Blue/yellow inputs, black formulas, red negatives, green OK — stay consistent across packs.

How — tiny example (vertical steps):

Document in About.

Formula: (colours)
Result: readable
What it means: Team convention.

Common wrong answer: Random colours every month.

Follow-up they often ask: Colour-blind friendly?

Q17 · Scenario

Stakeholder wants a new KPI mid-month.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Add to dictionary first, define formula, backfill if needed, then dashboard. Do not invent silently.

How — tiny example (vertical steps):

Dictionary → build → validate → publish.

Formula: (change mgmt)
Result: governed KPI
What it means: No shadow metrics.

Common wrong answer: Adding a chart without a definition.

Follow-up they often ask: Who approves?

Q18 · Practical

Build UNIQUE list of owners for a coverage check.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): SORT(UNIQUE(Owner)) and COUNTIF coverage.

How — tiny example (vertical steps):

Compare to employee master.

Formula: =SORT(UNIQUE(G2:G200))
Result: owners
What it means: Coverage gap.

Common wrong answer: Assuming every owner submitted data.

Follow-up they often ask: How do you flag missing owners?

Q19 · Theory

Pivot cache refresh gotchas?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Changing source range without updating Pivot cache; old names stick. Use Tables so range grows.

How — tiny example (vertical steps):

Ctrl+Alt+F5.
Change Data Source if needed.

Formula: (Pivot cache)
Result: fresh fields
What it means: Correct MIS.

Common wrong answer: Inserting columns left of source and wondering fields vanished.

Follow-up they often ask: Tables help how?

Q20 · Formula

IFERROR around XLOOKUP for dimension map.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Map codes to names; show "Unmapped" for follow-up.

How — tiny example (vertical steps):

=IFERROR(XLOOKUP(code,map[code],map[name]),"Unmapped").

Formula: =IFERROR(XLOOKUP(...),"Unmapped")
Result: Unmapped
What it means: Data quality KPI.

Common wrong answer: Leaving #N/A in the board pack.

Follow-up they often ask: How do you count Unmapped?

Q21 · Theory

Access control for MIS files?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Share read-only PDF to wide audience; editable file to owners only. Use OneDrive permissions.

How — tiny example (vertical steps):

Separate edit vs view links.

Formula: (ACL)
Result: least privilege
What it means: Safer MIS.

Common wrong answer: Open edit link on WhatsApp groups.

Follow-up they often ask: How do you revoke access?

Q22 · Practical

Month-on-month column with structured references.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Table columns Actual, Prior, MoM =[@Actual]-[@Prior].

How — tiny example (vertical steps):

Add calculated column.

Formula: =[@Actual]-[@Prior]
Result: MoM
What it means: Trend MIS.

Common wrong answer: Broken ranges when rows added.

Follow-up they often ask: % MoM formula?

Q23 · Theory

What do you put in the email subject of an MIS pack?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Product + period + version + status, e.g. Sales MIS Oct-2026 v1 FINAL.

How — tiny example (vertical steps):

Keep searchable.

Formula: (subject)
Result: findable
What it means: Professional comms.

Common wrong answer: Subject: "file" or "pls see".

Follow-up they often ask: Where is the commentary?

Q24 · Scenario

Source file arrived late — communication?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Tell stakeholders ETA, publish partial with watermark DRAFT if needed, then FINAL when complete.

How — tiny example (vertical steps):

Status message early.

Formula: (comms)
Result: no silence
What it means: Trust.

Common wrong answer: Saying nothing until FINAL late evening.

Follow-up they often ask: Who is on the escalation list?

Q25 · Formula

LARGE/SMALL for top/bottom exceptions.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): LARGE(range,1) top value; combine with INDEX/MATCH for the label.

How — tiny example (vertical steps):

=INDEX(City,MATCH(LARGE(Amt,1),Amt,0)).

Formula: =LARGE(E2:E100,1)
Result: top amount
What it means: Exception highlight.

Common wrong answer: Sorting the sheet in place every time.

Follow-up they often ask: Top 3 with TAKE/SORT?

Q26 · Theory

Why separate staging and presentation sheets?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Staging holds raw/query output; presentation is formatted for humans. Prevents accidental edits to raw.

How — tiny example (vertical steps):

Hide staging or protect it.

Formula: (layers)
Result: safe design
What it means: Clean architecture.

Common wrong answer: Formatting raw query output in place only.

Follow-up they often ask: Can PQ load to staging?

Q27 · Practical

Build a one-page print layout.

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Margins, landscape, fit 1 page wide, title, date, confidentiality footer.

How — tiny example (vertical steps):

Page Setup.
Print preview.

Formula: (print)
Result: 1 page
What it means: Board ready.

Common wrong answer: Tiny fonts to force fit without dropping charts.

Follow-up they often ask: Header/footer fields?

Q28 · Theory

Interview closer: how do you know the MIS is right?

Why interviewers ask: To see if you understand the idea, not only the button clicks.

What (short answer): Control totals, recon to source system, peer check, and a written definition for every KPI.

How — tiny example (vertical steps):

Show the control panel.

Formula: (quality)
Result: evidence
What it means: Strong answer.

Common wrong answer: Because the chart looks nice.

Follow-up they often ask: What is your rollback plan?

Practice tasks (12)

1. Write refresh checklist on About (easy)
Hint: Include control totals step.
2. KPI dictionary 5 rows (medium)
Hint: Name, formula, owner, direction.
3. Pivot + City/Month slicers (medium)
Hint: Click inside Pivot first.
4. FILTER exception variance<-10% (medium)
Hint: Threshold in a cell.
5. Unmapped XLOOKUP count (medium)
Hint: IFERROR then COUNTIF Unmapped.
6. MoM calculated column (easy)
Hint: Structured reference [@].
7. Control panel SUM vs Pivot (medium)
Hint: Must match grand total.
8. PDF export one page wide (easy)
Hint: Page Setup fit width.
9. UNIQUE owners coverage (medium)
Hint: Compare to master list.
10. File naming with date version (easy)
Hint: YYYY-MM-DD in name.
11. Data validation on Status (easy)
Hint: List of allowed statuses.
12. Revision note sample text (easy)
Hint: What changed and why.

Quiz (8 questions)

Interview, comparison and revision cards

Standalone cards (no tip or photo strip). Each has a QR to this lesson. Download the PNG and revise offline.

MIS refresh — Revision card 3/3 — Refresh five

Next: back to the Interview Prep hub · related lesson Formulas and Functions.