Google Sheets Test Google Sheets Conditional Formatting Rules 5 — Questions and Answers
Question 1: Which custom formula highlights weekends (Saturday or Sunday) based on a date in column A?
- =WEEKDAY($A1,2)>5 (Correct answer)
- =WEEKDAY(A1)=1
- =A1>TODAY()
- =DAY($A1)>5
Correct answer: =WEEKDAY($A1,2)>5
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?
- Formats cells missing a given substring (Correct answer)
- Formats empty cells only
- Formats numeric cells
- Deletes matching text
Correct answer: Formats cells missing a given substring
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?
- =B1<>A1 (Correct answer)
- =B1=A1
- =A1<>B1 always
- =ISBLANK(B1)
Correct answer: =B1<>A1
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?
- Only the value
- Value plus the conditional formatting rule (Correct answer)
- Nothing
- Only the format color, not the rule
Correct answer: Value plus the conditional formatting rule
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?
- =ISERROR(A1) (Correct answer)
- =A1="error"
- =ISNUMBER(A1)
- =A1<>0
Correct answer: =ISERROR(A1)
ISERROR returns TRUE when a cell holds an error like #DIV/0!, allowing it to be flagged.
Question 6: What is a key advantage of using a custom formula rule over a built-in single-color condition?
- It is always faster to load
- It can reference multiple cells and combine complex logic (Correct answer)
- It disables other rules
- It only works on text
Correct answer: It can reference multiple cells and combine complex logic
Custom formulas allow multi-cell references and logical functions, enabling conditions the preset options can't express.
Question 7: Which custom formula highlights every cell in a row when that row's checkbox in column E is TRUE?
- =$E1=TRUE (Correct answer)
- =E1="TRUE"
- =E$1=TRUE
- =$E$1=TRUE
Correct answer: =$E1=TRUE
Locking the column with $E1 checks each row's checkbox while spanning all columns of the row.
Google Sheets Test Google Sheets Conditional Formatting Rules 5
Which custom formula highlights weekends (Saturday or Sunday) based on a date in column A?