CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile
Interview guide

MIS Executive Interview Questions and Answers: 60 Questions from Easy to Hard

This guide is for freshers and working professionals in India preparing for MIS executive interviews in sales, HR and operations teams at FMCG and pharma distributors, banks and NBFCs, BPOs, logistics firms, manufacturers and e-commerce companies. It has 60 questions with model answers in three levels: report basics and core formulas for freshers; multi-source reports, reconciliation, Power Query and SQL for one to three years of experience; and automation, KPI definitions, master data and stakeholder questions for senior and lead roles. Every formula and query was run, and every number recalculated. For Excel functions in more depth, see our Advanced Excel guide. Answer each question aloud in your own words, then take the MIS Executive Excel Test to practise under time.

  • 60 questions, 3 levels
  • Updated
  • CoreHRx Jobs

What MIS executive interviews cover

  • Excel for reporting: lookups against a master, SUMIFS and COUNTIFS, pivot tables, date logic such as MTD and the April to March financial year, and cleaning messy ERP or CRM exports.
  • How you build, check and deliver reports: daily, weekly and monthly formats, control totals, reconciliation with finance, and what you do when the data is late or wrong.
  • For one to three years of experience: Power Query, basic SQL with GROUP BY and CASE, Google Sheets trackers, dashboards and the KPIs of the function you will support.
  • For senior roles: automation choices, report design for management, KPI definitions, master data control and leading a small reporting team to month-end deadlines.
  • Expect a practical Excel test in many interviews. Some employers also add a typing or aptitude test in the first round.

How freshers should prepare

  • Build a 1,000-row sample of invoices with dates, branches, salespeople and amounts, plus a small master sheet, and practise lookups, SUMIFS and pivots on it until you need no help.
  • Make one daily and one monthly report from that data, with MTD, LMTD, achievement and growth, and write down the checks you ran.
  • Learn the business calendar used in Indian reports: the April to March financial year, quarters, month-end and working days with Sundays and holidays.
  • Practise explaining a formula in plain words, including what happens when the data has a blank, a duplicate or a code missing from the master.

How experienced candidates should prepare

  • Prepare two or three report stories: who used the report, where the data came from, what you automated, how long it took before and after, and an error you caught.
  • Be ready to write a GROUP BY query with a date filter and CASE, and to walk through a Power Query you built, step by step.
  • Know the KPIs of your function by definition, not only by name: achievement, growth, DSO, attrition or turnaround time, with the formula and source behind each.
  • For lead roles, prepare examples of settling disagreements about numbers, fixing a late month-end and training juniors.

The practical Excel test

  • Read every task before you start, and copy the raw data to a new sheet so the original stays untouched.
  • Convert the data to a Table first and check for blanks, numbers stored as text and extra spaces before you build lookups and the pivot.
  • Show your checks: a total that matches the raw data and a count of missing lookups earn more credit than neat formatting.
  • If the test machine runs Excel 2016 or 2019, XLOOKUP and FILTER will not work. Be ready to use INDEX with MATCH, SUMIFS or a pivot instead.

Common mistakes to avoid

  • Comparing a part month with a full month, or this month to date with all of last month, and calling the difference growth.
  • Hiding lookup misses with IFERROR, so unmapped sales quietly drop out of the totals.
  • Sending a report without a control total, or typing over numbers in the final sheet where nobody can trace the change.
  • Using TODAY() in every formula, so yesterday's report shows different numbers when someone reopens it.
  • Talking only about formatting and colours. Interviewers want to hear about accuracy, checks, deadlines and the decision each report supports.

MIS Executive interview questions: Easy questions (freshers)

20 questions

1. What does an MIS executive do, and which reports would you expect to own in a sales or operations team?

An MIS executive collects data from the company's systems, checks it and turns it into reports that managers use to run the business. In a sales team that usually means a daily sales flash by branch, a weekly target-versus-achievement report, collection and outstanding reports, and a monthly review pack. In operations it could be dispatch, pending orders, complaint ageing or attendance. The tools are mostly Excel with ERP or CRM exports, and sometimes SQL or Google Sheets. Interviewers check that you see the job as accurate, on-time information for decisions, not as formatting sheets.

2. How is a daily MIS report different from a weekly and a monthly one, in content and in who reads it?

A daily report is short and fast: yesterday's and month-to-date sales, orders or collections by branch, read by branch and area managers who act the same day. A weekly report adds trends and target gaps, often for the regional head's review call. A monthly report is the full picture for senior management: achievement against target, growth over last year, margin, outstanding and exceptions, with comments on the big movements. The longer the period, the more the numbers must tie to finance and the more explanation they need. A strong answer names the reader and the decision each report supports.

3. What do MTD, LMTD, YTD and LYTD mean in a sales MIS, and how do you calculate growth from them?

MTD is month to date, from the 1st of this month to the report date. LMTD covers the same days of last month, so on 18 November you compare 1-18 November with 1-18 October, not with all of October. YTD runs from 1 April, the start of the financial year most Indian companies follow, to the report date, and LYTD is the same span last year. Growth is MTD divided by LMTD, minus 1. In the sample MTD is Rs 22.3 lakh and LMTD Rs 21.5 lakh, so growth is 3.7%. Comparing a part month with a full month is the classic fresher mistake.

Example
     A            B             E1: 18-Nov-2026 (report date)
1  Date         Amount
2  05-Oct-2026  12,00,000
3  17-Oct-2026   9,50,000
4  25-Oct-2026  14,00,000
5  03-Nov-2026  11,50,000
6  12-Nov-2026  10,80,000
7  19-Nov-2026   6,00,000

E2 MTD:  =SUMIFS(B2:B7, A2:A7, ">="&(EOMONTH(E1,-1)+1), A2:A7, "<="&E1)        -> 2230000
E3 LMTD: =SUMIFS(B2:B7, A2:A7, ">="&(EOMONTH(E1,-2)+1), A2:A7, "<="&EDATE(E1,-1)) -> 2150000
E4:      =E2/E3-1                                                                 -> 3.7%

4. How do you calculate target achievement and growth percentages without #DIV/0! errors when a target or last year's figure is zero?

Test the denominator first and say in words what a zero means. A branch with no target shows No target, and a branch with no sales last year shows New, because growth on a base of zero has no meaning. In the sample Pune achieves 96% of target and grows 20%, while Nashik, opened this year, shows the two labels instead of #DIV/0!. Avoid wrapping everything in IFERROR, because it also hides a broken reference or text in a number column. Format the results as percentages, and keep the text labels out of any later total or average.

