AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Pernod Ricard MIS Executive Interview Questions and Answers
Pernod Ricard MIS Executive Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed in Jul 2024. There were 2 interview rounds.
(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
- Q2. Advance Excel formula like lookup formula
(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
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
Top trending discussions
Interview questions from similar companies
Ishaq Bari U S
(1 Question)
- Q1. Excel Technical tests
Tejaswini Gowda
Selected
I applied via Job Fair and was interviewed in May 2022. There were 3 interview rounds.
(1 Question)
- Q1. A bunch questions were given to answer regarding boilers and relevant beer industry
(1 Question)
- Q1. Education qualification, family background
(1 Question)
- Q1. Regarding related to industrial experience and little of basic engineering questions
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed before Jan 2023. There was 1 interview round.
(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
Umesh Agnihotri
Selected
I applied via Referral and was interviewed before Oct 2022. There were 3 interview rounds.
(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
- Q2. Can you do it now
- Q3. My answer is yes
Vlookup and pivot table etc
Interview Preparation Tips
- Advanced Excel
Selected
I applied via Walk-in and was interviewed in Mar 2024. There were 5 interview rounds.
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
(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
(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
(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 ...
(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
Selected
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. About you self family background.
(1 Question)
- Q1. Line capacity , line type & line diagram process.
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.
(1 Question)
- Q1. A brief discussion about SCM.
(1 Question)
- Q1. Question was asked relevant to the department.
(1 Question)
- Q1. Question about self/salary negotiation
Selected
I applied via Company Website and was interviewed in Nov 2022. There were 3 interview rounds.
(1 Question)
- Q1. Asking about our experience about the JD
(1 Question)
- Q1. Regarding Job & benefits
Pernod Ricard Interview FAQs
Tell us how to improve this page.
Pernod Ricard Interviews By Designations
- Pernod Ricard Blending Executive Interview Questions
- Pernod Ricard Executive Production Interview Questions
- Pernod Ricard Sales Manager Interview Questions
- Pernod Ricard MIS Executive Interview Questions
- Pernod Ricard Regional Sales Executive Interview Questions
- Pernod Ricard Assistant Environment Health and Safety Manager Interview Questions
- Pernod Ricard Assistant Manager Maintenance Interview Questions
- Pernod Ricard Assistant Manager Operations Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior MIS Executive Interview Questions
- MIS Executive and Analyst Interview Questions
- MIS Executive and Coordinator Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- MIS and Back Office Executive Interview Questions
- Executive Accountant Interview Questions
- Show more
Pernod Ricard MIS Executive Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Pernod Ricard MIS Executive Reviews and Ratings
based on 10 reviews
Rating in categories
|
Sales Executive
225
salaries
|  ₹1.9 L/yr - ₹6.1 L/yr |
|
Territory Sales Manager
223
salaries
| ₹9 L/yr - ₹24 L/yr |
|
Assistant Manager
154
salaries
| ₹8 L/yr - ₹22.4 L/yr |
|
Regional Sales Executive
116
salaries
| ₹8 L/yr - ₹15 L/yr |
|
Executive Production
101
salaries
| ₹5 L/yr - ₹11.6 L/yr |
Diageo
United Spirits
Bacardi
Suntory Global Spirits
- Home >
- Interviews >
- Pernod Ricard Interview Questions >
- Pernod Ricard MIS Executive Interview Questions
