Upload Button Icon Add office photos

Filter interviews by

Automotive Manufacturers MIS Executive Interview Questions and Answers

Updated 2 May 2021

Automotive Manufacturers MIS Executive Interview Experiences

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Vba coding, macro, advance Excel
  • Q2. Vlookup, power bi
Round 2 - Behavioral 

(1 Question)

  • Q1. Work experience
Round 3 - Senior mis 

(2 Questions)

  • Q1. Advance Excel formula
  • Ans. 

    Advanced Excel formula refers to complex functions and operations used to manipulate data in Excel.

    • Use functions like VLOOKUP, INDEX, MATCH, SUMIF, COUNTIF for advanced data analysis

    • Learn how to use array formulas to perform calculations on multiple cells at once

    • Understand how to use conditional formatting to highlight important data

    • Practice using pivot tables to summarize and analyze large datasets

  • Answered by AI
  • Q2. Pivot table, power pivot

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Dec 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Vlookup,Countif,sumif,chart,data validation
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Excel test only

Interview Preparation Tips

Interview preparation tips for other job seekers - Very good experience
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Group Discussion 

They have organized a Zoom Interview.Its All About Self Introduction And Advance Excel Quetionary.

Round 3 - Technical 

(1 Question)

  • Q1. Advance Excel Like- Power Query, Sumproduct, Advance Vloookup and H Lookup,PPT, nested if conditions ,Sumifs, Chart,Dashboard Etc.

I applied via Recruitment Consultant and was interviewed in May 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About yourself, qulafication, previous job

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not copy other's Resume. be confident on your skills.
dont mantion/tell false information to show himself as extraordinary Be honest.
If u give some fake information then your 100% command should on that and to get this command you will have to do a lot of practice.
So please do this hardwork only to sharp your skills.
Talk with interviewer, gently with smile like you are meeting your old friend not interviewer.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - HR 

(5 Questions)

  • Q1. Tell me something about your self
  • Ans. 

    I am a dedicated HR executive with 5 years of experience in recruitment, employee relations, and performance management.

    • I have a Bachelor's degree in Human Resources Management

    • I have successfully implemented new employee onboarding processes at my previous company

    • I excel in conflict resolution and team building

    • I am proficient in HRIS systems and data analysis

  • Answered by AI
  • Q2. What is hr and it's functions
  • Ans. 

    HR (Human Resources) is a department within an organization responsible for managing employees, recruitment, training, and employee relations.

    • Recruitment and selection of employees

    • Training and development programs

    • Performance management and appraisal

    • Employee relations and conflict resolution

    • Compensation and benefits administration

  • Answered by AI
  • Q3. What is the year of PF
  • Ans. 

    The year of PF refers to the year in which the Employees' Provident Fund (EPF) was established in India.

    • The Employees' Provident Fund (EPF) was established in 1952.

    • The EPF Act was enacted in 1952, leading to the establishment of the EPF organization.

    • The EPF scheme was introduced to provide retirement benefits to employees in India.

  • Answered by AI
  • Q4. What is the year of ESI
  • Q5. Why should we hire you

Interview Preparation Tips

Interview preparation tips for other job seekers - First I will say confidence to tell your self
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is VCB, how it works
  • Ans. 

    VCB stands for Vacuum Circuit Breaker, which is a type of circuit breaker that uses a vacuum to extinguish the arc when the contacts open.

    • VCB is a type of circuit breaker that uses a vacuum to extinguish the arc when the contacts open.

    • It is commonly used in medium voltage applications.

    • VCBs are more efficient and require less maintenance compared to traditional circuit breakers.

    • Example: A VCB is used in a power distribu...

  • Answered by AI
  • Q2. What is ACB how it works
  • Ans. 

    ACB stands for Average Cost of Borrowing. It is a financial metric used to calculate the average cost of debt for a company.

    • ACB is calculated by dividing the total interest expense by the average amount of debt outstanding during a specific period.

    • It helps companies understand how much they are paying in interest on their debt on average.

    • ACB is important for financial analysis and decision-making, as it provides insigh...

  • Answered by AI
Round 2 - Group Discussion 

There was a discussion about how to work safely in a company.everyone has shared their views

Interview Preparation Tips

Interview preparation tips for other job seekers - There all are very nice people, they stay with you every step of the way, if something doesn't work out they will tell you how to sort it out , everyone has friendly behavior , The Best Automobile industry in India

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. How do you plan to travel?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

How to work in market against competitors

Automotive Manufacturers Interview FAQs

How to prepare for Automotive Manufacturers MIS Executive interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Automotive Manufacturers. The most common topics and skills that interviewers at Automotive Manufacturers expect are Advanced Excel, MIS, Concatenate, Conditional Formatting and Countif.

Tell us how to improve this page.

Automotive Manufacturers MIS Executive Salary
based on 5 salaries
₹2.5 L/yr - ₹3.6 L/yr
At par with the average MIS Executive Salary in India
View more details

Automotive Manufacturers MIS Executive Reviews and Ratings

based on 3 reviews

5.0/5

Rating in categories

3.5

Skill development

3.9

Work-life balance

3.9

Salary

4.9

Job security

3.5

Company culture

3.5

Promotions

4.0

Work satisfaction

Explore 3 Reviews and Ratings
Assistant Manager
163 salaries
unlock blur

₹2.9 L/yr - ₹10 L/yr

Quality Engineer
141 salaries
unlock blur

₹1.2 L/yr - ₹5.2 L/yr

Sales Executive
137 salaries
unlock blur

₹1.2 L/yr - ₹5 L/yr

Executive Accountant
108 salaries
unlock blur

₹1.6 L/yr - ₹4.5 L/yr

Production Engineer
93 salaries
unlock blur

₹1.3 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Automotive Manufacturers with

Tata Motors

4.2
Compare

Mahindra & Mahindra

4.1
Compare

Maruti Suzuki

4.2
Compare

Ashok Leyland

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview