Excel Functions Quiz

Which function adds up a range of values?

• AVERAGE

• COUNT

• SUM

• MAX

What does the AVERAGE function do?

• Counts the number of cells in a range

• Calculates the average of a range of values

• Returns the largest value in a range

• Joins multiple text strings into one

Which function returns the largest value in a range?

• MIN

• MAX

• INDEX

• COUNTIF

What is the purpose of the IF function?

• Searches for a value in the first column of a table

• Joins multiple text strings into one

• Checks if a condition is met and returns one value if true, and another value if false

• Returns the value of a cell in a specified row and column of a range

Which function searches for a value in the first column of a table and returns a corresponding value from another column?

• VLOOKUP

• CONCATENATE

• INDEX

• COUNTIF

What does the CONCATENATE function do?

• Returns the smallest value in a range

• Joins multiple text strings into one

• Counts the number of cells in a range that meet a specific criterion

• Adds up a range of values

Which function returns the value of a cell in a specified row and column of a range?

• COUNT

• INDEX

• SUM

• AVERAGE

What is the purpose of the COUNTIF function?

• Returns the largest value in a range

• Counts the number of cells in a range that meet a specific criterion

• Searches for a value in the first column of a table

• Joins multiple text strings into one