Filter interviews by
Two aptittude test, grammer and writing
Vlookup and hlookup are Excel functions used to search for specific data in a table.
Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column.
Hlookup searches for a value in the first row of a table and returns a value in the same column from a specified row.
Both functions are commonly used in data analysis and reporting.
Example: =VLOOKUP(A2, B2:D10, 3, FALS...
I applied via Approached by Company and was interviewed before Feb 2021. There were 3 interview rounds.
I applied via Referral and was interviewed before Nov 2020. There were 5 interview rounds.
I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.
Prepare questions from all basic topics
I applied via Recruitment Consultant and was interviewed before Dec 2020. There were 5 interview rounds.
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Yes, I know Excel. I am proficient in using formulas, pivot tables, charts, and macros.
Proficient in using formulas such as VLOOKUP, IF, SUMIF, COUNTIF, etc.
Expertise in creating pivot tables and charts for data analysis and visualization.
Experience in automating tasks using macros and VBA programming.
Familiarity with advanced Excel functions like INDEX-MATCH, array formulas, and conditional formatting.
Ability to handl...
I applied via Naukri.com and was interviewed in Jan 2021. There were 5 interview rounds.
I applied via LinkedIn and was interviewed in May 2021. There was 1 interview round.
posted on 29 Jan 2021
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Consultant
7.8k
salaries
| ₹6.6 L/yr - ₹27 L/yr |
Assistant Manager
7.1k
salaries
| ₹10.3 L/yr - ₹32 L/yr |
Associate Consultant
4.7k
salaries
| ₹4.5 L/yr - ₹16 L/yr |
Analyst
3.6k
salaries
| ₹1 L/yr - ₹8 L/yr |
Manager
2.9k
salaries
| ₹15.5 L/yr - ₹46 L/yr |
Cognizant
PwC
Capgemini