Filter interviews by
posted on 27 Jul 2024
I applied via Job Portal and was interviewed before Jul 2023. There was 1 interview round.
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) will search for the value in cell A2 in the rang...
Pivot tables are used in Excel to summarize and analyze data, allowing users to reorganize and display information in a more meaningful way.
Pivot tables help in summarizing large amounts of data quickly and efficiently.
They allow users to easily rearrange and filter data to analyze trends and patterns.
Users can create custom calculations and group data based on specific criteria.
Pivot tables are commonly used in busine...
Executive Accountant
11
salaries
| ₹1 L/yr - ₹3 L/yr |
HR Executive
5
salaries
| ₹2.2 L/yr - ₹3.9 L/yr |
HR Manager
4
salaries
| ₹4.8 L/yr - ₹6.6 L/yr |
Accounts Manager
4
salaries
| ₹3.2 L/yr - ₹3.6 L/yr |
MIS Executive
4
salaries
| ₹2.5 L/yr - ₹3 L/yr |
Security and Intelligence Services (India)
G4S
Tops Security
Premier Shield