NEW
Font size
WorksheetsGoogle Sheets Functions Quiz
Total questions: 32
Worksheet time: 16mins
What will =IF(B2>50,"Pass","Fail") display if B2 contains 50?
Pass
Fail
50
TRUE
In a cell with =AVERAGE(10,20,30,40), what value is shown?
100
25
30
0
What does =SUM(A1:A5) return if A3 is blank and others have numbers?
Ignores the blank
Returns an error
Counts blank as 0
Returns blank
=COUNT(A1:A10) counts how many cells in A1:A10 contain:
Any data (text or numbers)
Only numbers
Only text
Only blank cells
What will =COUNTIF(B1:B10,">=70") count?
Cells with exactly 70
Cells with 70 or more
Cells with less than 70
Blank cells
=COUNTA(D1:D8) will count:
Only numeric values
All non-empty cells
Only text values
Only errors
In a range with 5 numbers and 2 blank cells, =COUNTBLANK(A1:A7) returns:
5
2
7
0
=MAX(15, 28, 9, 42, 33) returns:
15
28
33
42
What does =MEDIAN(10, 20, 30, 40, 50) show?
20
30
25
150
=MIN(8, 17, 5, 29, 11) returns:
29
5
8
17
If C5 contains "Excellent" because of an IF function, will =COUNT(C5) count it?
Yes
No
Only if it’s a number
Returns error
=IF(A1=100,"Perfect","Try Again") will show "Perfect" when A1 is:
100
99
101
Blank
What does =AVERAGE(B2:B6) do when B4 is blank?
Ignores B4
Treats B4 as 0
Returns #DIV/0!
Counts it as text
=SUM(5,10,15,20) is the same as writing:
=5+10+15+20
=AVERAGE(5,10,15,20)
=COUNT(5,10,15,20)
=MAX(5,10,15,20)
=COUNTIF(A1:A10,"Apple") counts cells that contain:
Exactly “Apple”
Nothing with “Apple” in it
Only numbers
Blank cells
In a column with names and some empty rows, which function counts filled cells?
COUNT
COUNTA
COUNTBLANK
MIN
=IF(D2=AVERAGE(B1:B10),"Above Average","Below/Average") – if B10 equals the average, it shows:
Above Average
Below/Average
TRUE
FALSE
Which formula correctly adds cells A1, A3, A5, and A7 only?
=SUMS(A1,A3,A5,A7)
=A1+A3+A5+A7
Both A and B
=COUNT(A1,A7)
What does =MIN(100,200,50,150) return?
50
100
150
500
=IF(A1=A2,"Match","Different") returns "Match" only when:
Values are the same
Cells are blank
One is text
They look the same
In a list of test scores, which function finds the middle value when sorted?
AVERAGE
MEDIAN
MODE
MID
=SUM(A1:A10)/COUNT(A1:A10) gives the same result as which function?
MEDIAN
AVERAGE
MAX
MIN
If cell E5 has the text "Absent", does =COUNT(E5) count it?
Yes
No
Probably
Returns #VALUE!
=IF(50>=50,"Yes","No") returns:
Yes
No
50
TRUE
Data: 45, 82, 67, 91, 58. =MAX of this data is:
58
91
82
67
=IF(COUNT(A1:A5)>3,"Many","Few") shows "Many" when at least __ cells have numbers.
3
4
5
2
In a row with some empty cells, =COUNTA(A1:G1) counts:
Only numbers
All filled cells
Only blanks
Only formulas
=MIN(0,-5,10,-2) returns:
0
-5
10
-2
Which function is most affected by extreme high or low values?
MEDIAN
AVERAGE
Both equally
Neither
=IF(COUNTA(B2:B20)=0,"Empty Column","Has Data") shows "Empty Column" when:
All cells are blank
At least one has data
All have numbers
There is text
Data: 88, 92, 76, 95, 81. What is =MEDIAN?
88
86.4
81
92
You want to give a bonus message only if a student has no blank cells in homework column D2:D10. Best formula?
=IF(COUNTBLANK(D2:D10)=0,"Bonus!","Incomplete")
=IF(COUNTA(D2:D10)=0,"Bonus!","Incomplete")
=IF(COUNT(D2:D10)=0,"Bonus!","Incomplete")
=IF(MAX(D2:D10)=0,"Bonus!","Incomplete")
