Google Sheets Quiz 30/09/2024

What does the COUNTIF function do in Google Sheets?

• Counts cells in a range that meet a specific condition

• Counts all the cells in a range

• Adds values in a range

• Averages values in a range

Which function would you use to find the average of numbers in a range?

• COUNT

• AVERAGE

• SUM

• MAX

Which function counts only the cells that are not empty?

• COUNTIF

• COUNTA

• COUNTBLANK

• AND

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

• COUNT

• COUNTBLANK

• COUNTA

• AVERAGE

What does the AND function return?

• TRUE if all conditions are met

• A sum of all values

• The first condition that is true

• The maximum value in a range

What is the difference between AVERAGEIF and AVERAGE?

• AVERAGEIF averages only cells that meet a condition

• They both work the same

• AVERAGE works with conditions

• AVERAGEIF counts values instead of averaging them

Which function counts the number of cells in a range based on a condition?

• COUNT

• COUNTIF

• COUNTA

• COUNTBLANK

What does the AVERAGEIFS function do?

• Averages all numbers in a range

• Averages numbers in a range that meet multiple conditions

• Adds all numbers in a range

• Finds the maximum of numbers in a range

How would you count the number of blank cells in a range?

• COUNTIF

• COUNTBLANK

• AVERAGEIF

• COUNTA

What does the COUNTA function do?

• Counts the number of blank cells

• Counts the number of non-empty cells

• Counts the total number of cells

• Counts cells that meet a specific condition