Upload Button Icon Add office photos

Filter interviews by

Bhandari Automobiles MIS Executive Interview Questions and Answers

Updated 12 Sep 2023

Bhandari Automobiles MIS Executive Interview Experiences

1 interview found

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 12 Sep 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Sep 2022. There were 4 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 - HR 

(1 Question)

  • Q1. General questions about your profile.
Round 3 - Technical 

(1 Question)

  • Q1. Excel test Vlookup pivot table formulas etc.
Round 4 - Group Discussion 

Discussion with manager and HR and they will discuss about job profile.

Interview questions from similar companies

I applied via Referral and was interviewed before Sep 2021. 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 - HR 

(2 Questions)

  • Q1. Questions related to your life and society to check your presence of mind and awareness of the world.
  • Q2. Question from ic engines,about their working and processes involved.

Interview Preparation Tips

Topics to prepare for Tata Motors Associate interview:
  • Automobile,ic engines,excel.
Interview preparation tips for other job seekers - Be yourself,prepare well and hope for the best...
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Dec 2021. 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 

First off all, we ought to have some sortoff automobile and production knowledge because they will definitely check our technical skill secondly, listening skill and fluency plays significant factor

Round 3 - HR 

(2 Questions)

  • Q1. It was more like technical round moreover you have to be clear in purpose of your life based upon they are recruiting
  • Q2. Define tqbm ? What is bom?
  • Ans. 

    TQBM stands for 'Tudo Que Bem' which means 'Everything is fine' in Portuguese. BOM means 'good' in Portuguese.

    • TQBM is a common phrase used in Brazil to ask if everything is okay.

    • BOM is often used as a response to TQBM to indicate that everything is good.

    • Both TQBM and BOM are informal and commonly used in everyday conversations.

    • Example: A friend asks 'TQBM?' and you respond 'BOM, e voce?' which means 'Everything is fine

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Believe in yourself and consistency plays major part always give your 100%

I applied via Walk-in and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Ntng

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was a techinical one but was major a test .The interview wanted to test both knowledge and communication skills

I applied via Indeed and was interviewed before Feb 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They did checked my confidence level

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and be prepared a bit though u don't know to answer just say I'll learn n get bck to you.

Interview Questionnaire 

1 Question

  • Q1. Technical

I applied via Naukri.com and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Ask related to mIs
  • Q2. Related to audits
  • Q3. Ms excel,word,powerpoint

Interview Preparation Tips

Interview preparation tips for other job seekers - It was amazing session
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
-
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

Associate Interview Questions & Answers

Bajaj Auto user image pradnya gadahire

posted on 31 Jul 2024

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

I applied via Referral and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Logical aptitude test

Round 2 - Technical 

(2 Questions)

  • Q1. Practical test of vlookup and pivot
  • Q2. What is sap and explain tcodee
  • Ans. 

    SAP is a software used by companies for managing business operations and customer relations. Tcode is a transaction code used to access specific functions in SAP.

    • SAP stands for Systems, Applications, and Products in Data Processing.

    • It is a software used by companies for various business operations like finance, HR, sales, etc.

    • Tcode is a transaction code used to access specific functions in SAP, like creating a purchase

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Bajaj Auto Associate interview:
  • SAP
Interview preparation tips for other job seekers - Join on contract basis

Skills evaluated in this interview

Bhandari Automobiles Interview FAQs

How many rounds are there in Bhandari Automobiles MIS Executive interview?
Bhandari Automobiles interview process usually has 4 rounds. The most common rounds in the Bhandari Automobiles interview process are Resume Shortlist, HR and Technical.
How to prepare for Bhandari Automobiles 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 Bhandari Automobiles. The most common topics and skills that interviewers at Bhandari Automobiles expect are Advanced Excel, Charts, Conditional Formatting, Countif and Data Validation.

Tell us how to improve this page.

Bhandari Automobiles MIS Executive Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Tata Motors Interview Questions
4.2
 • 999 Interviews
Maruti Suzuki Interview Questions
4.2
 • 586 Interviews
Hero MotoCorp Interview Questions
4.1
 • 334 Interviews
TVS Motor Interview Questions
4.0
 • 313 Interviews
Bajaj Auto Interview Questions
3.9
 • 267 Interviews
Ashok Leyland Interview Questions
4.1
 • 239 Interviews
Royal Enfield Interview Questions
4.2
 • 153 Interviews
Sonalika Tractors Interview Questions
3.6
 • 129 Interviews
Force Motors Interview Questions
3.6
 • 117 Interviews
View all
Bhandari Automobiles MIS Executive Salary
based on 5 salaries
₹1.5 L/yr - ₹2 L/yr
49% less than the average MIS Executive Salary in India
View more details

Bhandari Automobiles MIS Executive Reviews and Ratings

based on 3 reviews

4.0/5

Rating in categories

1.4

Skill development

4.6

Work-life balance

3.0

Salary

3.6

Job security

3.4

Company culture

2.4

Promotions

2.6

Work satisfaction

Explore 3 Reviews and Ratings
Relationship Manager
51 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Service Advisor
38 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Executive Accountant
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Executive
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

HR Manager
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Bhandari Automobiles with

Maruti Suzuki

4.2
Compare

Tata Motors

4.2
Compare

Mahindra & Mahindra

4.1
Compare

Hero MotoCorp

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