Hero MotoCorp Human Resource and MIS Executive Interview Questions and Answers

Q1. Why ?joined this company
Ans. I am confident about electronic component
Answered by Mayuddin Khatik
Add your answer
Q2. How did heir this position
Add your answer
Q3. What is your aim
Add your answer

Q1. Why apply for this job
Ans. Because I have experience
Answered by Mayuddin Khatik
Add your answer

Q1. Vba coding, macro, advance Excel
Add your answer
Q2. Vlookup, power bi
Add your answer

Q1. Work experience
Add your answer

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
Add your answer
Q2. Pivot table, power pivot
Add your answer

Q1. Vlookup,Countif,sumif,chart,data validation
Add your answer

Q1. Advanced Excel Skills to compact the time consuming tasks
Add your answer
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
Add your answer
Q3. Some basic understanding with Retail finance
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Familybackground
Add your answer

Q1. About your self
Add your answer
Q2. Whare live from
Ans. 
The question is asking about where I currently live.
• I currently live in New York City.

• I have been living in this city for the past 5 years.

• I live in a small apartment in Manhattan.
Answered by AI
Add your answer

Q1. Pivot tabal function
Add your answer
Q2. Index match formula
Ans. 
Index match formula is a powerful Excel function used to lookup values in a table.
• Index match is used to find a value in a table based on row and column criteria.

• It is more flexible and efficient than VLOOKUP function.

• Syntax: =INDEX(array, MATCH(lookup_value, lookup_array, 0))
Answered by AI
Add your answer
Q3. Sumif's function
Ans. 
SUMIF function adds up values based on a given condition in Excel.
• Used in Excel to sum values that meet a specific criteria

• Syntax: =SUMIF(range, criteria, [sum_range])

• Example: =SUMIF(A1:A10, ">10", B1:B10) will sum values in B1:B10 where corresponding value in A1:A10 is greater than 10
Answered by AI
Add your answer

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

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

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.

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

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

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...read more
Add your answer

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
View 3 more answers
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...read more
Answered by AI
View 1 more answer
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...read more
Add your answer

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
Add your answer
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...read more
Add your answer
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
Add your answer
Q4. . Ctrl + Pause/Break is used to stop VBScript if it goes into an infinite loop.
Add your answer