Google Sheets Test Google Sheets Conditional Formatting Rules 2 — Questions and Answers
Question 1: Which custom formula correctly highlights an entire row when the value in column C of that row exceeds 100?
- =$C1>100 (Correct answer)
- =C$1>100
- =C1>100
- =$C$1>100
Correct answer: =$C1>100
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?
- The last cell in the range
- The first (top-left) cell of the selected range (Correct answer)
- Cell A1 always
- The header cell
Correct answer: The first (top-left) cell of the selected range
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?
- Single color
- Color scale (Correct answer)
- Data bars
- Icon sets
Correct answer: Color scale
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?
- Is empty
- Text contains
- Text is exactly
- Is not empty (Correct answer)
Correct answer: Is not empty
'Is not empty' formats every cell that holds any value including text.
Question 5: Which custom formula highlights duplicate values within column A?
- =COUNTIF(A:A,A1)>1 (Correct answer)
- =COUNT(A:A)>1
- =A1=A2
- =UNIQUE(A:A)
Correct answer: =COUNTIF(A:A,A1)>1
COUNTIF counts how many times A1's value appears in column A, and >1 flags duplicates.
Question 6: If two conditional formatting rules both apply to the same cell, how does Google Sheets decide which formatting wins for a conflicting property?
- The last rule in the list wins
- The rule higher in the list takes priority (Correct answer)
- They blend together
- The most recently created rule always wins
Correct answer: The rule higher in the list takes priority
Rules are evaluated top-down, and the first (highest) matching rule's formatting takes precedence for conflicting properties.
Question 7: Which condition would you use to format dates that fall before today's date automatically?
- Date is after today
- Date is before + Today (Correct answer)
- Text contains 'date'
- Greater than 0
Correct answer: Date is before + Today
The 'Date is before' condition with the 'Today' option formats cells with dates earlier than the current day.
Google Sheets Test Google Sheets Conditional Formatting Rules 2
Which custom formula correctly highlights an entire row when the value in column C of that row exceeds 100?