Excel Functions Quiz

What does the SUMIF function do?

• Adds values that meet a specific condition

• Calculates the average of values that meet a specific condition

• Counts the number of cells that meet a specific condition

What is the syntax for the AVERAGEIF function?

• AVERAGEIF(range, criteria, [average_range])

• AVERAGEIF(range, criteria)

• AVERAGEIF(criteria, range)

What does the COUNTIF function do?

• Counts the number of cells that meet a specific condition

• Adds values that meet a specific condition

• Calculates the average of values that meet a specific condition

How does the AND function work?

• Returns TRUE if all conditions are met

• Returns TRUE if at least one condition is met

• Returns FALSE if all conditions are met

How does the OR function work?

• Returns TRUE if at least one condition is met

• Returns TRUE if all conditions are met

• Returns FALSE if at least one condition is met

What does the NOT function do?

• Reverses a condition’s logical value

• Checks if a condition is TRUE

• Checks if a condition is FALSE

What is the purpose of the AVERAGEIF function?

• Calculates the average of cells that meet a specific condition

• Counts the number of cells that meet a specific condition

• Adds values that meet a specific condition