Google Sheets Test Google Sheets Formulas and Basic Functions 3

Question 1

In the reference $A$1, what does the dollar sign before both letter and number mean?

Accepted Answer

The reference is absolute and won't change when copied

Answer

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?

Accepted Answer

Returns Pass if B2 is over 50, otherwise Fail

Answer

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?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells that meet a specified criterion, such as ">100".

Question 4

What does =SUMIF(A1:A10, ">5") return?

Accepted Answer

The sum of values greater than 5 in the range

Answer

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?

Accepted Answer

=A2+B2

Answer

Relative references automatically adjust to the new row when copied down.

Google Sheets Test Practice Test