Google Sheets Test Google Sheets Formulas and Basic Functions 3 — Questions and Answers
Question 1: In the reference $A$1, what does the dollar sign before both letter and number mean?
- The reference is absolute and won't change when copied (Correct answer)
- The value is currency
- The cell is locked from editing
- The reference is relative
Correct 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.
Question 2: What does =IF(B2>50, "Pass", "Fail") do?
- Returns Pass if B2 is over 50, otherwise Fail (Correct answer)
- Adds 50 to B2
- Counts values over 50
- Returns Pass only if B2 equals 50
Correct 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.
Question 3: Which function would you use to count cells greater than 100 in a range?
- COUNTIF (Correct answer)
- COUNT
- SUMIF
- IF
Correct answer: COUNTIF
COUNTIF counts cells that meet a specified criterion, such as ">100".
Question 4: What does =SUMIF(A1:A10, ">5") return?
- The sum of values greater than 5 in the range (Correct answer)
- The count of values greater than 5
- The average of the range
- The largest value over 5
Correct answer: The sum of values greater than 5 in the range
SUMIF adds only the cells that meet the given criterion.
Question 5: When you copy =A1+B1 from row 1 down to row 2, what does it become?
- =A2+B2 (Correct answer)
- =A1+B1
- =A2+B1
- =B1+C1
Correct answer: =A2+B2
Relative references automatically adjust to the new row when copied down.
Question 6: Which function rounds 3.14159 to two decimal places?
- =ROUND(3.14159, 2) (Correct answer)
- =ROUND(3.14159, 0)
- =TRUNC(3.14159)
- =INT(3.14159)
Correct answer: =ROUND(3.14159, 2)
ROUND's second argument specifies how many decimal places to keep.
Question 7: What error appears when you divide a number by zero?
- #DIV/0! (Correct answer)
- #REF!
- #VALUE!
- #N/A
Correct answer: #DIV/0!
Dividing by zero produces the #DIV/0! error.
Google Sheets Test Google Sheets Formulas and Basic Functions 3
In the reference $A$1, what does the dollar sign before both letter and number mean?