18. Interview Questions Asked in MNC Interviews
18.1 How to Answer in Interviews
Use a clear structure. For "Tell me about a time…" and project questions, use the STAR method:
| Step | What to say | Blinkit example (fictional project) |
|---|---|---|
| Situation | The business context in one or two lines | "Six city managers sent daily order files in different formats, and the monthly report took two days to prepare." |
| Task | Your responsibility | "I had to build one clean monthly Excel report with KPIs by city." |
| Action | What you did, with the key technical choices | "I built a Power Query that cleaned and appended the files, used XLOOKUP to add store and category details, created pivots with slicers and a one-page dashboard, and a macro to export it to PDF." |
| Result | The outcome, honestly stated | "The report now refreshes in a few minutes, and the city totals reconcile with the source files." |
Explaining your Excel project (the 60-second version). Cover, in order: the business problem → the data (sources, approximate rows, only if you know them) → the cleaning steps and the problems you found → the formulas and Tables → the pivots and dashboard → any automation (Power Query, macro) → how you verified the numbers → the impact. Then stop and let the interviewer choose what to go deeper into.
Other habits that help:
- Think aloud in scenario and live-test questions. Interviewers check your approach, not only the final number.
- Define, then give an example. "An absolute reference stays fixed when copied – for example
$F$1holding the GST rate." - Say when you would use each option in comparison questions (VLOOKUP vs INDEX-MATCH vs XLOOKUP).
- Be honest about gaps. "I haven't used Solver in production, but I know it needs an objective cell, variable cells and constraints" is far better than bluffing.
- Verify in live tests. After a formula, check two rows manually and say so.
Ravindra Bagale's Tip
Friends, many students memorise definitions and then get stuck on the next question, "Where did you use it?" For every topic in this module, keep one genuine example ready from your own project or from the Module 15 Blinkit project. Say only what you have actually done – exaggeration gets caught within two follow-up questions.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students definitions पाठ करतात आणि मग "Where did you use it?" या पुढच्या प्रश्नाला अडकतात. या module मधल्या प्रत्येक topic साठी तुमच्या project मधून किंवा Module 15 च्या Blinkit project मधून एक खरंखुरं उदाहरण तयार ठेवा. फक्त जे केलं आहे तेच सांगा – अतिशयोक्ती (exaggeration) दोन follow-up प्रश्नांत पकडली जाते.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students definitions रट लेते हैं और फिर अगले सवाल "Where did you use it?" पर अटक जाते हैं. इस module के हर topic के लिए अपने project से या Module 15 के Blinkit project से एक असली उदाहरण तैयार रखो. सिर्फ़ वही बताओ जो सच में किया है – बढ़ा-चढ़ाकर कही बात (exaggeration) दो follow-up सवालों में पकड़ी जाती है.