TVS Motor MIS Executive Interview Questions and Answers

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

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

Q1. Excel test only
Add your answer

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

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

Previous company experience ,technical,SAP experience and inventory management
Material gap analyse , bom correction etc...

Q1. How Many vehicle report in your company and how to manage receiving process reconcile process inventory control process
Ans. 
Our company manages a fleet of 100 vehicles and utilizes a systematic process for receiving, reconciling, and controlling inventory.
• We have a total of 100 vehicles in our company's fleet.

• We use a systematic process for receiving new vehicles into our inventory.

• We have a reconciliation process in place to ensure accurate inventory records.

• Inventory control measures are implemented to track and manage the usage of vehicl...read more
Answered by AI
Add your answer
Q2. Gate entry process Material management process 5S SAP process Main power handling
Add your answer

Q1. Purchase account
Add your answer
Q2. How many days work
Ans. 
The number of days work required depends on the specific tasks and deadlines for the Executive Accountant role.
• The number of days work can vary based on the complexity of financial reports, audits, and budget analysis required.

• Deadlines for financial statements, tax filings, and other accounting tasks may impact the number of days work needed.

• Prioritizing tasks and efficient time management can help in completing work
Answered by AI
Add your answer

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

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

Q1. Reason to change the job
Add your answer
Q2. Field issues in experiences quality departments
Ans. 
Field issues in quality departments can range from communication breakdowns to lack of resources.
• Communication breakdowns between departments causing delays in resolving quality issues

• Lack of resources such as skilled personnel or equipment leading to subpar quality control

• Inadequate training for quality department staff resulting in errors or inefficiencies

• Failure to implement proper quality management systems leading...read more
Answered by AI
Add your answer

Q1. What you know about Honda
Ans. 
Honda is a Japanese multinational corporation known for manufacturing automobiles, motorcycles, and power equipment.
• Founded in 1946 by Soichiro Honda and Takeo Fujisawa

• One of the largest automobile manufacturers in the world

• Known for their reliable and fuel-efficient vehicles

• Popular models include Civic, Accord, and CR-V
Answered by AI
Add your answer