Google Sheets Test Google Sheets Conditional Formatting Rules 5

Question 1

Which custom formula highlights weekends (Saturday or Sunday) based on a date in column A?

Accepted Answer

=WEEKDAY($A1,2)>5

Answer

WEEKDAY with type 2 returns 6 for Saturday and 7 for Sunday, so >5 flags weekends.

Question 2

What does the 'Text does not contain' condition do?

Accepted Answer

Formats cells missing a given substring

Answer

It applies formatting to cells that do not include the specified substring.

Question 3

Which custom formula highlights cells where the value differs from the cell directly to its left?

Accepted Answer

=B1<>A1

Answer

Comparing B1<>A1 flags cells whose value is not equal to the neighbor on the left.

Question 4

When you copy a cell with conditional formatting and paste it elsewhere, what is pasted by default with a normal paste?

Accepted Answer

Value plus the conditional formatting rule

Answer

A standard paste carries both the content and the conditional formatting rule, extending the rule's range.

Question 5

Which formula highlights cells containing an error value?

Accepted Answer

=ISERROR(A1)

Answer

ISERROR returns TRUE when a cell holds an error like #DIV/0!, allowing it to be flagged.

Google Sheets Test Practice Test