Filter interviews by
I applied via AmbitionBox and was interviewed in Nov 2024. There was 1 interview round.
Top trending discussions
I applied via Referral and was interviewed before May 2022. There were 3 interview rounds.
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Used in Excel to search for a value in the first column of a table and return a value in the same row from another 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 first column of the ra...
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.
Used in Excel to search for a value in the top row of a table
Returns a value in the same column from a specified row
Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP(123, A1:D4, 3, FALSE) - searches for 123 in the top row of the table A1
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
I have over 5 years of experience as an MIS Executive, handling data analysis, reporting, and system management.
Managed databases and generated reports for senior management
Developed automated tools for data analysis, improving efficiency by 20%
Implemented new software systems to streamline processes
Trained staff on data management best practices
The number of errors in Excel depends on various factors such as the complexity of the spreadsheet, user input, and formula errors.
Errors in Excel can occur due to incorrect formulas, missing data, or formatting issues.
Common errors include #VALUE!, #DIV/0!, #REF!, and #NAME?.
Errors can be identified by error codes displayed in cells or through error checking tools.
The number of errors can vary greatly depending on the...
I applied via Newspaper Ad and was interviewed before Nov 2022. There were 3 interview rounds.
Good and easy simple questions
I applied via Referral and was interviewed before May 2022. There were 3 interview rounds.
Interview experience
based on 3 reviews
Rating in categories
Senior Executive
846
salaries
| ₹1.1 L/yr - ₹5 L/yr |
Sales Executive
387
salaries
| ₹1.2 L/yr - ₹4 L/yr |
Senior Associate
338
salaries
| ₹1 L/yr - ₹3.2 L/yr |
Team Lead
307
salaries
| ₹1.1 L/yr - ₹4.2 L/yr |
CPA Manager
303
salaries
| ₹1.2 L/yr - ₹3.1 L/yr |
Wipro
Infosys
TCS
HCLTech