EY Global Delivery Services ( EY GDS) Assistant Manager Operations Interview Questions and Answers

xlookup is a function in Excel that allows you to search for a value in a table and return a corresponding value in the same row.

• xlookup is a newer function in Excel that replaces vlookup and hlookup

• It can search for values both horizontally and vertically

• It can return exact matches, approximate matches, and even return values from a range of cells

• It is a more flexible and powerful function than vlookup and hlookup

Change management involves planning, implementing, and monitoring changes to improve organizational effectiveness.

• Identify the need for change

• Develop a plan for change

• Communicate the change to stakeholders

• Implement the change

• Monitor and evaluate the change

• Example: Implementing a new software system to improve efficiency

Conflict resolution involves identifying and addressing disagreements or disputes in a constructive manner.

• Listen actively to both parties involved

• Identify the root cause of the conflict

• Propose potential solutions and negotiate a compromise

• Follow up to ensure the resolution is effective

• Example: Resolving a disagreement between two team members over project responsibilities by clarifying roles and setting clear expectat