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.
Questions you may be asked
What does an MIS executive do, and which reports would you expect to own in a sales or operations team?
How is a daily MIS report different from a weekly and a monthly one, in content and in who reads it?
What do MTD, LMTD, YTD and LYTD mean in a sales MIS, and how do you calculate growth from them?
How do you calculate target achievement and growth percentages without #DIV/0! errors when a target or last year's figure is zero?