AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
ITC Limited Foods Division MIS Executive Interview Questions and Answers
ITC Limited Foods Division MIS Executive Interview Experiences
1 interview found
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
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. Explain your academic level project.
Selected
I applied via Company Website and was interviewed in Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Technical details related to Instrumentation, Electrical , plc, vfd
(1 Question)
- Q1. Discussed regarding company and salary
Interview Preparation Tips
Saif Khan
(1 Question)
- Q1. Tell me about your experience
(1 Question)
- Q1. Expected salary, what is ur previous salary
Interview Preparation Tips
I appeared for an interview in Jul 2023.
(2 Questions)
- Q1. Why are you interested in this role
- Q2. Why do you want to work for Hershey
Interview Preparation Tips
I appeared for an interview in Aug 2023.
(1 Question)
- Q1. Why do you want to work here
Interview Preparation Tips
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
angeline hepziba
I applied via Newspaper Ad and was interviewed in Jul 2024. There was 1 interview round.
Cognitive test for the associate
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
ITC Limited Foods Division Interview FAQs
Tell us how to improve this page.
ITC Limited Foods Division Interviews By Designations
- ITC Limited Foods Division Manufacturing Executive Interview Questions
- ITC Limited Foods Division Finance Executive Interview Questions
- ITC Limited Foods Division Internship Trainee Interview Questions
- ITC Limited Foods Division Area Executive Interview Questions
- ITC Limited Foods Division Area Sales Executive Interview Questions
- ITC Limited Foods Division Sales Trainee Interview Questions
- ITC Limited Foods Division Cost Accountant Interview Questions
- ITC Limited Foods Division Sales Executive Interview Questions
- Show more
Interview Questions from Similar Companies
|
Manufacturing Executive
89
salaries
|  ₹3 L/yr - ₹11 L/yr |
|
Operator
61
salaries
| ₹1.2 L/yr - ₹3.5 L/yr |
|
Technical Associate
57
salaries
| ₹4.7 L/yr - ₹7 L/yr |
|
Packaging Machine Operator
50
salaries
| ₹1.2 L/yr - ₹3 L/yr |
|
Finance Executive
49
salaries
| ₹5.2 L/yr - ₹10.8 L/yr |
PepsiCo
Cargill
Mondelez International
Perfetti Van Melle
- Home >
- Interviews >
- ITC Limited Foods Division Interview Questions >
- ITC Limited Foods Division MIS Executive Interview Questions
