Usecase of if, vlookup, sumif, excercise for data cleaning and proper function

Question

Accepted Answer

These functions are commonly used in Excel for data cleaning and analysis.

IF function is used for logical tests and returns one value if the condition is met, and another value if it is not.
VLOOKUP function is used to search for a value in the first column of a range and return a value in the same row from another column.
SUMIF function adds the cells specified by a given condition or criteria.
Example: IF function can be used to categorize data based on a certain condition, VLOOKUP can be used to retrieve information from a lookup table, and SUMIF can be used to calculate total sales for a specific product.

Popular interview questions of Data Specialist