Bisleri MIS Executive Interview Questions and Answers

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. Basic Excel formula
Add your answer
Q2. Advance Excel formula
Ans. 
Advanced Excel formulas enhance data analysis and manipulation, enabling complex calculations and efficient data management.
• VLOOKUP: This function searches for a value in the first column of a range and returns a value in the same row from a specified column. Example: =VLOOKUP(A2, B2:D10, 3, FALSE)

• INDEX-MATCH: A powerful combination that allows for more flexible lookups than VLOOKUP. Example: =INDEX(C2:C10, MATCH(A2, B...read more
Answered by AI
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...read more
Answered by AI
Add your answer
Q2. Advance Excel formula like lookup formula
Add your answer

Q1. Salaray Negosiation process
Ans. 
Salary negotiation involves discussing compensation to reach a mutually beneficial agreement between employer and employee.
• Research industry standards: Know the average salary for your role in your location.

• Assess your value: Highlight your skills and experiences that justify your salary request.

• Practice your pitch: Rehearse how you will present your case for a higher salary.

• Be flexible: Consider other benefits like bo...read more
Answered by AI
Add your answer
Q2. Responsibilties in prevoius organization
Add your answer

Q1. Ask personal details
Add your answer
Q2. Ask reference person
Add your answer

Q1. Formal Introduction
Add your answer
Q2. Work Experience
Add your answer

Q1. SAP & Excel Useages
Add your answer
Q2. Warehouse Opperation
Add your answer

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