Formulas of advance excel

Question

Accepted Answer

Advance Excel formulas include VLOOKUP, IF, SUMIF, COUNTIF, INDEX, MATCH, CONCATENATE, LEFT, RIGHT, MID, and more.

VLOOKUP - searches for a value in a table and returns a corresponding value in the same row
IF - checks if a condition is true or false and returns a value based on the result
SUMIF - adds the values in a range that meet a specified criteria
COUNTIF - counts the number of cells in a range that meet a specified criteria
INDEX - returns the value of a cell in a specified row and column of a table
MATCH - searches for a value in a table and returns the position of the value
CONCATENATE - combines two or more strings into one
LEFT - returns a specified number of characters from the beginning of a string
RIGHT - returns a specified number of characters from the end of a string
MID - returns a specified number of characters from the middle of a string
And more - there are many other advanced Excel formulas that can be used for various purposes

Popular interview questions of Associate Analytics