Tell me any 10 excel functions

Question

Accepted Answer

Some common Excel functions include SUM, VLOOKUP, IF, CONCATENATE, AVERAGE, COUNT, MAX, MIN, INDEX, and MATCH.

SUM: Adds up all the numbers in a range of cells
VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from another column
IF: Performs a logical test and returns one value if the test is true and another if it's false
CONCATENATE: Joins two or more text strings into one string
AVERAGE: Calculates the average of a group of numbers
COUNT: Counts the number of cells in a range that contain numbers
MAX: Returns the largest number in a set of values
MIN: Returns the smallest number in a set of values
INDEX: Returns the value of a cell in a table based on the row and column number
MATCH: Searches for a specified value in a range and returns the relative position of that item

Top Bharti Airtel Fpa Financial Analyst interview questions & answers