Filter interviews by
I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.
Yes, VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
VLOOKUP stands for 'Vertical Lookup'
It is used to search for a value in the first 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) - searches for the value in cell A2 in the ...
Here you are given one and asked to perform some formulas and functions to fetch insights .
Top trending discussions
posted on 24 Apr 2024
I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.
30 minutes for the test
I applied via Walk-in and was interviewed in May 2022. There was 1 interview round.
VLOOKUP, HLOOKUP, SUMIFS, COUNTIFS, AVERAGEIFS, SUBTOTAL, IF, AND, OR, and Conditional Formatting are Excel functions used for data analysis and manipulation.
VLOOKUP is used to search for a value in a table and return a corresponding value in the same row.
HLOOKUP is similar to VLOOKUP, but searches for a value in a table and returns a corresponding value in the same column.
SUMIFS is used to sum values in a range that m...
Use your knowledge.
I applied via Walk-in and was interviewed before Dec 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.
Yes, I am confident in handling data of more than 1000 employees.
I have experience using HRIS systems to manage employee data.
I am comfortable with Excel and other data analysis tools.
I am organized and detail-oriented, which helps me manage large amounts of data.
I am willing to learn and adapt to new systems and processes.
In my previous role, I managed data for a team of 500 employees and was able to handle it efficie
Yes, as an HR Coordinator, I ensure that labours receive their payments on time.
As an HR Coordinator, it is my responsibility to manage the payroll process and ensure that labours are paid accurately and on time.
I work closely with the finance department to ensure that all necessary documentation and approvals are in place for timely payment processing.
I maintain a payroll schedule and ensure that labours' hours and wa...
posted on 18 Sep 2021
I applied via Walk-in and was interviewed in Mar 2021. There were 3 interview rounds.
I applied via Naukri.com
Interview experience
Sales Executive
109
salaries
| ₹1.5 L/yr - ₹5.5 L/yr |
Team Lead
78
salaries
| ₹1.9 L/yr - ₹6 L/yr |
Territory Sales Manager
49
salaries
| ₹3.1 L/yr - ₹6 L/yr |
Sales Team Leader
43
salaries
| ₹2.5 L/yr - ₹6 L/yr |
Executive Accountant
41
salaries
| ₹1.7 L/yr - ₹4.1 L/yr |
Bharat Electronics
Havells
Crompton Greaves Consumer Electricals
Voltas