Upload Button Icon Add office photos

Tata Motors

Compare button icon Compare button icon Compare
4.2

based on 11.6k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Tata Motors MIS Executive Interview Questions and Answers

Updated 14 Apr 2024

Tata Motors 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
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

Interview Questionnaire 

1 Question

  • Q1. Spares parts store maintenance and mis reports

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
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

How to work in market against competitors

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

I applied via Company Website and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Case Study 

That he really work in Damodar Valley Corporation in accounts bill section work and work in accounts work it or not,case study.

Round 3 - One-on-one 

(8 Questions)

  • Q1. Add bill section work and accounts Excutive questions which you work to clarify
  • Ans. Add your questions .what I will say about the matter. What are you wanting to more questions?
  • Answered by Narendra Nath Gorai
  • Q2. And they finalise whether his helping hand require for 1 month
  • Q3. Then the decide board
  • Q4. I have nothing to say about the finalise the decision that the supreme of the boards decision
  • Q5. They there related questions
  • Q6. There decision is final decision
  • Q7. If not suitable they final decision on making
  • Q8. Not to talk about it

Interview Preparation Tips

Interview preparation tips for other job seekers - What I give you advice. That they decision on their hands and finalise
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Psychological test by HR
Round 3 - HR 

(1 Question)

  • Q1. Questioning about my last job .

Tata Motors Interview FAQs

How many rounds are there in Tata Motors MIS Executive interview?
Tata Motors interview process usually has 1 rounds. The most common rounds in the Tata Motors interview process are One-on-one Round.

Tell us how to improve this page.

Tata Motors MIS Executive Salary
based on 59 salaries
₹2 L/yr - ₹4.5 L/yr
9% more than the average MIS Executive Salary in India
View more details

Tata Motors MIS Executive Reviews and Ratings

based on 12 reviews

4.5/5

Rating in categories

3.2

Skill development

4.5

Work-life balance

3.9

Salary

4.6

Job security

4.4

Company culture

3.1

Promotions

3.5

Work satisfaction

Explore 12 Reviews and Ratings
Senior Manager
6.2k salaries
unlock blur

₹6.7 L/yr - ₹28.5 L/yr

Executive
825 salaries
unlock blur

₹2.9 L/yr - ₹12.2 L/yr

Deputy General Manager
792 salaries
unlock blur

₹13 L/yr - ₹47 L/yr

Manager
422 salaries
unlock blur

₹6 L/yr - ₹21 L/yr

Quality Engineer
421 salaries
unlock blur

₹1.2 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Tata Motors with

Maruti Suzuki

4.2
Compare

Mahindra & Mahindra

4.1
Compare

Mercedes-Benz Research and Development India

3.9
Compare

Ashok Leyland

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