United Spirits Office Clerk Interview Questions and Answers

Q1. What are yours experience in parnod Ricard
Add your answer

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
Add your answer
Q2. Advance Excel formula like lookup formula
Add your answer

Q1. Salaray Negosiation process
Add your answer
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
Add your answer

Q1. How can you increase OEE ?
Ans. 
To increase OEE, focus on reducing downtime, improving quality, and increasing speed.
• Identify and address the root causes of downtime

• Implement preventive maintenance programs

• Train employees to operate equipment efficiently

• Improve quality control processes

• Optimize production scheduling

• Invest in new technology or equipment

• Streamline processes to reduce waste and increase speed
Answered by AI
Add your answer
Q2. What do you understand by SMED?
Ans. 
SMED stands for Single Minute Exchange of Die, a lean manufacturing technique to reduce setup time.
• SMED aims to reduce the time it takes to switch a production line from making one product to another

• It involves breaking down the setup process into small steps and finding ways to streamline each step

• The goal is to reduce setup time to less than 10 minutes, hence the name Single Minute Exchange of Die

• Examples of SMED in ...read more
Answered by AI
Add your answer

Q1. Background Info, your knowledge of scope of work involved,
Add your answer

Q1. Resume based questionnaires and Idea of market
Add your answer

Q1. Tell me something about yourself
Add your answer

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
View 1 more answer
Q2. Can you do it now
Add your answer
Q3. My answer is yes
Add your answer

Vlookup and pivot table etc

Q1. A brief discussion about SCM.
Add your answer

Q1. Question was asked relevant to the department.
Add your answer

Q1. Question about self/salary negotiation
Add your answer