Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Hero MotoCorp Team. If you also belong to the team, you can get access from here

Hero MotoCorp Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Hero MotoCorp MIS Associate Interview Questions and Answers

Updated 19 Apr 2023

Hero MotoCorp MIS Associate Interview Experiences

1 interview found

MIS Associate Interview Questions & Answers

user image Anonymous

posted on 19 Apr 2023

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2023. There were 2 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 - One-on-one 

(2 Questions)

  • Q1. 1. do you have knowledge of excel formula?
  • Ans. 

    Yes, I have knowledge of Excel formulas.

    • I am familiar with commonly used Excel formulas such as SUM, AVERAGE, IF, VLOOKUP, and CONCATENATE.

    • I can create complex formulas using functions, operators, and cell references.

    • I understand how to use absolute and relative cell references in formulas.

    • I am proficient in using functions like COUNT, COUNTIF, SUMIF, and IFERROR.

    • I can use logical operators like AND, OR, and NOT in for...

  • Answered by AI
  • Q2. 2. Anyone Examples.
  • Ans. 

    The question is asking for examples of anyone.

    • Examples of anyone could include: anyone can learn programming, anyone can be a leader, anyone can achieve their goals.

    • Anyone can become a successful entrepreneur.

    • Anyone can make a positive impact on society.

    • Anyone can contribute to a team's success.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Hero MotoCorp MIS Associate interview:
  • About Excel

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
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Technical abouts automobile sector
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2023. There were 9 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 - Aptitude Test 

Ans. The primary purpose of an MIS is to assist the management in making strategic, tactical, and operational decisions. It offers up-to-date information on the company’s assets and helps various departments like – Marketing, finance, R&D, manufacturing, etc. From storing data to making it accessible, MIS is a crucial aspect of every business today. Other primary objectives are:

Data storage
Data retrieval
Data propagation
Planning
Graphical report maki

Round 3 - Coding Test 

Provides you with a chance to demonstrate your technical skills in a practical environment and so need to be environment

Round 4 - Group Discussion 

The primary purpose of an MIS is to assist the management in making strategic, tactical, and operational decisions. It offers up-to-date information on the company's assets and helps various departments like – Marketing, finance, R&D, manufacturing, etc.

Round 5 - Assignment 

Q36. Which are some of the different types of error handling techniques?
Ans. This is common MIS executive interview question.

The following are three different types of error handling techniques:

On Error Goto 0
On Error Goto Err_Lbl
On Error Resume Next

Round 6 - Case Study 

Understand the issue; ask clarifying questions as needed.
Identify the underlying assumptions.
Summarize specific issues and findings.
State your recommendations.
Outline next steps and expected

Round 7 - HR 

(1 Question)

  • Q1. What is the purpose of an MIS? The most important function of an MIS is to aid management in making decisions about strategy and procedures. The MIS stores and organizes data for easy retrieval or for pr...
Round 8 - Technical 

(3 Questions)

  • Q1. What is the Logical Function?
  • Ans. 

    Logical function is a function that returns a value based on one or more input values.

    • Logical functions are used in programming and mathematics to make decisions based on conditions.

    • Examples include IF function in Excel, AND, OR, NOT functions in programming languages.

    • They evaluate expressions and return true or false based on the conditions.

  • Answered by AI
  • Q2. What is the need of INDEX & MATCH in Excel?
  • Ans. 

    INDEX & MATCH in Excel are used together to lookup values in a table based on specific criteria.

    • INDEX function returns the value of a cell in a table based on the row and column number provided.

    • MATCH function returns the position of a value in a range.

    • Used together, INDEX & MATCH can perform advanced lookups that VLOOKUP or HLOOKUP cannot handle.

    • INDEX & MATCH combination is more flexible and efficient for searching and...

  • Answered by AI
  • Q3. This MIS executive interview question based on Excel functions, you can mention that INDEX & MATCH is an alternative to VLOOKUP. VLOOKUP works only as a static column reference, while INDEX & MATCH is much...
Round 9 - One-on-one 

