Mercer Lead Analyst Interview Questions and Answers

Q1. Provide SOP for Account Payables.
Ans. 
SOP for Account Payables involves verifying invoices, obtaining approvals, processing payments, and reconciling accounts.
• Verify invoices against purchase orders and receipts

• Obtain necessary approvals for payment

• Process payments accurately and timely

• Reconcile accounts to ensure accuracy

• Maintain proper documentation for audit purposes
Answered by AI
Add your answer
Q2. What is turnover discount?
Ans. 
Turnover discount is a reduction in price offered to customers who purchase a large quantity of goods or services.
• Turnover discount is commonly used in retail and wholesale industries to incentivize bulk purchases.

• The discount amount typically increases with the quantity purchased.

• For example, a supplier may offer a 10% turnover discount for customers who buy 100 units of a product.

• Turnover discount helps businesses in...read more
Answered by AI
Add your answer

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

It was a altitude test.

Q1. It was a technical inyerview.
Add your answer

Q1. This was 2nd thechnical interview.
Add your answer

Q1. Final hr round. Job relayed discussion
Add your answer

You have to pass aptitude test with minimum 75%.

Q1. What is the use of financial statements in business.
Add your answer
Q2. How do we calculate debt to equity ratio.
Add your answer

Q1. Personal Information.
Add your answer
Q2. Family Background.
Add your answer

They donot have proper knowledge about the skill they are asking for. Very rude experience it shows their company culture and how they work. No dont join it will not work for experienced candidates

They donot have proper knowledge about the skill they are asking for. Very rude experience it shows their company culture and how they work. No dont join it will not work for experienced candidates

Q1. Salary negotiation
Add your answer
Q2. Date of joining
Add your answer

Q1. What are the challenges faced?
Add your answer

Q1. How you manage stakeholder relationship?
Ans. 
I manage stakeholder relationships by maintaining open communication, understanding their needs, and addressing any concerns promptly.
• Regularly communicate with stakeholders to keep them informed

• Listen to their feedback and address any concerns or issues promptly

• Understand their needs and expectations to ensure alignment with project goals

• Build trust and rapport through transparency and honesty

• Seek input and involve st...read more
Answered by AI
Add your answer

Q1. What is cash flow statement, budgeting, forecasting Examples of cash flow statements
Ans. 
Cash flow statement shows the inflow and outflow of cash, budgeting is planning for future expenses, forecasting is predicting financial outcomes.
• Cash flow statement shows the sources and uses of cash in a business

• Budgeting involves setting financial goals and creating a plan to achieve them

• Forecasting involves predicting future financial outcomes based on historical data

• Examples of cash flow statements include operati...read more
Answered by AI
Add your answer

Q1. Salary expectations
Add your answer