WorksheetsGoogle Sheets Quiz
Total questions: 29
Worksheet time: 15mins
To add the numbers in cells A1 and A6, what formula do you type?
=A1+A6
=SUM(A1-A6)
=A1*A6
=DIFF(A1,A6)
How do you start any formula in Google Sheets?
With a parenthesis (
With an equal sign =
With a plus sign +
With the word FORMULA
On an iPad, how do you freeze the first row so it always stays visible when scrolling?
Tap the row number → Freeze → Freeze row
Tap View → Freeze → 1 column
Double-tap the gray bar above row 1
Tap the row number → Freeze → Freeze rows
Which formula finds the highest number in the range B2:B20?
=MAX(B2:B20)
=LARGEST(B2:B20)
=HIGHEST(B2:B20)
=TOP(B2:B20)
Which formula finds the lowest number in cells D5 to D15?
=MIN(D5:D15)
=SMALL(D5:D15)
=LOWEST(D5:D15)
=BOTTOM(D5:D15)
=SUM(A1:A10) will add:
Only the numbers in A1 to A10
Numbers and text in A1 to A10
Only the text in A1 to A10
Everything including blank cells as zero
=COUNT(A1:A10) counts:
Only cells with numbers
All non-blank cells
Only cells with text
Only blank cells
=COUNTA(A1:A10) counts:
Only cells with numbers
All non-blank cells
Only blank cells
Only cells with formulas
=COUNTBLANK(A1:A10) counts:
Cells with numbers
Cells with text
Empty-looking cells (truly blank)
Cells with formulas that show nothing
=AVERAGE(B2:B30) gives you:
The total of the numbers
The middle number when sorted
The arithmetic mean (average)
The most common number
=MEDIAN(C1:C20) gives you:
The average
The middle value when numbers are sorted
The highest value
The total
Which formula counts how many cells in A1:A100 have the word "Yes"?
=COUNTIF(A1:A100,"Yes")
=COUNT(A1:A100,"Yes")
=COUNTA(A1:A100,"Yes")
=SUMIF(A1:A100,"Yes")
=IF(A1>10,"Big","Small") means:
If A1 is greater than 10, show "Big", otherwise "Small"
If A1 is text, show "Big"
Add 10 to A1
Always show "Small"
To edit a formula on iPad, you:
Tap the cell → tap the formula bar at the top
Double-tap the cell
Tap the cell → tap the fx button
All of the above work
If you type =SUM(5,10,15) the result is:
5
15
30
Error
=COUNTIF(B:B,">=80") counts how many cells in column B are:
Exactly 80
80 or higher
Less than 80
Text
To freeze column A on iPad, you:
Tap the A column letter → Freeze → Freeze 1 column
Tap View → Freeze → 1 column
Both work
You cannot freeze columns on iPad
=IF(D5="","Empty","Not Empty") will show "Empty" when:
D5 has a number
D5 has any text
D5 is completely blank
D5 has a space
Which formula is written correctly?
=Average(A1:A10)
=AVERAGE(A1,A10)
=AVERAGE(A1:A10)
=average(A1:A10)
=MIN(10,20,5,30) returns:
5
10
30
65
If cells A1 to A5 contain: 10, 20, (blank), 30, 40 What does =COUNTA(A1:A5) return?
4
5
3
0
=AVERAGE(10,20,30,blank,40) returns:
25
20
100
Error
=MEDIAN(1,3,7,10,100) returns:
7
10
24.2
100
=IF(A1=A2,"Same","Different") will show "Same" when:
A1 and A2 have the same content
A1 is bigger in terms of length in the cells
A2 has texts and numbers that are able to counter
Both cells are blank
To select an entire column on iPad, you:
Tap the column letter at the top
Double-tap any cell in the column
Both work
You must drag
If you freeze row 1 and column A at the same time, the cell that stays visible in the top-left corner is:
A1
B2
A2
B1
Which function ignores text and only works with numbers?
AVERAGE
COUNTA
COUNTS
IF
On iPad, to insert a new row you:
Tap the row number → Insert → 1 row above/below
Tap the + button at the bottom-left
Both work
Long-press a cell
You shared a sheet with a classmate as “Editor” on iPad. They can now:
Only view
View and edit
Only comment
Delete the file
