Megha Engineering & Infrastructures HR Executive Interview Questions and Answers

Q1. General introduction and labour law
Add your answer

Q1. V lookup,countif formula
Add your answer
Q2. What is vlookup formula
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from a specified column.
• VLOOKUP stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

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

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - s...read more
Answered by AI
Add your answer
Q3. What is countif formula
Ans. 
COUNTIF formula is used in Excel to count the number of cells that meet a specific criteria.
• COUNTIF formula syntax: =COUNTIF(range, criteria)

• Example: =COUNTIF(A1:A10, ">50") will count the number of cells in range A1:A10 that are greater than 50

• Criteria can be a number, text, expression, or cell reference
Answered by AI
Add your answer

Current company Job Responsibilities,Background achievement, Qualification..etc

Q1. Job related questions
Add your answer
Q2. Regarding CLRA,ISMW,BOCW ACT
Add your answer
Q3. Payroll Management
Add your answer
Q4. Staff welfare realated
Add your answer

Q1. Salary negotiation
Add your answer

BUSINESS PROCESS APTITUDE TEST (BPAT)

UNDER GO GD AND CASE STUDY DISCUSSION

HOLLAND CODE . PAPER & PENCIL TEST.ADMINISTERED AFTER GD

Q1. PERSONAL INTERVIEW
Add your answer

Q1. PROFESSIONAL INTERVIEW
Add your answer

Q1. About current profile Challenges faced
Add your answer
Q2. Why do you want to leave current job
Ans. 
Seeking new challenges and growth opportunities
• Looking for a role that offers more responsibility and leadership opportunities

• Desire to work in a larger organization with a diverse workforce

• Seeking a company that aligns with my values and offers better work-life balance

• Want to expand my HR knowledge and skills by working in different industries

• Current job lacks career advancement prospects
Answered by AI
Add your answer
Q3. Quote one challenge
Ans. 
Managing employee turnover
• Developing retention strategies

• Conducting exit interviews to identify reasons for leaving

• Offering competitive compensation and benefits

• Providing opportunities for growth and development

• Creating a positive work culture and environment
Answered by AI
Add your answer

Q1. What factors influenced your decision to choose this role?
Add your answer
Q2. What
Add your answer

What are your salary expectations?

Q1. About marriage and marriage plan
Add your answer

Q1. Excel sheet and word sheet preparation
Add your answer