AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
IB Group MIS Executive Interview Questions, Process, and Tips for Experienced
IB Group MIS Executive Interview Experiences for Experienced
1 interview found
I applied via Walk-in
(4 Questions)
- Q1. What is v lookup??
- Ans.
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
VLOOKUP stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
- Q2. What is h lookup?
- Ans.
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
HLOOKUP stands for Horizontal Lookup.
It is used to search for a value in the top row of a table and return a value in the same column from a specified row.
Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP(100, A1:D4, 3, FALSE) - searches...
- Q3. How to use all formula??
- Ans.
To use all formulas in Excel, enter the formula in a cell, use appropriate syntax, and reference cells correctly.
Enter the formula in a cell by starting with an equal sign (=)
Use appropriate syntax for the formula (e.g. SUM(A1:A10) for summing a range of cells)
Reference cells correctly by selecting them or typing their cell references (e.g. A1)
Use functions like SUM, AVERAGE, IF, VLOOKUP, etc. to perform calculations o...
- Q4. SAP Movment type??
- Ans.
SAP Movement type is a three-digit key that specifies the type of goods movement in SAP system.
Used to differentiate between various goods movements in SAP
Helps in determining the type of transaction being performed
Examples: 101 for goods receipt, 261 for goods issue, etc.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Associate Interview Questions & Answers
Mother Dairy Fruit & Vegetable
Anonymous
posted on 20 Dec 2022
Selected
I applied via Company Website and was interviewed before Dec 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Do you know about Sap & excel?
- Ans.
Yes, I am familiar with both SAP and Excel.
I have experience using SAP for inventory management and financial reporting.
I am proficient in Excel for data analysis and reporting.
I have used Excel to create pivot tables, charts, and graphs for presentations.
I have also used SAP and Excel together to extract and analyze data for business insights.
- Q2. Which do you know module of Sap?
- Ans.
I have knowledge of multiple modules in SAP including MM, SD, FI, and CO.
I have experience in Material Management (MM) module which deals with procurement and inventory management.
I also have knowledge of Sales and Distribution (SD) module which deals with sales and order processing.
I am familiar with Financial Accounting (FI) and Controlling (CO) modules which deal with financial management and reporting.
I have worked...
Interview Preparation Tips
Ans- Yes I am Kown Sap & excel.
I applied via Campus Placement and was interviewed in Nov 2021. There were 2 interview rounds.
(3 Questions)
- Q1. Do you know MS Excel and PowerPoint?
- Ans.
Yes, I am proficient in both MS Excel and PowerPoint.
I have experience in creating spreadsheets, using formulas and functions, and analyzing data in Excel.
I am skilled in creating professional presentations with animations, graphics, and multimedia in PowerPoint.
I have used both programs extensively in my previous roles and am comfortable with their features and functionalities.
- Q2. Do you know V Lookup & H Lookup?
- Ans.
Yes, V Lookup & H Lookup are Excel functions used to search for specific data in a table.
V Lookup searches for a specific value in the first column of a table and returns a corresponding value in the same row from a specified column.
H Lookup searches for a specific value in the first row of a table and returns a corresponding value in the same column from a specified row.
Both functions are commonly used in data analysi...
- Q3. Do you know Pivot Table?
- Ans.
Yes, Pivot Table is a powerful data analysis tool used to summarize and manipulate large datasets.
Pivot Table is used to summarize and analyze large datasets
It allows users to group, filter, and sort data based on various criteria
Pivot Table can be used to create charts and graphs to visualize data
It is commonly used in Excel and other spreadsheet programs
Interview Preparation Tips
- Excel
2nd - Pivot & Lookup function is very useful & Important....
Best 😊👍of Luck!
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed in Jul 2023. There were 3 interview rounds.
(4 Questions)
- Q1. Question related to problem solving in Excel
- Q2. Basic Excel formulas
- Q3. Vlookup, Pivot, Sumif, countif, concatenate, filter
- Q4. If Condition formula
(1 Question)
- Q1. Previous job profile, why to switch the previous job
Interview Preparation Tips
- Advanced Excel
Saif Khan
(1 Question)
- Q1. Tell me about your experience
(1 Question)
- Q1. Expected salary, what is ur previous salary
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Explain your academic level project.
I applied via Naukri.com and was interviewed in Jul 2021. There were 2 interview rounds.
(2 Questions)
- Q1. About our self then previous experience
- Q2. Skill test and personal information
Interview Preparation Tips
Selected
Case study - marketing
(2 Questions)
- Q1. About the case study
- Q2. Nielsen fundamentals
I applied via Campus Placement
(1 Question)
- Q1. Tableau related questions for Business Intelligence role
(1 Question)
- Q1. Situation based questions -STAR model
(1 Question)
- Q1. Salary negotiation
I applied via Naukri.com and was interviewed before May 2022. There were 2 interview rounds.
(2 Questions)
- Q1. About my work experience
- Q2. About workday HCM
IB Group Interview FAQs
Tell us how to improve this page.
IB Group Interviews By Designations
- IB Group Assistant Manager Interview Questions
- IB Group MIS Executive Interview Questions
- IB Group HR Executive Interview Questions
- IB Group Accountant Interview Questions
- IB Group Business Manager Interview Questions
- IB Group Branch Manager Interview Questions
- IB Group Regional Operations Manager Interview Questions
- IB Group Store Manager 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
- MIS and Back Office Executive Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- Accounts and MIS Executive Interview Questions
- Show more
IB Group MIS Executive Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
IB Group MIS Executive Reviews and Ratings
based on 1 review
Rating in categories
|
Assistant Manager
44
salaries
|  ₹4 L/yr - ₹10.2 L/yr |
|
Executive Accountant
33
salaries
| ₹1.8 L/yr - ₹5.5 L/yr |
|
Senior Executive
27
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
|
Branch Manager
19
salaries
| ₹3.9 L/yr - ₹6.4 L/yr |
|
Area Sales Manager
19
salaries
| ₹5.4 L/yr - ₹10.5 L/yr |
PepsiCo
Cargill
Mother Dairy Fruit & Vegetable
General Mills
- Home >
- Interviews >
- IB Group Interview Questions >
- IB Group MIS Executive Interview Questions for Experienced
