Upload Button Icon Add office photos

Filter interviews by

Pernod Ricard MIS Executive Interview Questions and Answers

Updated 24 Aug 2024

Pernod Ricard MIS Executive Interview Experiences

2 interviews found

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 24 Aug 2024

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

I applied via Approached by Company and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Conditional sum or distinct count in pivot
  • Ans. 

    Conditional sum is used to calculate the sum based on certain conditions, while distinct count is used to count unique values in a pivot table.

    • Conditional sum can be achieved using functions like SUMIF or SUMIFS in Excel.

    • Distinct count can be achieved using the COUNTIF function with a unique identifier column.

    • In a pivot table, you can use the Value Field Settings to choose between sum or count, based on your requiremen

  • Answered by AI
  • Q2. Advance Excel formula like lookup formula
Round 2 - HR 

(2 Questions)

  • Q1. Salaray Negosiation process
  • Q2. Responsibilties in prevoius organization
  • Ans. 

    Managed database systems, generated reports, provided technical support, and implemented new technologies.

    • Managed database systems to ensure data integrity and security

    • Generated reports for management to analyze business performance

    • Provided technical support to end users for software and hardware issues

    • Implemented new technologies to improve efficiency and productivity

    • Collaborated with cross-functional teams to integra

  • Answered by AI

MIS Executive Interview Questions & Answers

user image Mousumi Baishya

posted on 7 Jan 2022

I applied via Job Portal and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Excel formulas
  • Q2. Have showing in practical ways.

Interview Preparation Tips

Interview preparation tips for other job seekers - GOOD.Excel knowledge

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

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in May 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

(1 Question)

  • Q1. A bunch questions were given to answer regarding boilers and relevant beer industry
Round 2 - HR 

(1 Question)

  • Q1. Education qualification, family background
Round 3 - Technical 

(1 Question)

  • Q1. Regarding related to industrial experience and little of basic engineering questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Best company
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Could you tell about yourself
  • Q2. How did you hear about this position
  • Q3. What type work environment do you prefer

Interview Preparation Tips

Interview preparation tips for other job seekers - Based on my skills and experience and on the current industry rates , I m looking at a good salary around 5.4 lacs
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2022. 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 - Technical 

(3 Questions)

  • Q1. Do you know about excel formulas
  • Ans. 

    Yes, I am familiar with Excel formulas and have experience using them in various MIS reports.

    • I am proficient in using basic Excel formulas such as SUM, AVERAGE, VLOOKUP, and IF functions

    • I have experience in creating complex formulas for data analysis and reporting purposes

    • I am comfortable working with functions like INDEX, MATCH, and CONCATENATE to manipulate data efficiently

  • Answered by AI
  • Q2. Can you do it now
  • Q3. My answer is yes
Round 3 - Coding Test 

Vlookup and pivot table etc

Interview Preparation Tips

Topics to prepare for Radico Khaitan MIS Executive interview:
  • Advanced Excel
Interview preparation tips for other job seekers - Preparation needs for excel formulas and knowledge of accounting mostly payment raise of all
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - One-on-one 

(5 Questions)

  • Q1. Tell me about yourself
  • Q2. Tell me about your past experience.
  • Q3. Do you know Margin %.
  • Ans. 

    Margin % is the percentage difference between the cost price and the selling price of a product.

    • Margin % is calculated as (Selling Price - Cost Price) / Cost Price * 100

    • It is used to determine the profitability of a product or service

    • Higher margin % indicates better profitability

    • For example, if a product costs $50 and is sold for $70, the margin % would be (70 - 50) / 50 * 100 = 40%

  • Answered by AI
  • Q4. Tell me 10 big store & whole seller.
  • Ans. 

    Some big stores and wholesalers include Walmart, Costco, Amazon, Alibaba, Target, Home Depot, Carrefour, Metro AG, Tesco, and Kroger.

    • Walmart - one of the largest retail corporations in the world

    • Costco - membership-only warehouse club known for bulk sales

    • Amazon - e-commerce giant offering a wide range of products

    • Alibaba - Chinese e-commerce company connecting businesses

    • Target - retail chain offering a variety of product...

  • Answered by AI
  • Q5. Tell me about your family background.

Interview Preparation Tips

