EXL Service Senior MIS Executive Interview Questions and Answers

Q1. What is vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Used in Excel to search for a value in the first column of a table and return a value in the same row from another column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the first column of the ra...read more
Answered by AI
Add your answer
Q2. What is hlookup
Ans. 
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
• Used in Excel to search for a value in the top row of a table

• Returns a value in the same column from a specified row

• Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

• Example: =HLOOKUP(123, A1:D4, 3, FALSE) - searches for 123 in the top row of the table A1
Answered by AI
Add your answer

Q1. Tell me about your self
Ans. 
Experienced executive with a proven track record in leading teams and driving business growth.
• Over 10 years of experience in senior leadership roles

• Strong strategic planning and decision-making skills

• Successful track record in increasing revenue and profitability

• Effective communicator and team builder

• Led a team that achieved a 20% increase in sales last year
Answered by AI
Add your answer
Q2. Tell me about your last company
Ans. 
My last company was a tech startup focused on developing innovative software solutions for small businesses.
• Developed a user-friendly mobile app for scheduling appointments

• Implemented a cloud-based CRM system to track customer interactions

• Collaborated with marketing team to launch successful social media campaigns
Answered by AI
Add your answer

Case study questions and basic maths and grammar questions

Q1. About your self
Add your answer
Q2. Asking my work experience
Add your answer
Q3. What is Recruitment ?
Ans. 
Recruitment is the process of finding, attracting, and hiring qualified candidates for a job.
• Identifying job vacancies

• Creating job descriptions and requirements

• Posting job ads on various platforms

• Screening resumes and conducting interviews

• Selecting and hiring the best candidate

• Onboarding and training new employees
Answered by AI
Add your answer
Q4. What are the process of onboarding?
Ans. 
Onboarding process involves orientation, training, and integration of new employees into the organization.
• Orientation: Introducing new hires to company policies, culture, and facilities.

• Training: Providing job-specific training to ensure new employees are equipped to perform their roles effectively.

• Integration: Helping new employees build relationships with colleagues and understand their roles within the organization.

• ...read more
Answered by AI
Add your answer

Q1. What is the interest which attracted to hr field
Add your answer
Q2. Skills required for recruitment
Add your answer

Q1. Why we are hiring you?
Add your answer

Simple test good test easily can be done

Q1. Ask technical questions
Add your answer
Q2. What is hr, shrm, tests, interview
Add your answer

Q1. Curranty ware do you work, want to join Nielsen.
Add your answer

Previous role details, projects handled, skills like handling a team, problem solving skills.

Q1. 45 min interview detailed HR round, complet work experience project's handled in previous roles.
Add your answer

Answering all the application orientated question

They will provide us a case so that all people will discuss n having the interaction between all the group people

Q1. Why should we hire you?
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. What is your family background?
Add your answer
Q4. Tell me about yourself.
Add your answer