NEW
Font size
WorksheetsGoogle Sheets Quiz 30/09/2024
Total questions: 20
Worksheet time: 20mins
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
Which function would you use to apply multiple criteria when counting cells?
AVERAGE
COUNTIF
COUNTIFS
COUNTA
How does the AND function behave in Google Sheets?
Returns TRUE if any one of the conditions is true
Returns TRUE if all conditions are true
Returns the sum of all values
Returns FALSE if any condition is false
Which function can be used to average cells based on multiple conditions?
AVERAGE
AVERAGEIFS
AVERAGEIF
SUMIFS
What would the COUNTIF function return if none of the cells in the range meet the condition?
1
0
An error
The total number of cells in the range
Which of these functions allows you to count cells based on more than one criterion?
COUNTIF
COUNTA
COUNTIFS
SUMIF
If you want to find how many cells in a range meet more than two conditions, which function would you use?
COUNTIF
COUNTIFS
COUNTA
COUNTBLANK
How does the AVERAGEIF function differ from the AVERAGEIFS function?
AVERAGEIF averages based on one condition, AVERAGEIFS averages based on multiple conditions
AVERAGEIF counts values, AVERAGEIFS sums them
AVERAGEIF works with text, AVERAGEIFS works with numbers
There is no difference
Which of these functions will return FALSE if only one of the conditions is false?
OR
AND
IF
NOT
What is the result of the formula =COUNTIF(A1:A10, '>=5') if all cells contain numbers greater than 5?
0
10
5
An error
Which of these is not a valid use of the COUNTIF function?
Counting cells with specific text
Counting cells greater than a value
Counting the number of blank cells
Counting cells with a date later than a specific day
