Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by MDIndia Health Insurance TPA Team. If you also belong to the team, you can get access from here

MDIndia Health Insurance TPA Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

MDIndia Health Insurance TPA MIS Executive Interview Questions and Answers

Updated 9 Sep 2024

MDIndia Health Insurance TPA MIS Executive Interview Experiences

3 interviews found

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 19 Jun 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - One-on-one 

(2 Questions)

  • Q1. Vlookup, index match, pivot table
  • Q2. Special pest, unique data, countif

Interview Preparation Tips

Interview preparation tips for other job seekers - Only need skills

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 11 Feb 2022

Round 1 - Technical 

(4 Questions)

  • Q1. Create pivot table base on givn table
  • Ans. 

    To create a pivot table, select the data range and go to Insert tab > PivotTable.

    • Select the data range

    • Go to Insert tab > PivotTable

    • Choose the location for the pivot table

    • Drag and drop the fields into the Rows, Columns, and Values areas

    • Apply filters and formatting as needed

  • Answered by AI
  • Q2. Consolidate data as per the requirement
  • Q3. Function in excel like vlook up, left, substitue,countif,
  • Q4. Simple Reasoning questions
Round 2 - One-on-one 

(3 Questions)

  • Q1. About current job working
  • Q2. Why u are leaving current job
  • Ans. 

    Seeking new challenges and growth opportunities.

    • Looking for a more challenging role

    • Seeking career advancement

    • Want to broaden my skillset

    • Current job lacks growth opportunities

    • Company restructuring or downsizing

    • Relocation or commute issues

  • Answered by AI
  • Q3. Some advance excel Fun and macro and VBA basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Please do practice before going to interview

Skills evaluated in this interview

MIS Executive Interview Questions Asked at Other Companies

Q1. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU W ... read more
Q2. Excel function explain Pivot table. Vlookup.hole look-up.xlook-up ... read more
asked in HCLTech
Q3. What is the advantages of Data validation and why we use it?
Q4. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 18 Nov 2021

Interview Questionnaire 

2 Questions

  • Q1. Vlookup filter pivot table sum sumifs
  • Q2. Filter Freez pain rowaz

MIS Executive Jobs at MDIndia Health Insurance TPA

View all

Interview questions from similar companies

I applied via Recruitment Consulltant and was interviewed before Nov 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 - Aptitude Test 

Advance excel test like sumif countif vlookup pivote

Round 3 - HR 

(2 Questions)

  • Q1. About current company profile and previous company profile
  • Q2. About yourself and current and previous company background

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepare with excel formulas like sumif counif pivot vlookup if formula

I applied via Referral and was interviewed in Jan 2022. There were 3 interview rounds.

Round 1 - HR 

(6 Questions)

  • Q1. What are your strengths and weaknesses?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. What are your salary expectations?
  • Q5. Why should we hire you?
  • Q6. Tell me about yourself.
Round 2 - Technical 

(1 Question)

  • Q1. Why we are use excel & formulas
  • Ans. 

    Excel and formulas are used for data analysis, calculations, and organizing information efficiently.

    • Excel allows for easy data entry and manipulation.

    • Formulas in Excel enable automated calculations and data analysis.

    • Excel provides various functions and tools for data organization and visualization.

    • Excel can handle large datasets and perform complex calculations.

    • Formulas in Excel can be used for financial analysis, stat...

  • Answered by AI
Round 3 - Dicusssion about my previous job 

(7 Questions)

  • Q1. Tell me about your self & previous job
  • Q2. How much slary do you expect
  • Ans. 

    I expect a salary that is commensurate with my skills and experience.

    • I am open to negotiation based on the job requirements and responsibilities.

    • I have researched the industry standards and salary ranges for this position.

    • I am looking for a fair and competitive salary package that includes benefits and perks.

    • I am more interested in the growth opportunities and learning potential of the job than just the salary.

    • I am wil...

  • Answered by AI
  • Q3. Why should i hire you
  • Q4. What is your strength & weknes
  • Q5. Why are you looking for a job
  • Q6. Tell me about your previous job
  • Q7. When will you join our organization