Example
     A        B         C         D
1  Branch   Actual    Target    Last year
2  Pune     480000    500000    400000
3  Nashik   120000         0         0

E2: =IF(C2=0, "No target", B2/C2)     -> 96%
F2: =IF(D2=0, "New", B2/D2-1)         -> 20%
E3: =IF(C3=0, "No target", B3/C3)     -> No target
F3: =IF(D3=0, "New", B3/D3-1)         -> New
G3: =B3/C3                            -> #DIV/0!

5. What are the current run rate and the required run rate in a monthly sales MIS, and how do you calculate them?

The current run rate (CRR) is what the team has averaged so far: MTD sales divided by the working days gone. The required run rate (RRR) is what it must average from now on: the balance target divided by the working days left. On 18 November, with Sundays off, 15 of November's 25 working days are gone. MTD is Rs 30 lakh against a Rs 60 lakh target, so CRR is Rs 2 lakh a day and RRR Rs 3 lakh a day, and at the current pace the month ends near Rs 50 lakh, or 83% of target. The IF returns 0 once the target is met, and a label on the last day instead of #DIV/0!.

Example
     A                       B
1  Report date             18-Nov-2026
2  MTD sales               3000000
3  Target                  6000000
4  Working days gone       =NETWORKDAYS.INTL(EOMONTH(B1,-1)+1, B1, 11)             -> 15
5  Working days in month   =NETWORKDAYS.INTL(EOMONTH(B1,-1)+1, EOMONTH(B1,0), 11)  -> 25
6  CRR                     =B2/B4                                                   -> 200000
7  RRR                     =IF(B2>=B3, 0, IF(B5=B4, "Month over", (B3-B2)/(B5-B4))) -> 300000
8  Projected month         =B6*B5                                                   -> 5000000
9  Projected achievement   =B8/B3                                                   -> 83%

6. Your sales export has only the employee code. How do you bring in each salesperson's region from the master, and catch codes that are missing from it?

Look up the code in the employee master and return the region, with a clear label for misses instead of #N/A. XLOOKUP does this with its fourth argument, if_not_found. It works in Microsoft 365 and Excel 2021 or later but not in Excel 2016 or 2019, where you would wrap VLOOKUP in IFNA instead. Then count the misses and total their value: here S103 is not in the master, so Rs 92,000 of sales has no region. Never let those rows drop out quietly; show them in the report and ask HR or sales admin to update the master.

Example
     A        B          D        E         F
1  EmpCode  Region     EmpCode  Sales     Region
2  S101     West       S102     185000    North
3  S102     North      S103      92000    Not in master
4  S104     South      S101     240000    West

F2: =XLOOKUP(D2, $A$2:$A$4, $B$2:$B$4, "Not in master")
H1: =COUNTIF(F2:F4, "Not in master")              -> 1
H2: =SUMIFS(E2:E4, F2:F4, "Not in master")        -> 92000

7. What is the difference between master data and transaction data, and why does a wrong master spoil every report?

Transaction data records events: invoices, orders, receipts, attendance punches. Master data describes the things those events refer to, such as the customer, distributor, product, branch or employee, with attributes like region, category or reporting manager. Reports group transactions by master attributes, so one wrong entry spreads everywhere. If distributor D101 is tagged to the wrong area manager, his sales, achievement and incentive are wrong in every report that month. A careful MIS executive keeps one agreed master for each entity, checks every new code against it daily and knows who owns each change.

8. A pivot table shows the same branch twice and a row called (blank). Why, and how do you fix it?

A pivot groups exact values, so Pune and Pune with a trailing space become two items, and empty cells in that field appear as (blank). Fix it in the source, not in the pivot. Clean the branch column with TRIM or in Power Query, fill missing branch names from the master with a lookup on the branch code, and refresh. Better still, build the pivot on the branch code and bring the name in from the master. Then check that the grand total has not changed: cleaning labels should move numbers between rows, never change the total.

9. Your manager asks which invoices make up one number in your pivot table. How do you show them quickly?

Double-click the value, or right-click it and choose Show Details. Excel puts the rows behind that number on a new sheet, for example the 37 invoices behind Rs 4.2 lakh of Surat sales in October. Check that those rows add up to the pivot value before you send or filter them. The new sheet is a static copy that does not refresh, so delete it once the question is answered, or it will confuse the next person who opens the file. If double-clicking does nothing, Enable show details has been switched off on the Data tab of PivotTable Options.

10. Employee codes such as 00451 lose their leading zeros when you open the export. Why, and how do you keep or restore them?

Excel reads 00451 as the number 451, and numbers do not keep leading zeros, so lookups against a master that stores codes as text start failing. In Excel for Microsoft 365 and Excel 2024 you can clear Remove leading zeros and convert to number under File > Options > Data, and opening a CSV then keeps 00451 as text. In Power Query, set the column to Text inside the automatic Changed Type step, or delete that step, because a Text step added after it only gets 451. To restore codes already converted, use TEXT with as many zeros as the code length; this works only if every code has the same length.

Example
     A       B
1  Code    Restored
2    451   00451      B2: =TEXT(A2, "00000")
3     12   00012
4  10234   10234

C2: =LEN(B2)   -> 5   (B2 is now text)

11. Mobile numbers with the 91 prefix appear in scientific notation, such as 9.19877E+11, in a CRM export. What has happened, and how do you show them in full?

Nothing is lost yet. The General number format shows numbers of 12 or more digits in scientific notation, so 919876543210 is displayed that way while the full value is still stored. Click a cell and read the formula bar to confirm. Apply the number format 0 to show every digit, or better, keep phone numbers as Text, because nobody adds them up and text also keeps a leading + or 0. For a contact list sent to the call centre, export a column of text numbers, and spot-check a few against the CRM screen before sharing it.

12. How do you get the financial year label and the quarter, for an April to March year, from an invoice date?

Most Indian companies run their financial year from 1 April to 31 March, so January to March belong to the year that began the previous April. YEAR(date) minus 1 when the month is before April gives the starting year, because MONTH(A2)<4 returns TRUE, which counts as 1. Join it with the next year for a label such as FY 2026-27. For the quarter, shift the month with MOD so April becomes 0, divide by 3 and add 1: November 2026 is Q3 and February 2027 is Q4. Add these as helper columns once, so pivots and SUMIFS can use them.

Example
     A            B (FY start)   C             D
1  Invoice date
2  01-Apr-2026  2026           FY 2026-27    Q1
3  30-Sep-2026  2026                         Q2
4  18-Nov-2026  2026                         Q3
5  15-Feb-2027  2026           FY 2026-27    Q4

