Google Sheets Formula Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Formula flashcards as text
Which function returns the number of cells in A1:A20 that contain the text "Yes"?
Answer: =COUNTIF(A1:A20,"Yes")
COUNTIF counts cells that match a single condition.
What does =IFERROR(A1/B1,0) return when B1 is empty?
Answer: 0
IFERROR replaces the division error with the specified value 0.
Which symbol locks both the column and row in a cell reference?
Answer: $A$1
A dollar sign before both letter and number makes an absolute reference.
What does =CONCATENATE(A1," ",B1) do?
Answer: Joins A1 and B1 with a space between them
CONCATENATE joins text values, here separated by a space.
Which formula returns TRUE only if both A1>10 and B1>10?
Answer: =AND(A1>10,B1>10)
AND returns TRUE only when every condition is met.
What does =ROUND(3.14159,2) return?
Answer: 3.14
ROUND with 2 decimal places gives 3.14.
Which function returns today's date and updates automatically?
Answer: =TODAY()
TODAY() returns the current date and recalculates each day.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy