Google Sheets Formulas and Basic Functions 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 Formulas and Basic Functions flashcards as text
In the reference $A$1, what does the dollar sign before both letter and number mean?
Answer: The reference is absolute and won't change when copied
A double dollar sign makes both column and row absolute so the reference stays fixed when the formula is copied.
What does =IF(B2>50, "Pass", "Fail") do?
Answer: Returns Pass if B2 is over 50, otherwise Fail
IF tests the condition and returns the first result if true, the second if false.
Which function would you use to count cells greater than 100 in a range?
Answer: COUNTIF
COUNTIF counts cells that meet a specified criterion, such as ">100".
What does =SUMIF(A1:A10, ">5") return?
Answer: The sum of values greater than 5 in the range
SUMIF adds only the cells that meet the given criterion.
When you copy =A1+B1 from row 1 down to row 2, what does it become?
Answer: =A2+B2
Relative references automatically adjust to the new row when copied down.
Which function rounds 3.14159 to two decimal places?
Answer: =ROUND(3.14159, 2)
ROUND's second argument specifies how many decimal places to keep.
What error appears when you divide a number by zero?
Answer: #DIV/0!
Dividing by zero produces the #DIV/0! error.
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