B2: =YEAR(A2)-(MONTH(A2)<4)
C2: ="FY "&B2&"-"&RIGHT(B2+1,2)
D2: ="Q"&INT(MOD(MONTH(A2)-4,12)/3)+1

13. Why should a daily report take its date from one report-date cell instead of using TODAY() in every formula?

TODAY() recalculates whenever the workbook does, including when it is opened, so yesterday's report shows different numbers when someone opens it tomorrow, and you cannot rerun a missed day. Put the report date in one input cell, usually the previous working day, and point every MTD, LMTD and ageing formula at it. Then Monday's report can cover Saturday, a backdated rerun takes one change, and the date in the title always matches the data. For a six-day week, =WORKDAY.INTL(TODAY(),-1,11,Holidays) gives the previous working day, so on Monday 23 November it returns Saturday 21 November; paste it as a value before you send.

14. What is the difference between an MIS report and a dashboard, and when does a manager need each?

A report is a detailed table built for checking and action: every branch, every SKU or every overdue invoice, often filtered by the person who works on it. A dashboard is one screen with the few numbers that show health at a glance, such as sales against target, collections, outstanding over 90 days and the trend, with colour to flag problems. A zonal head opening a laptop before a review call needs the dashboard; the branch accountant chasing payments needs the report. Most MIS work needs both, built from the same cleaned data so the numbers always match.

15. How would you design a daily input sheet that 30 branches fill, so the data comes back clean?

Design it as a table, not a form: one row per entry, one header row, a fixed column order and no merged cells or subtotals. Give each column a rule: a drop-down of branch codes from the master, dates limited to the current month, whole numbers of zero or more for quantities, and a fixed length for codes. Lock the headers and formula cells and protect the sheet so only the input area can change. Add a check column that shows OK or the problem. A filled sample row at the top shows the expected format faster than written instructions.

16. What can the macro recorder do for a daily report, and when do you switch on Use Relative References?

The recorder writes VBA for the steps you perform, such as deleting unwanted columns, applying number formats, setting column widths and adding a total row, so the next day one click repeats them. By default it records fixed cell addresses, so the macro always acts on the same cells. Switch on Use Relative References, on the Developer tab, when the steps should start from whichever cell is selected, such as formatting the block below the current heading. Save the file as a macro-enabled workbook (.xlsm), test it on a copy, and keep the raw export untouched.

17. When would you choose Google Sheets over Excel for MIS work, and what are its limits?

Choose Google Sheets when many people must enter or see data at the same time, such as 25 branch heads updating a daily collection tracker from their phones. Everyone works on one live file, version history records every change, and sharing can be limited by person. Its limits matter for heavier reports: Google's help page caps a spreadsheet at 20 million cells, large files with many formulas get slow, and there is no Power Query or Data Model. A common setup uses Sheets to collect inputs and Excel or a database for the monthly analysis.

18. Write a query for branch-wise sales and invoice count for October, and say why BETWEEN is risky on a datetime column.

Filter on a half-open range, from 1 October inclusive to 1 November exclusive, then group by branch. On the sample this gives Pune Rs 2,21,000 from two invoices, Surat Rs 1,50,000 and Nashik Rs 1,36,000. With BETWEEN '2026-10-01' AND '2026-10-31' on a DATETIME column, the end value means 00:00 on 31 October, so both bills raised later that day drop out: Nashik falls to Rs 82,000 and Surat disappears. Month-end billing is often heavy, so this hides real money. Check the result against the sales register in the ERP.

Example
SELECT branch, COUNT(*) AS invoices, SUM(amount) AS sales
FROM invoices
WHERE invoice_date >= '2026-10-01'
  AND invoice_date <  '2026-11-01'
GROUP BY branch
ORDER BY sales DESC;

19. What is a control total, and which checks would you run before sending any report?

A control total is a figure you take from the source, such as the row count and total value of the export, that your report must reproduce. If the ERP sales register for October shows 18,240 lines and Rs 3,46,85,200, the pivot's grand total must show the same before anything else is checked. Then confirm the date range, that no branch or category is unmapped, that key columns have no #N/A or blank values, and that each total is in a sensible range compared with last period. Record the results on a checks sheet so you can prove what you verified.

20. The daily sales report is due at 10 am, but the ERP export usually reaches you at 9:45. How do you deliver it on time and correctly?

Prepare everything that does not depend on today's data before the export arrives: the template, mappings, last period's figures and the email draft. Then the fifteen minutes go only to refreshing, checking control totals and reading the exceptions. If the export is late or the totals do not match, send a short note at 10 am saying when the report will come and why, instead of a rushed wrong one. Over time, ask whether the ERP report can be scheduled earlier or whether you can pull it yourself. Interviewers want to hear planning and honest communication, not heroics.

Ready to check yourself? Take the free MIS Executive mock test

MIS Executive interview questions: Medium questions (1-3 years)

20 questions

21. How do you document a recurring report so that a colleague can run it when you are on leave?

Write a one-page runbook for each report and keep it next to the file. It lists where each input comes from and how to pull it, with the ERP menu path, filters, date range and file name; the refresh order; the checks and their expected results; who receives the report and by when; and the known problems, such as a branch whose data always arrives late. Keep inputs and outputs in dated folders. Then ask a colleague to run it once from the note while you watch, and fix every step where they get stuck. A report only one person can run is a business risk.

22. Sales grew 12% this quarter, but the regional manager says the business is weak. Which KPIs would you put next to sales?

Sales alone can hide problems, so I would add collections and outstanding, days sales outstanding (DSO), the number of active billing outlets, and returns. Suppose outstanding is Rs 1.8 crore against Rs 4.5 crore of sales in the last 90 days: DSO is 1.8 divided by 4.5, times 90, which is 36 days. If it was 28 days a year ago, part of the growth was bought with credit. If active outlets fell from 1,200 to 1,050, growth came from fewer, bigger customers, which is riskier. Show each KPI against last year so the manager sees the pattern, not one number.

23. Targets are stored as one row per branch per month. How do you look up the target for a branch and month, and what is the trap with SUMIFS?

You need a lookup on two keys. In Microsoft 365 or Excel 2021, XLOOKUP can search for 1 in the product of two conditions, which equals 1 only where both branch and month match, and it returns No target when the pair is missing. SUMIFS on both columns works in any version, but it returns 0 for a missing pair, so Indore looks as if its target were zero and its achievement becomes #DIV/0! or a meaningless figure. SUMIFS also adds up duplicate rows without warning. Before relying on either, check that the target table has exactly one row per branch and month.

Example
     A       B      C          F       G      H
1  Branch  Month  Target     Branch  Month  Target
2  Pune    Oct    500000     Surat   Nov    320000
3  Pune    Nov    550000     Indore  Nov    No target
4  Surat   Oct    300000
5  Surat   Nov    320000

H2: =XLOOKUP(1, (A2:A5=F2)*(B2:B5=G2), C2:C5, "No target")
I2: =SUMIFS(C2:C5, A2:A5, F2, B2:B5, G2)     -> 320000
I3: =SUMIFS(C2:C5, A2:A5, F3, B2:B5, G3)     -> 0

24. How do you show this year against last year, with growth percentage, in a pivot table built from one data table?

Add a Year or financial-year column to the data, put Branch in Rows and the year in Columns, and add Sales to Values twice. Leave the first as a plain sum. For the second, open Value Field Settings, choose Show Values As, then % Difference From, with the year field as the base field and (previous) as the base item. The pivot now shows each branch's growth beside its sales, and the first year's growth column is blank because it has nothing to compare with. Hide that empty column and rename the field Growth %, so nobody reads it as a share of total.

25. Your monthly pivot must show months from April to March and zones in the company's order. How do you make that order survive a refresh?

By default a pivot sorts labels alphabetically, or month names from January to December, so January to March appear before April and zones come out A to Z. A custom list can set the order, but Microsoft notes that a custom list sort order is not kept when the pivot's data is refreshed. The safer way is a sort key in the data: month labels such as 01 Apr, 02 May up to 12 Mar from a financial-year month number, and zone labels such as 1 North and 2 West from the zone master. Those labels sort correctly by themselves after every refresh.

26. An incentive score weights sales 50%, collection 30% and new outlets 20%, caps each achievement at 120% and pays nothing below 80% of the sales target. How do you write it?

Cap each achievement with MIN before weighting, and wrap the whole score in an IF for the gate. In the sample sales is at 112%, collection at 95% and new outlets at 140%, which the cap cuts to 120%, so the score is 56 + 28.5 + 24 = 108.5%. Without the cap SUMPRODUCT gives 112.5%, and one easy KPI would inflate the payout. If sales were below 80%, the score would be 0 whatever the others show. Keep the cap, gate and weights in cells rather than inside the formula, so HR and sales can see and change the rules.

Example
     A            B       C            D              F1: Cap   G1: 120%
1  KPI          Sales   Collection   New outlets
2  Achievement  112%    95%          140%
3  Weight       50%     30%          20%

B5: =IF(B2<0.8, 0, MIN(B2,$G$1)*B3 + MIN(C2,$G$1)*C3 + MIN(D2,$G$1)*D3)   -> 108.5%
B6: =SUMPRODUCT(B2:D2, B3:D3)                                            -> 112.5% (no cap)

27. How do you total November sales for several branches at once with SUMIFS?

SUMIFS joins its conditions with AND, so asking for branch Pune and branch Nashik in one call finds nothing. Give the branch criterion an array of values instead: SUMIFS then returns one total per branch, and SUM around it adds them, here Rs 4,20,000 plus Rs 1,80,000, or Rs 6,00,000. With an array constant like this it also works in older versions. If the branch names sit in a range of cells, use SUMPRODUCT instead of SUM in Excel 2019 or older. A chain of SUMIFS joined with plus signs gives the same answer but breaks easily when someone adds a branch.

Example
     A       B      C
1  Branch  Month  Sales
2  Pune    Nov    420000
3  Nashik  Nov    180000
4  Surat   Nov    260000
5  Pune    Oct    390000
6  Nashik  Oct    150000

E1: =SUM(SUMIFS(C2:C6, A2:A6, {"Pune","Nashik"}, B2:B6, "Nov"))   -> 600000

28. An ERP export shows negative amounts as 1,250.00- with the minus sign at the end, and SUM returns 0. How do you convert them?

The values are text, so SUM ignores them. The Text Import Wizard has an Advanced option for numbers that end with a minus sign, but in Microsoft 365 it is a legacy wizard you first switch on under File > Options > Data, Show legacy data import wizards, From Text (Legacy). For a sheet that is already open, a formula checks the last character, drops the minus and the commas, converts with VALUE and flips the sign. Here the three entries total 2,075.50 once converted, against 0 before. Always compare the converted total with the total line printed in the ERP report.

Example
     A            B
1  ERP amount   Converted
2  1,250.00-    -1250
3  3,400.50      3400.5
4  75.00-       -75
5  =SUM(A2:A4) -> 0     =SUM(B2:B4) -> 2075.5

B2: =IF(RIGHT(A2)="-", -VALUE(SUBSTITUTE(LEFT(A2,LEN(A2)-1),",","")),
        VALUE(SUBSTITUTE(A2,",","")))

29. Sixteen-digit loan account numbers from the CRM end in 0 after you open the file. Why, and how do you import them safely?

Excel keeps numbers to 15 digits of precision, so when a 16-digit ID is read as a number its last digit becomes 0, and saving makes the loss permanent. Two accounts can then look identical, and lookups match the wrong customer. In Excel for Microsoft 365 and Excel 2024, clearing Keep the first 15 digits of long numbers under File > Options > Data stores such numbers as text when you open a CSV. That setting does not affect Power Query, so there set the ID column to Text in the automatic Changed Type step, which guesses types from the first 200 rows. Keep IDs as text everywhere.

30. The CRM gives timestamps such as 18-Nov-2026 18:45:10, and your weekly report runs Monday to Sunday. How do you get the date and the week start?

A real timestamp is a date serial number plus a fraction for the time, so INT drops the time and leaves the date. This matters because a SUMIFS with "<="&report date otherwise misses every entry made after midnight on the report date. For a Monday start, WEEKDAY with return type 3 gives 0 for Monday up to 6 for Sunday, so subtracting it from the date gives that week's Monday. In the sample both Wednesday 18 November and Sunday 22 November fall in the week of 16 November. If timestamps arrive as text in an unusual format, convert them in Power Query with the right locale first.

Example
     A                      B (date)      C (week start)
1  CRM timestamp
2  18-Nov-2026 18:45:10    18-Nov-2026   16-Nov-2026
3  22-Nov-2026 09:05:00    22-Nov-2026   16-Nov-2026

B2: =INT(A2)
C2: =INT(A2)-WEEKDAY(A2,3)      (WEEKDAY(A2,3) -> 2, Wednesday)
F2: =ISOWEEKNUM(A2)             -> 47

