Google Sheets Test Google Sheets Conditional Formatting Rules 2

Question 1

Which custom formula correctly highlights an entire row when the value in column C of that row exceeds 100?

Accepted Answer

=$C1>100

Answer

Locking only the column with $C1 lets the rule apply the same column reference across every column while the row shifts, highlighting the whole row.

Question 2

When applying conditional formatting to a range, which reference in a custom formula should point to the top-left cell of that range?

Accepted Answer

The first (top-left) cell of the selected range

Answer

Google Sheets evaluates a custom formula relative to the top-left cell of the applied range and adjusts it for the rest.

Question 3

Which rule type lets you assign a two- or three-point gradient of colors based on numeric magnitude?

Accepted Answer

Color scale

Answer

The Color scale tab applies a gradient across cells based on their relative values.

Question 4

To highlight cells that contain any text (are not empty of text), which built-in condition is best?

Accepted Answer

Is not empty

Answer

'Is not empty' formats every cell that holds any value including text.

Question 5

Which custom formula highlights duplicate values within column A?

Accepted Answer

=COUNTIF(A:A,A1)>1

Answer

COUNTIF counts how many times A1's value appears in column A, and >1 flags duplicates.

Google Sheets Test Practice Test