Excel Functions Quiz

What does the AVERAGE() function do in Excel?

• Joins two or more strings

• Finds the largest value

• Counts the number of cells

• Calculates the arithmetic mean

Which function would you use to count only the empty cells in a range?

• Countif()

• Counta()

• Count()

• Countblank()

What is the purpose of the VLOOKUP function in Excel?

• To find the position of a text string

• To calculate the smallest value in a set

• To add values based on a condition

• To fetch a value from a specified column based on a match

Which function would you use to join two or more text strings?

• Find

• Max()

• Concatenate

• Sumif()

What does the COUNTIF function do?

• Counts all cells with numbers

• Counts how many times a specific text appears

• Calculates the average of a range

• Finds the largest value in a set

Which function returns TRUE or FALSE in Excel?

• Logical function

• Count()

• Average()

• Sumif()