31. How do you show achievement against target for 30 branches on one chart so the problem branches stand out?

Use a horizontal bar chart of achievement percentage sorted from lowest to highest, because 30 branch names fit on the vertical axis and bar lengths are easy to compare, unlike pie slices or 30 pairs of columns. Add a line at 100% as the target mark, and colour the bars below, say, 90% differently by splitting the data into two series with formulas. Show the actual and target amounts in labels or a small table beside it, because a small branch at 70% may matter less than a large one at 92%. Avoid 3-D effects and keep one message per chart.

32. In a daily input sheet, how do you allow only dates in the current report month without blocking late entries on the 1st, and which error alert style do you choose?

Drive the rule from the report-date cell, not from TODAY(). Name that cell ReportDate on a settings sheet and set Data Validation to Date, between =EOMONTH(ReportDate,-1)+1 and =ReportDate. On 1 December the report date is still 30 November, so a branch can enter its late November figures, while a December date or a typo such as 2025 is refused. A TODAY()-based window would already have moved to December and blocked those entries. When you roll the report date forward, the window moves with it. Choose the Stop alert, because Warning and Information still let the user keep a wrong date.

Example
     A           B
1  ReportDate  30-Nov-2026          (named cell on the Settings sheet)
2  From        =EOMONTH(B1,-1)+1    -> 01-Nov-2026
3  To          =B1                  -> 30-Nov-2026

Rule: Allow Date, between =EOMONTH(ReportDate,-1)+1 and =ReportDate
Entry 30-Nov-2026 -> allowed; 01-Dec-2026 and 30-Nov-2025 -> refused

33. Your ERP gives a report-style export: the branch name appears only on the first row of each block, with subtotal rows in between. How do you turn it into a clean table with Power Query?

Load it into Power Query, remove the title rows at the top and promote the real header row. Then select the branch column and use Fill > Down, which copies each branch name into the rows below until the next name appears. Fill Down only fills null values, so if the gaps arrive as empty text, use Replace Values to turn them into null first. Next, filter out the subtotal and grand total rows, for example rows where the invoice number is blank, and set the data types. The result is one row per invoice for pivots and lookups, refreshed with one click next month.

34. Your Power Query refresh fails with an error saying the column Branch Name was not found. What happened, and how do you make the query sturdier?

The source changed: the ERP export now calls the column Branch, or someone edited the template. Power Query steps refer to columns by name, and the automatic Changed Type step lists every column it saw, so one renamed header stops the whole refresh. Open the query, click through the applied steps to find the first one with an error, and fix that reference or rename the column back near the start. To make it sturdier, delete the automatic Changed Type step, select and rename only the columns you need, set types once after that, and agree a fixed export layout with the system owner.

35. You recorded a macro to format the daily report, but it misses rows or formats empty ones when the row count changes. Why, and how do you fix it?

The recorder writes the exact range you touched, such as A1:H250, so tomorrow's 312 rows are only partly formatted and a shorter file gets formatting on empty rows. Edit the VBA so the range is found when the macro runs: convert the data into an Excel Table and refer to the table, use CurrentRegion from the header cell, or find the last used row with End(xlUp) on a key column. Also remove the recorded Select and Activate lines, which slow the macro and break when another sheet is active. Test it on a short and a long file before relying on it.

36. Branch heads each fill their own Google Sheet. How do you pull them into one summary sheet, and what goes wrong?

IMPORTRANGE brings a range from another spreadsheet using its URL and a range text such as Daily!A1:F200, and QUERY on top of it can filter and total the rows, so one summary file can show every branch. The first time, someone must click Allow access, and that access lasts until the person who granted it is removed from the source. Updates are not instant: Google's help page says chained imports add delay, open files check for updates every hour, and each request is capped at 10 MB. If a branch renames its tab, the import breaks, so lock the template.

37. How do you get MTD and LMTD sales by branch in one SQL query?

Read both periods in one pass and split them with conditional aggregation: SUM over a CASE that keeps the amount only when the date falls in the period, else 0. With a report date of 18 November, MTD is 1-18 November and LMTD is 1-18 October; bill_date is a DATE column, so BETWEEN is safe here. On the sample Pune has Rs 2,23,000 against Rs 2,15,000, Surat Rs 1,13,000 against Rs 60,000, and Indore Rs 0 against Rs 38,000. Indore appears only because the WHERE clause covers both months; filtering on this month alone would hide the branch that stopped billing.

Example
SELECT branch,
  SUM(CASE WHEN bill_date BETWEEN '2026-11-01' AND '2026-11-18'
           THEN amount ELSE 0 END) AS mtd,
  SUM(CASE WHEN bill_date BETWEEN '2026-10-01' AND '2026-10-18'
           THEN amount ELSE 0 END) AS lmtd
FROM sales
WHERE bill_date >= '2026-10-01'
GROUP BY branch
ORDER BY branch;

38. Write a query to find the distributors who billed in October but have raised no invoice at all in November.

Count invoices, not net amounts. Group both months' documents by distributor, total October's invoice value and count November's invoices with a CASE on the document type, then keep the groups with October above zero and no November invoice. On the sample D203 (Rs 40,000 in October) and D202 (Rs 30,000) are listed. A test on net November sales goes wrong both ways: D203's November credit note of Rs 5,000 makes its net non-zero, so it is missed, while D205, which billed Rs 8,000 and had it credited back, nets to zero and is wrongly listed. Label the result November so far.

Example
SELECT distributor,
  SUM(CASE WHEN doc_type = 'INV' AND bill_date <  '2026-11-01'
           THEN amount ELSE 0 END) AS oct_billed,
  SUM(CASE WHEN doc_type = 'INV' AND bill_date >= '2026-11-01'
           THEN 1 ELSE 0 END) AS nov_invoices
FROM bills
WHERE bill_date >= '2026-10-01' AND bill_date < '2026-12-01'
GROUP BY distributor
HAVING oct_billed > 0 AND nov_invoices = 0
ORDER BY oct_billed DESC;

39. How do you reconcile CRM orders with ERP invoices to find orders not invoiced and invoices with no order?

Match both ways on a common key, here the sales order number that each ERP invoice carries. From the CRM side, COUNTIF tells you whether each order appears in the ERP list, and SUMIFS gives the value difference when it does. From the ERP side, a second COUNTIF finds invoices with no CRM order. In the sample SO-502 is not invoiced, SO-503 was billed Rs 1,500 less than booked, and SO-509 was invoiced without any CRM order. Report the three buckets with counts and values, then send each exception list to the person who can fix it, not the whole sheet.

