Filter interviews by
I applied via Walk-in
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...
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...
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...
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.
Top trending discussions
I applied via Referral and was interviewed in Jul 2023. There were 3 interview rounds.
posted on 13 May 2022
I applied via Campus Placement and was interviewed in Nov 2021. There were 2 interview rounds.
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.
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...
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
I was interviewed in Nov 2024.
I was interviewed in Dec 2024.
About sales related question
posted on 20 Aug 2024
Experienced sales executive with a proven track record of exceeding targets and building strong client relationships.
Over 5 years of sales experience in the technology industry
Consistently met or exceeded sales targets by 20% each quarter
Developed and maintained relationships with key clients such as ABC Company and XYZ Corporation
Strong negotiation and communication skills
Proficient in CRM software such as Salesforce
To expand sales & distribution, focus on market research, building strong relationships with distributors, utilizing technology, and implementing effective marketing strategies.
Conduct thorough market research to identify new opportunities and target markets
Build strong relationships with distributors to ensure effective distribution of products
Utilize technology such as CRM systems and data analytics to streamline sal...
Accounts types refer to the classification of accounts based on their nature and purpose. Accounts definition is the explanation of what an account represents in financial transactions.
Accounts Types: Assets, Liabilities, Equity, Revenue, Expenses
Accounts Definition: An account is a record of financial transactions related to a particular item or category
Examples: Cash (Asset), Accounts Payable (Liability), Retained Ea
I was interviewed in Dec 2024.
Cadbury is a well-known chocolate brand with a wide range of products.
Founded in 1824 by John Cadbury in Birmingham, England
Known for its Dairy Milk chocolate bar
Offers a variety of flavors and products such as Cadbury Creme Egg and Cadbury Roses
Part of Mondelez International since 2010
Sales executive
I am applying for the position of Sales Executive within the company.
I have experience in sales and a proven track record of meeting and exceeding targets.
I am confident in my ability to drive revenue and build strong relationships with clients.
I am excited about the opportunity to contribute to the company's growth and success.
posted on 6 Feb 2024
It's easy with some reasoning and personality test,gets 1 hours to solve.
Any recent topic or current affairs
Sales in the diary industry involve selling dairy products such as milk, cheese, yogurt, and butter.
Sales executives in the diary industry focus on building relationships with retailers, wholesalers, and distributors to promote and sell dairy products.
They develop sales strategies to increase market share and meet sales targets.
They conduct market research to identify potential customers and understand consumer prefere...
UFMCG stands for Ultra Fast Moving Consumer Goods. Shelf life refers to the length of time a product can be stored before it becomes unfit for use or consumption.
UFMCG refers to products that have a high turnover rate and are quickly consumed by customers.
These products are typically non-durable goods like food, beverages, toiletries, and cleaning products.
Shelf life is the period during which a product remains safe to...
I applied via Walk-in and was interviewed in Jul 2023. There were 3 interview rounds.
Grt and little gard
The HR process involves recruitment, onboarding, training, performance management, and employee relations.
Recruitment: Attracting, sourcing, and selecting candidates for job openings.
Onboarding: Introducing new employees to the organization and their roles.
Training: Providing employees with necessary skills and knowledge for their job.
Performance Management: Evaluating and rewarding employee performance.
Employee Relati...
Interview experience
based on 1 review
Rating in categories
Assistant Manager
40
salaries
| ₹4 L/yr - ₹10.2 L/yr |
Executive Accountant
36
salaries
| ₹1.8 L/yr - ₹5.5 L/yr |
Senior Executive
23
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Branch Manager
20
salaries
| ₹3.5 L/yr - ₹6.4 L/yr |
Area Sales Manager
19
salaries
| ₹4.1 L/yr - ₹12.5 L/yr |
Adani Group
Reliance Industries
Tata Group
Bharti Enterprises