18. Interview Questions Asked in MNC Interviews
18.3 Accenture
M26. Create a PivotTable of sales by region and product, and add a calculated field.
Reported for: Accenture [S2]
Insert › PivotTable from the Table › Region to Rows, Product to Columns (or below Region in Rows), Sales to Values. Then PivotTable Analyze › Calculations › Fields, Items & Sets › Calculated Field, e.g. Commission = Sales*0.05 or Profit = Sales-Cost. Remember calculated fields work on summed values, so ratios must be built from sums.
M27. Write a formula for a bonus: 10% of salary if sales exceed 1,00,000, otherwise 5%.
Reported for: Accenture [S2]
=IF(C2>100000,B2*10%,B2*5%) where B = Salary and C = Sales. Better practice: keep the threshold and rates in input cells and use absolute references, e.g. =B2*IF(C2>$G$1,$G$2,$G$3).
M28. What is VLOOKUP and what are its limitations?
Reported for: Accenture [S3] · also MathCo [S15]
VLOOKUP finds a value in the first column of a range and returns a value from a column number to the right. Limitations: cannot look left; hard-coded column index breaks when columns are inserted; approximate match by default if the last argument is omitted; returns only the first match; sensitive to extra spaces and text-number mismatches.
M29. What are PivotTables and how do you use them?
Reported for: Accenture [S3] · also Deloitte [S1], TCS [S4], Mu Sigma [S7], PwC [S9], MathCo [S15]
An interactive summary tool: drag fields to Rows, Columns, Values and Filters to aggregate large data in seconds. I use them for sales by city and month, % of total, month grouping, top-N filters and quick exploration before building a report. They refresh with one click when based on a Table.
M30. How do you handle large datasets efficiently in Excel?
Reported for: Accenture [S3] · also Amazon [S8]
Load only needed columns/rows through Power Query, use the Data Model for millions of rows, prefer pivots over thousands of lookup formulas, avoid volatile and whole-column formulas, use Manual calculation while editing, and save as .xlsb. For data beyond Excel's 1,048,576-row limit, keep it in the Data Model or a database.
Ravindra Bagale's Tip
In formula questions like Accenture's bonus question, many students hard-code 100000 and 10% right in the formula. It works in a live test, but tell the interviewer that keeping the threshold and rates in input cells and using absolute references is better – that shows a professional habit.
Ravindra Bagale's Tip – मराठी
Accenture च्या bonus सारख्या formula प्रश्नात बरेच students 100000 आणि 10% formula मधेच hard-code करतात. Live test मध्ये चालेल, पण interviewer ला सांगा की threshold आणि rates input cells मध्ये ठेवून absolute reference ने वापरणं जास्त चांगलं आहे – हीच professional सवय दाखवते.
Ravindra Bagale's Tip – हिंदी
Accenture के bonus जैसे formula सवालों में बहुत से students 100000 और 10% को formula में ही hard-code कर देते हैं. Live test में चल जाएगा, पर interviewer को बताओ कि threshold और rates को input cells में रखकर absolute reference से इस्तेमाल करना बेहतर है – यही professional आदत दिखाता है.
Loading practice tasks...
- Total deals won (Easy): Add up Deals won in the "Deals won" column.
- Average avg deal value (Easy): Average of the Avg deal value (£) column, rounded to 2 decimals.
- Rows in North (Easy): How many rows have Region "North"?
- Largest deals won (Easy): The largest value in the "Deals won" column.
- Deals won for North (Medium): Total of the Deals won column where Region is "North".
- North in Leeds (Medium): Total of the Deals won column where Region is "North" and City is "Leeds".
- Best in North (Medium): Largest value in the "Avg deal value (£)" column where "Region" is "North".
- Value of row 2 (Medium): Multiply the first-row Deals won by the first-row Avg deal value (£).
- Look up Sneha Patil (Medium): The Deals won for "Sneha Patil" (use a lookup on the "Name" column).
- Total value (Hard): Sum of "Deals won" times "Avg deal value (£)" for all rows.
- Share of North (Hard): Share of the "Deals won" column that is "North", rounded to 3 decimals.
- How many rows are above the average "Avg deal value (£)" (Hard): Count the rows where "Avg deal value (£)" is above the average "Avg deal value (£)".
- Above average? (Hard): "Above" if the "Avg deal value (£)" value in the first row is above the average of the "Avg deal value (£)" column, else "Below".
Worked example — accenture
Why
Aarti Kulkarni in Pune and James O'Neill abroad both need a clear, repeatable way to use accenture on a Maple Bakery Co sheet without breaking totals.
What
Accenture 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 accenture.
- Enter a small made-up value for Aarti Kulkarni using € where money appears.
- Add a second value for James O'Neill 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 accenture 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.