Example
     A        B        C              E        F         G
1  CRM      Order    Diff / status  ERP ref  Invoice   Status
2  SO-501    84000   0              SO-501    84000    Matched
3  SO-502    56000   Not invoiced   SO-503   118500    Matched
4  SO-503   120000   -1500          SO-504    30000    Matched
5  SO-504    30000   0              SO-509    45000    No CRM order

C2: =IF(COUNTIF($E$2:$E$5,A2)=0, "Not invoiced",
        SUMIFS($F$2:$F$5,$E$2:$E$5,A2)-B2)
G2: =IF(COUNTIF($A$2:$A$5,E2)=0, "No CRM order", "Matched")   (filled down to G5)

40. Your totals match the source, yet the report can still be wrong. Which checks against earlier periods catch what a total check misses?

A total can match while numbers sit in the wrong rows, so compare each line with its own history. Flag any branch or product that moves more than an agreed band, say 30% against last week or the same days last month; any line that was active and is now zero; any code that has never appeared before; and any share of total that jumps. Then open two or three flagged rows in the source to confirm. A branch that suddenly shows zero, for example, may simply have been mapped to a new code. A variance column with conditional formatting runs these checks in seconds.

Ready to check yourself? Take the free MIS Executive mock test

MIS Executive interview questions: Hard questions (experienced)

20 questions

41. You join a company where 40 reports go out every week and nobody is sure who reads them. How would you rationalise them?

Start with an inventory: for each report, who asked for it, who receives it, what decision it supports, its inputs and the hours it takes. Then ask the recipients what they actually use, and check file activity where reports sit on OneDrive or SharePoint. Often several reports are views of the same data, so merge them into one report with filters or one dashboard, retire the rest after a notice period, and keep a register of what exists. Show your manager the hours saved and the lower error risk, and agree every change before you stop sending anything.

42. HR reports monthly attrition as 2.5% and the business head says 2.45%, from the same data. How is that possible, and how do you settle it?

They used different denominators. With 480 employees at the start of the month, 500 at the end and 12 leavers, 12 divided by the opening 480 is 2.5%, while 12 divided by the average headcount of 490 is 2.45%. Neither is wrong; the definition was never fixed. Settle it with a KPI definition sheet that states the formula, which exits count (voluntary only or all, and whether trainees and contract staff are included), the source system and the cut-off date, and get HR and the business head to sign it. After that, every report uses the one definition.

43. Sales grew 12.2% over last year, but the CFO is not happy. How would you split the growth into price, volume and mix?

Split the change into three parts that add up exactly. Price is each product's price change times this year's units: Rs -5,500, because the price cut on A outweighed the rise on B. Volume is the change in total units valued at last year's average price: Rs +2,56,667. Mix is the shift between products at last year's prices: Rs -1,16,667, because cheaper product A grew while costlier product B shrank. Together they make the Rs 1,34,500 growth. So all the growth came from volume, while price and mix worked against it, which also hurts margin if product A earns less per unit. Agree the method with finance first, because other splits exist.

Example
     A        B         C         D         E
1  Product  LY units  LY price  TY units  TY price
2  A        1000       500      1400       480
3  B         500      1200       450      1250

H1 LY sales: =SUMPRODUCT(B2:B3,C2:C3)                            -> 1100000
H2 TY sales: =SUMPRODUCT(D2:D3,E2:E3)                            -> 1234500
H3 Price:    =SUMPRODUCT(E2:E3-C2:C3,D2:D3)                      -> -5500
H4 Volume:   =(SUM(D2:D3)-SUM(B2:B3))*H1/SUM(B2:B3)              -> 256667
H5 Mix:      =SUMPRODUCT(D2:D3-SUM(D2:D3)*B2:B3/SUM(B2:B3),C2:C3) -> -116667

44. A distributor moved from the Pune territory to Nashik on 1 October. How do you make lookups use the territory valid on each invoice date, not today's mapping?

Keep the mapping with a valid-from date instead of overwriting it, so the master holds both rows for D101. For each invoice, MAXIFS finds the latest valid-from date on or before the invoice date for that code, and a lookup on code plus that date returns the territory. September's invoice stays with Pune and November's goes to Nashik, so history does not move when the master changes. A code with no valid row returns Unmapped and goes on the exception list. MAXIFS needs Excel 2019 or later and XLOOKUP 2021 or later; in SQL the same rule is a join on code with the invoice date between valid-from and valid-to.

Example
     A      B          C            D (key)
1  Code   Territory  Valid from
2  D101   Pune       01-Apr-2026  D2: =A2&"|"&C2
3  D101   Nashik     01-Oct-2026
4  D102   Surat      01-Apr-2026

F2: D101   G2: 15-Sep-2026
H2: =MAXIFS($C$2:$C$4, $A$2:$A$4, F2, $C$2:$C$4, "<="&G2)
I2: =XLOOKUP(F2&"|"&H2, $D$2:$D$4, $B$2:$B$4, "Unmapped")   -> Pune
F3: D101   G3: 05-Nov-2026                                   -> Nashik

45. The ERP records sales in cases, the distributor system in pieces and a few SKUs in kg. How do you build one volume report that management can trust?

Never add raw quantities across systems. Build a unit conversion master by SKU and unit that gives the factor to one standard reporting unit, such as cases, agreed with supply chain. Convert every row through a lookup on SKU plus unit, and send any pair without a factor to the exception list instead of letting it count as 1. In the sample 240 pieces of a 24-piece soap become 10 cases and 36 kg of detergent 3 cases, so the mapped volume is 28 cases, not 341 mixed units. The 50 kg of tea is left out of that total and sits on the exception line until a factor is added. Date the factors, because pack sizes change.

Example
     A        B      C     D (per case)  E (cases)      G             H
1  SKU      Unit   Qty                                  Key           Per case
2  SOAP100  CASE    15    1             15             SOAP100|CASE   1
3  SOAP100  PCS    240   24             10             SOAP100|PCS   24
4  DET1KG   KG      36   12              3             DET1KG|KG     12
5  TEA250   KG      50   No factor      Check

D2: =XLOOKUP(A2&"|"&B2, $G$2:$G$4, $H$2:$H$4, "No factor")
E2: =IF(ISNUMBER(D2), C2/D2, "Check")
E6: =SUM(E2:E5)  -> 28        E7: =COUNTIF(E2:E5, "Check")  -> 1

46. Your daily report compares MTD with the same number of working days last month, excluding Sundays and holidays. How do you find the comparison date?

