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 | FreshGo 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." |
About this data: Teaching sample for a fictional shop “Pearl Textiles”. Figures and names (e.g. Priya Deshmukh) are made up for this lesson on how to answer in interviews.
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 FreshGo 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 च्या FreshGo project मधून एक खरंखुरं उदाहरण तयार ठेवा. फक्त जे केलं आहे तेच सांगा – अतिशयोक्ती (exaggeration) दोन follow-up प्रश्नांत पकडली जाते.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students definitions रट लेते हैं और फिर अगले सवाल "Where did you use it?" पर अटक जाते हैं. इस module के हर topic के लिए अपने project से या Module 15 के FreshGo project से एक असली उदाहरण तैयार रखो. सिर्फ़ वही बताओ जो सच में किया है – बढ़ा-चढ़ाकर कही बात (exaggeration) दो follow-up सवालों में पकड़ी जाती है.
Worked example — how to answer in interviews
Why
Neha Shah in Pune and Yuki Tanaka abroad both need a clear, repeatable way to use how to answer in interviews on a GreenField Dairy sheet without breaking totals.
What
How To Answer In Interviews is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for how to answer in interviews.
- Enter a small made-up value for Neha Shah using $ where money appears.
- Add a second value for Yuki Tanaka using $ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once how to answer in interviews is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of how to answer in interviews on a blank sheet for Skyline Clinics.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Priya Deshmukh and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Oliver Bennett.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply how to answer in interviews to a 5-row made-up Skyline Clinics table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with how to answer in interviews.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as SkylineClin_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
