Filter interviews by
I applied via Referral and was interviewed before Aug 2020. There were 4 interview rounds.
Conditional formatting in Advanced Excel allows users to apply formatting based on specified conditions.
Conditional formatting is a feature in Excel that allows users to format cells based on certain conditions.
It helps in highlighting data that meets specific criteria or rules.
Users can choose from various formatting options like font color, cell color, data bars, icon sets, etc.
Conditions can be based on values, form...
Yes, VLOOKUP is a formula used in Excel to search for a specific value in a column and return a corresponding value from another column.
VLOOKUP stands for vertical lookup.
It is commonly used to find data in large spreadsheets.
The formula has four arguments: lookup value, table array, column index number, and range lookup.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 an...
Text formulas in Excel are used to manipulate and combine text strings. They work by using specific functions and operators.
Text formulas are used to perform operations on text strings in Excel.
They can be used to concatenate, extract, replace, and manipulate text.
Text formulas are created using functions and operators.
Examples of text formulas include CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE, and LEN.
Text formulas ca...
MATCH and INDEX are Excel functions used for different purposes.
MATCH function is used to find the position of a value in a range or array.
INDEX function is used to retrieve the value at a specific row and column intersection in a range or array.
MATCH function returns the relative position of a value, while INDEX function returns the actual value.
MATCH function can be used for approximate or exact matches, while INDEX ...
To create a pivot table in Excel, go to the 'Insert' tab, click on 'PivotTable', select the data range, choose the location, and set the fields.
Go to the 'Insert' tab in Excel
Click on 'PivotTable'
Select the data range you want to use for the pivot table
Choose the location where you want the pivot table to be placed
Set the fields for the pivot table by dragging and dropping them into the 'Rows', 'Columns', and 'Values' ...
There are multiple types of data extraction methods and various ways to export the data.
Types of data extraction methods include web scraping, database querying, API integration, and ETL processes.
Data can be exported in various formats such as CSV, Excel, JSON, XML, or directly into databases.
Exporting data can be done through software tools, programming languages, or using built-in export functionalities of applicati...
To get raw data or work on your organization, you can utilize various methods such as accessing databases, using APIs, conducting surveys, or analyzing existing reports.
Access databases to extract raw data
Utilize APIs to retrieve data from external sources
Conduct surveys to collect relevant information
Analyze existing reports or documents within the organization
Use data mining techniques to extract valuable insights
Top trending discussions
posted on 20 Mar 2024
posted on 10 Nov 2022
I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 3 interview rounds.
Advance excel test like sumif countif vlookup pivote
I applied via Naukri.com and was interviewed before Sep 2020. There was 1 interview round.
It was basic test topics which were asked was PNC, Graphs, Basic age and algebra, TBH everybody has different set of questions
posted on 15 Jun 2024
posted on 24 Jan 2024
I applied via Walk-in and was interviewed in Dec 2023. There were 2 interview rounds.
The daily work process of an HR Executive involves various tasks and responsibilities.
Recruiting and hiring new employees
Managing employee onboarding and orientation
Handling employee relations and resolving conflicts
Administering employee benefits and compensation
Developing and implementing HR policies and procedures
Maintaining employee records and HR databases
Conducting performance evaluations and providing feedback
En...
Knowledge wants to know about work
I applied via Referral and was interviewed in Apr 2024. There was 1 interview round.
I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.
My family background is diverse and has shaped me into a well-rounded individual.
My parents come from different cultural backgrounds, which exposed me to different traditions and perspectives.
I have siblings who have pursued various career paths, inspiring me to explore different fields.
My extended family is spread across different countries, allowing me to experience different cultures firsthand.
My family values educa...
Interview experience
based on 6 reviews
Rating in categories
Medical Officer
233
salaries
| ₹2 L/yr - ₹6.3 L/yr |
Claims Executive
83
salaries
| ₹1.4 L/yr - ₹3.7 L/yr |
Executive
78
salaries
| ₹1.5 L/yr - ₹4 L/yr |
Team Lead
41
salaries
| ₹3 L/yr - ₹6 L/yr |
Assistant Manager
33
salaries
| ₹4.2 L/yr - ₹8.9 L/yr |
Medi Assist India
Paramount Health Services Tpa
GENINS INDIA TPA
Medsave Healthcare TPA