Count this month's working days up to the report date with NETWORKDAYS.INTL, using weekend code 11 for Sunday only and the company holiday list. On 18 November 2026, with holidays on 9 and 10 November in the sample list, that gives 13 days. WORKDAY.INTL then starts from 30 September and moves forward 13 working days, skipping Sundays and the 2 October holiday, to land on 16 October. A plain 1-18 October LMTD would hold 14 working days against this month's 13, so this month would look worse by about a day's sales. Sum LMTD up to 16 October instead.

Example
     A                       B              D: Holidays
1  Report date             18-Nov-2026    02-Oct-2026
2  MTD working days        13             09-Nov-2026
3  Same point last month   16-Oct-2026    10-Nov-2026

B2: =NETWORKDAYS.INTL(EOMONTH(B1,-1)+1, B1, 11, D1:D3)
B3: =WORKDAY.INTL(EOMONTH(B1,-2), B2, 11, D1:D3)
Plain 1-18 Oct: =NETWORKDAYS.INTL(EOMONTH(B1,-2)+1, EDATE(B1,-1), 11, D1:D3)  -> 14

47. Managers have stopped reading your 12-page monthly MIS. How would you use exception reporting to fix it?

Put the exceptions first and the detail behind them. Agree thresholds with the managers, such as branches below 85% of target, customers more than 90 days overdue, SKUs holding over 60 days of stock, or any KPI that moved more than 20% from last month. The first page lists only the items that crossed a threshold, each with an owner and one line of reason, and the full tables move to an appendix or a filterable sheet. Each month, check which flags were acted on and adjust the thresholds. A short report that people act on beats a complete one they skip.

48. When would you move an Excel MIS dashboard to Power BI, and what would you check before doing it?

Move when Excel is straining: more data than a sheet handles comfortably, many people needing the same view with different access, refreshes done by hand every day, or managers asking to drill down on their phones. Before moving, check licences and who pays for them, whether each data source can refresh automatically, perhaps through a gateway for systems on company servers, and whether row-level access is needed. Rebuild the logic, not the layout: agree KPI definitions, model the data cleanly, and reconcile the first months against the Excel version before retiring it. If only one person reads it once a month, Excel may still be the better tool.

49. New SKUs and branch codes keep appearing in sales data before anyone adds them to the master. How do you control master data?

Treat it as a process problem, not a formula problem. Name an owner for each master, such as sales admin for distributors and the product team for SKUs, and set up a simple request form with mandatory fields and a fixed code format. Run a daily unmapped-codes check: every code in the transactions that is missing from the master goes to its owner with the value involved, and the report shows that value on its own line instead of hiding it. Keep a dated change log, so a re-mapping does not silently rewrite last quarter. Track unmapped value monthly as a data quality measure.

50. How do you make a Power Query report that colleagues can refresh for another month, or from their own folder, without editing the query?

Move the values that change out of the steps and into parameters. In the Power Query editor, Manage Parameters lets you create a text parameter for the folder path and a date parameter for the report month, and you use them in the Source step and the date filter. A common variation reads both values from named cells on a Settings sheet, so users change a cell, not the query. For shared files, the SharePoint folder connector uses the site address, which is the same for everyone, unlike a local OneDrive path. Test by changing the month and refreshing on a colleague's laptop.

51. A query that combines 24 monthly files takes six minutes to refresh. How do you make it faster?

Cut the work as early as possible. Remove unneeded columns and filter rows right after the source step, so every later step handles less data. Avoid sorting and row-by-row custom columns in the middle, and set helper and staging queries to connection only, so they are not written to sheets. Closed months never change, so combine the older files once into a single history file and append only the current months to it. Load a large result to the Data Model instead of a sheet. Time the refresh after each change, so you know which step actually helped instead of guessing.

52. For a daily report, when would you use VBA, Power Query or Office Scripts, and when would you not automate at all?

Use Power Query for getting and cleaning data, because its steps are visible and refresh safely. Use VBA in desktop Excel for actions Power Query cannot do, such as splitting a report into 30 branch files and emailing them. Office Scripts suit files kept in OneDrive or SharePoint: Microsoft supports them in Excel on the web, Windows and Mac with a business or education Microsoft 365 licence, and Power Automate can run them on a schedule. Do not automate a report whose logic changes every month or that runs twice a year; document it instead. Every automation needs an owner and a fallback.

53. Your macro-enabled report, received as an email attachment, now opens with a Security Risk banner saying macros are blocked. What happened, and what is the safe fix?

Office on Windows blocks VBA macros by default in files from the internet, and Windows marks email attachments and downloads with the Mark of the Web. Microsoft rolled this default out from 2022. The safe fixes: stop emailing macro files and keep the tool in a controlled shared location; for one file you trust, tick Unblock in its Properties; or ask IT for a Trusted Location or macros signed by a trusted publisher. Do not ask users to enable all macros. Better still, run the macro centrally and send everyone the output as a plain .xlsx file.

54. Your team's sales tracker in Google Sheets has 40 tabs and takes a minute to load. What would you change?

First find the load. Usual causes are chains of IMPORTRANGE, volatile functions such as NOW and TODAY, ARRAYFORMULA or QUERY over whole columns, and conditional formatting across thousands of rows. Then restructure: keep raw entries in one data tab, archive closed months to a separate file, and build each summary once instead of copying formulas into every branch tab. Replace whole-column ranges such as A:A with bounded ones, and pull each source through IMPORTRANGE once into a staging tab that the other tabs read. If the data keeps growing, move storage to a database or BigQuery and keep Sheets for entry and viewing.

55. Write a query that ages each branch's outstanding invoices into 0-30, 31-60, 61-90 and 90+ day buckets as on a report date, even when you run it days later.

An as-on ageing must show what was outstanding on the report date, whenever you run it. So take only invoices dated on or before 18 November, and subtract only receipts dated on or before that day; a payment received on the 19th must not shrink the 18th's ageing. The CTE works out each invoice's balance that way, assuming receipts are allocated to invoices, and CASE then buckets it by age. On the sample Pune's part-paid invoice shows its Rs 40,000 balance in 31-60, the invoice paid on 19 November still counts in 61-90, and the 19 November invoice is left out. Agree with finance whether to age from invoice or due date.

Example
WITH bal AS (
  SELECT i.branch, DATEDIFF('2026-11-18', i.invoice_date) AS age,
         i.amount - COALESCE(SUM(r.amount), 0) AS balance
  FROM invoices i
  LEFT JOIN receipts r ON r.invoice_no = i.invoice_no AND r.receipt_date <= '2026-11-18'
  WHERE i.invoice_date <= '2026-11-18'
  GROUP BY i.invoice_no, i.branch, i.invoice_date, i.amount)
