i
Sona Comstar
Filter interviews by
Simple and easy questions for me
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) will searc...
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.
The function requires four arguments: the value to search for, the range of cells to search in, the column index number...
An interview with advanced Excel question
Top trending discussions
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
posted on 19 Jan 2018
I applied via Referral and was interviewed in Oct 2018. There were 5 interview rounds.
I am drawn to your organisation's commitment to innovation and employee development. I expect opportunities for growth and a supportive work culture.
I am impressed by the company's track record of innovation and success in the industry.
I value the emphasis on employee development and growth opportunities within the organisation.
I am looking for a supportive work culture that values teamwork and collaboration.
I expect c...
I applied via Approached by Company and was interviewed before Mar 2022. There were 2 interview rounds.
I applied via Recruitment Consultant and was interviewed before Dec 2020. There was 1 interview round.
I faced a defect in plastic commodity related to poor quality control during the manufacturing process.
The defect was in the form of cracks and breakages in the plastic products.
It was caused by inadequate monitoring and supervision during the molding and cooling stages.
The defect resulted in a high number of rejected products and customer complaints.
To address the issue, we implemented stricter quality control measure...
I applied via Company Website and was interviewed in Aug 2021. There was 1 interview round.
I applied via Walk-in and was interviewed before Mar 2021. There were 2 interview rounds.
TELL ME ABOUT YOUR SELF
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Engineer
161
salaries
| ₹4.4 L/yr - ₹14.5 L/yr |
Engineer
148
salaries
| ₹2.5 L/yr - ₹7.8 L/yr |
Junior Engineer
147
salaries
| ₹1.5 L/yr - ₹5 L/yr |
Assistant Manager
118
salaries
| ₹7.5 L/yr - ₹16.6 L/yr |
Quality Engineer
109
salaries
| ₹1.2 L/yr - ₹6 L/yr |
Ceat Tyres
UNO Minda
Apollo Tyres
Exide Industries