Faster and better experience!
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
I applied via Recruitment Consultant and was interviewed in Apr 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed before Sep 2020. There was 1 interview round.
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 am passionate about helping people protect their assets and loved ones through insurance.
I have a strong desire to help individuals and families plan for the unexpected.
I believe in the importance of financial security and peace of mind that insurance provides.
I am interested in the dynamic and evolving nature of the insurance industry.
I enjoy analyzing risks and finding solutions to mitigate them.
I have a background...
I applied via Approached by Company and was interviewed before Jul 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed before Mar 2023. There was 1 interview round.
LAN stands for Local Area Network. A firewall is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules.
LAN is a network of interconnected devices within a limited area, such as a home, office, or campus.
Firewall works by examining data packets and determining whether they should be allowed through based on predefined security rules.
Firewalls can...
Questions on investments
Company valuation to submit
I applied via Referral and was interviewed in Mar 2023. There was 1 interview round.
Some of the top questions asked at the Vidal Health Tpa MIS Executive interview -
based on 1 interview
Interview experience
based on 6 reviews
Rating in categories
Medical Officer
243
salaries
| ₹0 L/yr - ₹0 L/yr |
Claims Executive
83
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive
77
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
33
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
33
salaries
| ₹0 L/yr - ₹0 L/yr |
Medi Assist India
Paramount Health Services Tpa
GENINS INDIA TPA
Medsave Healthcare TPA