Interview Preparation Tips

Topics to prepare for Axis Max Life Insurance MIS Executive interview:
  • Advanced Excel
  • Communication Skills
Interview preparation tips for other job seekers - Everyone has thier has own talent, which they can take the job by doing it.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Basically insurance related
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. V Lookup,index match, pivot,sumif,countif,etc
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about your self, work experience knowledge etc
  • Q2. Rate of yourself in excel
  • Ans. 

    I would rate myself 8 out of 10 in Excel proficiency.

    • Proficient in creating complex formulas and functions

    • Skilled in data analysis and visualization using pivot tables and charts

    • Experience in VLOOKUP, INDEX-MATCH, and conditional formatting

    • Familiar with macros and automation tasks

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Excel test (Vlookup, sumif etc)
  • Q2. How working on dashboard
  • Ans. 

    Working on dashboards involves creating visual representations of data to track key performance indicators.

    • Designing and developing dashboards to display relevant data

    • Using tools like Tableau, Power BI, or Excel to create interactive dashboards

    • Analyzing data trends and patterns to make informed business decisions

    • Customizing dashboards to meet specific business needs

    • Sharing dashboards with stakeholders for better decisi

  • Answered by AI

I applied via Referral and was interviewed before Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Excel piovt tebal

Interview Preparation Tips

Interview preparation tips for other job seekers - Next round very good and very nice

I applied via Recruitment Consultant and was interviewed before Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions about insurance

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good

MDIndia Health Insurance TPA Interview FAQs

How many rounds are there in MDIndia Health Insurance TPA MIS Executive interview?
MDIndia Health Insurance TPA interview process usually has 1-2 rounds. The most common rounds in the MDIndia Health Insurance TPA interview process are One-on-one Round and Technical.
How to prepare for MDIndia Health Insurance TPA 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 MDIndia Health Insurance TPA. The most common topics and skills that interviewers at MDIndia Health Insurance TPA expect are Advanced Excel, MIS Reporting, Communication Skills, HLOOKUP and Pivot Table.
What are the top questions asked in MDIndia Health Insurance TPA MIS Executive interview?

Some of the top questions asked at the MDIndia Health Insurance TPA MIS Executive interview -

  1. Create pivot table base on givn ta...read more
  2. Function in excel like vlook up, left, substitue,count...read more
  3. Some advance excel Fun and macro and VBA ba...read more

Tell us how to improve this page.

MDIndia Health Insurance TPA MIS Executive Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

HDFC Life Interview Questions
3.9
 • 628 Interviews
Gallagher Interview Questions
3.7
 • 223 Interviews
Tata AIG Interview Questions
4.1
 • 159 Interviews
PNB MetLife Interview Questions
3.4
 • 156 Interviews
View all
MDIndia Health Insurance TPA MIS Executive Salary
based on 23 salaries
₹1.1 L/yr - ₹3 L/yr
27% less than the average MIS Executive Salary in India
View more details

MDIndia Health Insurance TPA MIS Executive Reviews and Ratings

based on 5 reviews

4.3/5

Rating in categories

4.6

Skill development

4.3

Work-life balance

2.9

Salary

3.1

Job security

4.0

Company culture

3.2

Promotions

4.5

Work satisfaction

Explore 5 Reviews and Ratings
MIS Executive

New Delhi

1-5 Yrs

Not Disclosed

Explore more jobs
Senior Executive
665 salaries
unlock blur

₹1 L/yr - ₹5.1 L/yr

Executive
210 salaries
unlock blur

₹0.9 L/yr - ₹3.5 L/yr

Back Office Executive
146 salaries
unlock blur

₹0.9 L/yr - ₹3 L/yr

Assistant Manager
136 salaries
unlock blur

₹2.7 L/yr - ₹7 L/yr

Medical Officer
126 salaries
unlock blur

₹1.8 L/yr - ₹6.5 L/yr

Explore more salaries
Compare MDIndia Health Insurance TPA with

HDFC Life

3.9
Compare

ICICI Prudential Life Insurance

4.1
Compare

Axis Max Life Insurance

4.1
Compare

Bajaj Allianz Life Insurance

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