(4 Questions)

  • Q1. What is Option Explicit and Option Base?
  • Ans. 

    Option Explicit forces explicit declaration of all variables in a script, while Option Base sets the default lower bound for array subscripts.

    • Option Explicit ensures all variables are declared before use to avoid runtime errors.

    • Option Base sets the default lower bound for array subscripts, usually 0 or 1.

    • Example: Option Explicit Dim x As Integer x = 5

    • Example: Option Base 1 Dim arr(5) As Integer

  • Answered by AI
  • Q2. Answering this MIS interview question briefly will help the recruiter find your technical skills. You can just differentiate between the two as pointers below. 1. Option Explicit makes the declaration of t...
  • Q3. How can you stop VBScript when it goes into the infinite loop?
  • Ans. 

    To stop VBScript from an infinite loop, you can use the 'Ctrl + Break' keyboard shortcut or close the program through Task Manager.

    • Use 'Ctrl + Break' keyboard shortcut to stop the script execution

    • Close the program through Task Manager if 'Ctrl + Break' doesn't work

  • Answered by AI
  • Q4. . Ctrl + Pause/Break is used to stop VBScript if it goes into an infinite loop.

Interview Preparation Tips

Topics to prepare for Mahindra & Mahindra MIS Executive interview:
  • I am crm incharge and solutions
Interview preparation tips for other job seekers - Make use of networking and both online and non-online job search opportunities. Use a resume builder to write a one-page, job-tailored resume that makes it past ATS. Proofread and make sure there are no typos or grammatical errors. Go to interviews early, rested, and with a positive attitude.

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
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Jul 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Advanced Excel Skills to compact the time consuming tasks
  • Q2. Grasping And Building abilities with ECM graphs
  • Ans. 

    Grasping and building abilities with ECM graphs

    • ECM graphs refer to Enterprise Content Management graphs

    • Grasping abilities involve understanding the structure and components of ECM graphs

    • Building abilities involve creating and manipulating ECM graphs

    • Examples of ECM graphs include document hierarchies, workflow diagrams, and metadata models

  • Answered by AI
  • Q3. Some basic understanding with Retail finance

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Department selection
  • Q2. Which is your best subject?
  • Q3. Manufacturing engineering
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Common Aptitude test contains numerical abilities , logical reasoning, Technical Questions

Round 2 - Coding Test 

Reverse String , Bit manipulation

Round 3 - HR 

(1 Question)

  • Q1. Utterly Basic Questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't panic

I applied via Newspaper Ad and was interviewed in Jul 2022. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be urself:
Don't be try to over confidence
Round 1 - One-on-one 

(1 Question)

  • Q1. Be strong in your basics

Interview Preparation Tips

Interview preparation tips for other job seekers - Know about yourself and your profile very well before attending any interview

Hero MotoCorp Interview FAQs

How many rounds are there in Hero MotoCorp MIS Associate interview?
Hero MotoCorp interview process usually has 2 rounds. The most common rounds in the Hero MotoCorp interview process are Resume Shortlist and One-on-one Round.
What are the top questions asked in Hero MotoCorp MIS Associate interview?

Some of the top questions asked at the Hero MotoCorp MIS Associate interview -

  1. 1. do you have knowledge of excel formu...read more
  2. 2. Anyone Exampl...read more

Tell us how to improve this page.

Hero MotoCorp MIS Associate Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Tata Motors Interview Questions
4.2
 • 997 Interviews
Maruti Suzuki Interview Questions
4.2
 • 597 Interviews
TVS Motor Interview Questions
4.0
 • 308 Interviews
Bajaj Auto Interview Questions
3.9
 • 270 Interviews
Ashok Leyland Interview Questions
4.1
 • 237 Interviews
View all
Hero MotoCorp MIS Associate Salary
based on 6 salaries
₹3.7 L/yr - ₹5.2 L/yr
31% more than the average MIS Associate Salary in India
View more details

Hero MotoCorp MIS Associate Reviews and Ratings

based on 2 reviews

4.6/5

Rating in categories

5.0

Skill development

4.6

Work-life balance

4.4

Salary

3.1

Job security

3.1

Company culture

5.0

Promotions

3.7

Work satisfaction

Explore 2 Reviews and Ratings
Deputy Manager
1k salaries
unlock blur

₹6 L/yr - ₹21 L/yr

Assistant Manager
690 salaries
unlock blur

₹5.6 L/yr - ₹18.4 L/yr

Associate Manager
645 salaries
unlock blur

₹10.4 L/yr - ₹25.7 L/yr

Territory Sales Manager
353 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Engineer
336 salaries
unlock blur

₹3.5 L/yr - ₹12 L/yr

Explore more salaries
Compare Hero MotoCorp with

Bajaj Auto

3.9
Compare

TVS Motor

4.0
Compare

Royal Enfield

4.2
Compare

Suzuki Motorcycle

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