Google Sheets Test Google Sheets Conditional Formatting Rules 4

Question 1

Which custom formula highlights a row where the value in column D matches a target listed in cell $G$1?

Accepted Answer

=$D1=$G$1

Answer

Locking the column ($D1) applies across the row while an absolute $G$1 keeps the comparison target fixed.

Question 2

What is the effect of using =AND(A1>0, B1<100) as a custom conditional formatting formula?

Accepted Answer

Formats only when both conditions are true

Answer

AND requires every argument to be TRUE, so both conditions must be satisfied for the format to apply.

Question 3

Which approach highlights cells that contain a specific word regardless of surrounding text?

Accepted Answer

Text contains

Answer

'Text contains' matches whenever the substring appears anywhere in the cell.

Question 4

To make conditional formatting reference another sheet's value, what must you use inside the custom formula?

Accepted Answer

An INDIRECT or a range imported to the same sheet

Answer

Conditional formatting formulas can't directly reference other sheets, so you use INDIRECT or bring the value onto the current sheet.

Question 5

Which custom formula highlights blank cells in a range?

Accepted Answer

=ISBLANK(A1)

Answer

ISBLANK returns TRUE for empty cells, flagging them for formatting.

Google Sheets Test Practice Test