18. Interview Questions Asked in MNC Interviews
18.9 Capgemini, Infosys, Cognizant and Wipro
M61. In an online test you are asked to filter data, build a pivot and apply VLOOKUP. How do you approach it?
Reported for: Capgemini [S11]
Convert the data to a Table first, read the task carefully, apply filters with exact criteria, build the pivot from the Table on a new sheet, and write VLOOKUP with FALSE for exact match and absolute references. Check a couple of results manually and watch for #N/A caused by spaces or text numbers.
M62. You are given a raw dataset: clean it and build charts.
Reported for: Capgemini [S11]
Keep a raw copy; remove duplicates, trim and standardise text, fix number and date types, handle blanks; convert to a Table; summarise with a pivot; build a suitable chart (line for trend, bar for comparison) with a clear title and labels; state one insight in words.
M63. How would you use PivotTables and conditional formatting on sales data?
Reported for: Infosys [S12]
Pivot sales by city and month, then apply conditional formatting to the pivot values (Color Scale or Icon Sets; choose "All cells showing Sum of Amount values" so the rule survives refresh). This instantly shows which city-month cells are weak or strong.
M64. Create visual summaries using PivotTables and charts.
Reported for: Cognizant [S13]
Build one pivot per question (sales by city, trend by date, share by platform), insert PivotCharts, hide field buttons, add a slicer connected to all pivots and arrange them on one sheet – a mini dashboard (Module 13).
M65. What is data cleansing?
Reported for: Wipro [S14]
The process of detecting and correcting errors and inconsistencies – duplicates, missing values, wrong types, inconsistent spellings, extra spaces, invalid entries and outliers – so the analysis is accurate and trustworthy. It includes documenting the steps and reconciling counts and totals before and after.
M66. Can VLOOKUP or HLOOKUP be used for data cleansing?
Reported for: Wipro [S14]
They are lookup functions, not cleaning functions, but they support cleansing: a lookup against a mapping table standardises values ("Aurangabad" → "Sambhaji Nagar"), and a lookup against a master list exposes invalid or missing codes through #N/A. Actual text cleaning is done with TRIM, CLEAN, PROPER, SUBSTITUTE or Power Query.
Ravindra Bagale's Tip
In online tests, many students write formulas in a hurry and never check them even once. After every answer, check 2 rows manually; if you see #N/A, first look for spaces and text-vs-number differences. Even when time is short, these 30 seconds save you.
Ravindra Bagale's Tip – मराठी
Online test मध्ये बरेच students घाई-घाईत formula लिहितात आणि एकदाही check करत नाहीत. प्रत्येक उत्तरानंतर 2 rows हाताने चेक करा, #N/A दिसला तर आधी spaces आणि text-number फरक बघा. वेळ कमी असला तरी हे 30 सेकंद वाचवतात.
Ravindra Bagale's Tip – हिंदी
Online test में बहुत से students जल्दबाज़ी में formula लिखते हैं और एक बार भी check नहीं करते. हर जवाब के बाद 2 rows हाथ से check करो, #N/A दिखे तो पहले spaces और text-number का फ़र्क देखो. समय कम हो तब भी ये 30 सेकंड बचा लेते हैं.
Loading practice tasks...
- Total openings (Easy): Add up Openings in C2:C11. (sheet "Data")
- Avg offer (Easy): Average of Avg offer (£) in E2:E11, rounded to 0 decimals. (sheet "Data")
- Max openings (Easy): Largest Openings in C2:C11. (sheet "Data")
- Pune rows (Easy): How many rows have Hub city "Pune"? (sheet "Data")
- Capgemini rows (Easy): How many rows have Company "Capgemini"? (sheet "Data")
- Infosys openings (Medium): Total of Openings where Company is "Infosys". (sheet "Data")
- Offer rate over 18 (Medium): How many hubs have Offer rate % > 18? (sheet "Data")
- Rounds in London Capgemini (Medium): Interview rounds for Hub city "London". (sheet "Data")
- Mumbai openings (Medium): Total of Openings where Hub city is "Mumbai". (sheet "Data")
- Share Capgemini openings (Hard): Capgemini openings / all openings, 3 decimals. (sheet "Data")
- Avg rounds (Hard): Average of Interview rounds in D2:D11, rounded to 1 decimal. (sheet "Data")
- Above avg offer? (Hard): "High" if E2 > average offer else "OK". (sheet "Data")
Worked example — capgemini infosys cognizant and wipro
Why
Vikram Rao in Pune and Yuki Tanaka abroad both need a clear, repeatable way to use capgemini infosys cognizant and wipro on a QuickCart Delivery sheet without breaking totals.
What
Capgemini Infosys Cognizant And Wipro 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 capgemini infosys cognizant and wipro.
- Enter a small made-up value for Vikram Rao 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 capgemini infosys cognizant and wipro is correct on one row, copy the same pattern down the column.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