SELECT branch,
  SUM(CASE WHEN age <= 30 THEN balance ELSE 0 END) AS d0_30,
  SUM(CASE WHEN age BETWEEN 31 AND 60 THEN balance ELSE 0 END) AS d31_60,
  SUM(CASE WHEN age BETWEEN 61 AND 90 THEN balance ELSE 0 END) AS d61_90,
  SUM(CASE WHEN age > 90 THEN balance ELSE 0 END) AS d90_plus
FROM bal WHERE balance > 0
GROUP BY branch ORDER BY branch;

56. Every branch must upload a daily report. Write a query that lists which branch missed which date over a date range.

You cannot find missing rows by looking only at the rows you have, so first build the full grid of expected rows. A recursive CTE generates each date in the range, a cross join with the branch master gives every branch-date pair, and a LEFT JOIN to the uploads keeps the pairs with no match. In the sample Indore missed 16 and 18 November, and Surat missed 17 November. Run it every morning before consolidating, so you chase missing data before the report goes out, not after a manager spots the gap. Exclude closed branches and holidays through the master and calendar.

Example
WITH RECURSIVE days AS (
  SELECT DATE('2026-11-16') AS d
  UNION ALL
  SELECT d + INTERVAL 1 DAY FROM days WHERE d < '2026-11-18'
)
SELECT b.branch, days.d AS missing_date
FROM days
CROSS JOIN branches b
LEFT JOIN uploads u ON u.branch = b.branch AND u.report_date = days.d
WHERE u.branch IS NULL
ORDER BY b.branch, days.d;

57. You find a mistake in a report that went to senior management yesterday. What do you do?

Tell my manager at once, with the facts: what is wrong, which numbers and decisions it affects, and when the correction will be ready. Then send a short correction to the same recipients with the corrected figures, one line on what changed and why, and no blame. For example, if a duplicated branch mapping counted Rs 18 lakh of Pune sales twice, say exactly that and show the new totals. Afterwards, find the root cause, add a check that would have caught it, such as a control total or an unmapped-code test, and mention the new check in the next report. Hiding it is the real mistake.

58. How would you build checks into a monthly MIS with 40 numbers, so it can be trusted without rechecking every figure by hand?

Build a checks sheet that tests the report automatically and shows one status. It compares report totals with source control totals and with the finance ledger for the month, confirms row counts, cross-foots each table so row totals and column totals agree, shows zero unmapped codes and zero error values, and flags any line outside its usual variance band. Each check returns OK or the difference, and one cell at the top shows Ready only when every check passes. You then spend time only on failures. Share a visible tie-out to finance with readers too, because it builds trust.

59. Sales wants monthly figures by order booking date and finance by invoice date, and the numbers differ. How do you handle it?

Both are valid views, so do not pick a winner on my own. Define each measure clearly, booked sales from the CRM by order date and billed sales from the ERP by invoice date, and agree with both heads which one drives targets and incentives. Then show the bridge every month: billed sales equals booked sales, minus this month's orders not yet invoiced or cancelled, plus invoices raised this month against earlier orders. When the bridge closes to the rupee, the argument stops. Record the agreed definitions in the KPI sheet, and label every report with the basis it uses.

60. You lead three MIS executives, and the month-end reports are always two days late. How would you fix it?

Map month-end as a timeline: every report, its inputs, who provides them and when they really arrive. The delay usually sits in a few inputs, such as provisions from finance or a branch that sends data on day three, so agree delivery dates with those owners and escalate misses. Move work before the close, such as mappings, templates and last month's comparatives, and refresh with Power Query instead of rebuilding. Spread reports so no single person is a bottleneck, cross-train for leave, and publish a close calendar. Track the delivery day every month so the team and management can see the improvement.

Practice questions for November 2026

New every month

3 questions from the MIS Executive mock test, the way they appear in it. A new set comes on the 1st of every month. Pick your answer, then open it.

  1. FresherDynamic Arrays

    G2 holds this formula in Excel for Microsoft 365. Which names spill into G2 downwards?

       A      B
    1  Exec   Branch
    2  Ravi   Pune
    3  Asha   Nagpur
    4  Ravi   Pune
    5  Meena  Pune
    6  Asha   Nagpur
    7  Imran  Nashik
    
    G2: =SORT(UNIQUE(A2:A7))
    • Asha, Imran, Meena, Ravi
    • Ravi, Asha, Ravi, Meena, Asha, Imran
    • Ravi, Asha, Meena, Imran
    • Asha, Asha, Imran, Meena, Ravi, Ravi
    Show the answer

    Answer: Asha, Imran, Meena, Ravi. UNIQUE keeps one copy of each name in the order found, Ravi, Asha, Meena, Imran, and SORT then orders them A to Z. Without SORT the list stays in the order of first appearance, and without UNIQUE the repeats remain.

  2. Intermediate (1-5 years)Macros and VBA

    A macro-enabled MIS file emailed from outside the company opens with the message: Microsoft has blocked macros from running because the source of this file is untrusted. What is a safe fix, if the file is genuinely trusted?

    • Turn on Enable VBA macros for every file in the Trust Center, then open the file again
    • Save it, and in the file's Properties select Unblock, or keep it in a Trusted Location
    • Copy the macro into the file's comments
    • Change the file extension from .xlsm to .xlsx
    Show the answer

    Answer: Save it, and in the file's Properties select Unblock, or keep it in a Trusted Location. Microsoft 365 blocks macros in files marked as coming from the internet. Unblocking that one file, or using a trusted location, allows its macros. Enabling all macros for every file removes the protection, and .xlsx deletes the macros.

  3. Experienced (5+ years)KPIs and Business Metrics

    Last year's Q2 profit was -Rs 5 lakh and this year's is +Rs 3 lakh. How should the MIS show the YoY growth %?

    • +60%
    • -160%, as the profit has fallen against last year's base
    • +160%, using the absolute value of last year's profit as the base
    • As n.m. (not meaningful), stating the change of +Rs 8 lakh instead
    Show the answer

    Answer: As n.m. (not meaningful), stating the change of +Rs 8 lakh instead. Growth % divides by the base, and a negative base flips the sign: (3 - (-5)) / -5 = -160%, which looks like a fall. Using ABS gives +160%, which is not standard either. Most MIS reports show n.m. and the absolute change.

Take the full MIS Executive mock test

Ready to apply?

Browse the open jobs on CoreHRx. Create a free profile once and apply with it.