Interview preparation tips for other job seekers - F2F
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Mar 2024. There were 5 interview rounds.

Round 1 - Aptitude Test 

The first round interview is typically viewed as an introductory conversation to determine that you have the basic skills and qualifications for the role and can fit in with the team and company culture

Round 2 - HR 

(2 Questions)

  • Q1. Second round interview questions are a deep dive into the topics discussed in the first round. The interviewer will typically focus on job-specific questions that require candidates to respond with detaile...
  • Q2. Passing an HR interview question isn't difficult at all
Round 3 - HR 

(1 Question)

  • Q1. A third-round interview is conducted to further evaluate a candidate's fit for a position and to gather more in-depth information about their skills, experience, and work style
Round 4 - HR 

(1 Question)

  • Q1. The first interview is usually a screening interview with a recruiter, followed by a phone or video interview with the hiring manager. The third interview is often an in-person interview with the team the ...
Round 5 - HR 

(1 Question)

  • Q1. This is an initial screening to ensure that you are the right candidate for the role. The HR interview includes questions such as general information about previous job roles, core skills, qualifications, ...

Interview Preparation Tips

Interview preparation tips for other job seekers - Discuss interests that highlight your strengths
Interview experience
4
Good
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 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 - HR 

(1 Question)

  • Q1. About you self family background.
Round 3 - Technical 

(1 Question)

  • Q1. Line capacity , line type & line diagram process.

Interview Preparation Tips

Interview preparation tips for other job seekers - Tel phone interview or on line apps.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2023. 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 - One-on-one 

(1 Question)

  • Q1. A brief discussion about SCM.
Round 3 - Technical 

(1 Question)

  • Q1. Question was asked relevant to the department.
Round 4 - HR 

(1 Question)

  • Q1. Question about self/salary negotiation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Nov 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Asking about our experience about the JD
Round 3 - HR 

(1 Question)

  • Q1. Regarding Job & benefits

Pernod Ricard Interview FAQs

How many rounds are there in Pernod Ricard MIS Executive interview?
Pernod Ricard interview process usually has 2 rounds. The most common rounds in the Pernod Ricard interview process are Technical and HR.
What are the top questions asked in Pernod Ricard MIS Executive interview?

Some of the top questions asked at the Pernod Ricard MIS Executive interview -

  1. Conditional sum or distinct count in pi...read more
  2. Responsibilties in prevoius organizat...read more
  3. Have showing in practical wa...read more

Tell us how to improve this page.

Pernod Ricard MIS Executive Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Varun Beverages Interview Questions
4.1
 • 218 Interviews
Parle Agro Interview Questions
4.1
 • 99 Interviews
AB InBev India Interview Questions
3.4
 • 99 Interviews
Bisleri Interview Questions
4.2
 • 77 Interviews
Diageo Interview Questions
4.1
 • 64 Interviews
SLMG Beverages Interview Questions
4.0
 • 36 Interviews
Carlsberg Interview Questions
4.1
 • 24 Interviews
View all

Fast track your campus placements

View all
Pernod Ricard MIS Executive Salary
based on 40 salaries
₹3 L/yr - ₹8.5 L/yr
65% more than the average MIS Executive Salary in India
View more details

Pernod Ricard MIS Executive Reviews and Ratings

based on 11 reviews

4.4/5

Rating in categories

3.8

Skill development

3.8

Work-life balance

3.9

Salary

4.5

Job security

4.2

Company culture

4.2

Promotions

4.1

Work satisfaction

Explore 11 Reviews and Ratings
Territory Sales Manager
226 salaries
unlock blur

₹9.8 L/yr - ₹24 L/yr

Sales Executive
201 salaries
unlock blur

₹1.8 L/yr - ₹6.1 L/yr

Assistant Manager
151 salaries
unlock blur

₹8 L/yr - ₹22.4 L/yr

Regional Sales Executive
115 salaries
unlock blur

₹8 L/yr - ₹15 L/yr

Executive Production
104 salaries
unlock blur

₹5 L/yr - ₹11.6 L/yr

Explore more salaries
Compare Pernod Ricard with

Diageo

4.1
Compare

United Spirits

4.0
Compare

Bacardi

3.7
Compare

Suntory Global Spirits

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