Google Sheets Test Google Sheets Conditional Formatting Rules 3

Question 1

What does a custom formula rule of =ISODD(ROW()) accomplish when applied to a range?

Accepted Answer

Highlights alternating (odd) rows for a banded look

Answer

ISODD(ROW()) returns TRUE on odd row numbers, producing zebra-striped alternating rows.

Question 2

Which custom formula highlights a cell in B2 only when A2 equals 'Yes'?

Accepted Answer

=$A2="Yes"

Answer

Locking the column with $A2 makes the rule check column A of each row while allowing it to span multiple rows.

Question 3

In a color scale, what does the 'Midpoint' setting control?

Accepted Answer

An optional middle color and its threshold value

Answer

The midpoint adds an optional third color at a chosen value type such as percentile, number, or percent.

Question 4

Which formula flags cells where the text length exceeds 10 characters?

Accepted Answer

=LEN(A1)>10

Answer

LEN returns the character count of a cell, so LEN(A1)>10 catches long entries.

Question 5

How can you apply the same conditional formatting rule to multiple non-adjacent ranges at once?

Accepted Answer

Enter multiple ranges separated by commas in the 'Apply to range' box

Answer

The 'Apply to range' field accepts several ranges separated by commas, applying one rule to all of them.

Google Sheets Test Practice Test