Google Sheets Test Google Sheets Conditional Formatting Rules 3 — Questions and Answers
Question 1: What does a custom formula rule of =ISODD(ROW()) accomplish when applied to a range?
- Highlights every odd-numbered column
- Highlights alternating (odd) rows for a banded look (Correct answer)
- Highlights cells with odd values
- Removes formatting from even rows
Correct answer: Highlights alternating (odd) rows for a banded look
ISODD(ROW()) returns TRUE on odd row numbers, producing zebra-striped alternating rows.
Question 2: Which custom formula highlights a cell in B2 only when A2 equals 'Yes'?
- =A2="Yes"
- =$A2="Yes" (Correct answer)
- =A$2="Yes"
- =B2="Yes"
Correct answer: =$A2="Yes"
Locking the column with $A2 makes the rule check column A of each row while allowing it to span multiple rows.
Question 3: In a color scale, what does the 'Midpoint' setting control?
- The average of all values
- An optional middle color and its threshold value (Correct answer)
- The header formatting
- The number of decimal places
Correct answer: An optional middle color and its threshold value
The midpoint adds an optional third color at a chosen value type such as percentile, number, or percent.
Question 4: Which formula flags cells where the text length exceeds 10 characters?
- =LEN(A1)>10 (Correct answer)
- =COUNT(A1)>10
- =A1>10
- =CHAR(A1)>10
Correct answer: =LEN(A1)>10
LEN returns the character count of a cell, so LEN(A1)>10 catches long entries.
Question 5: How can you apply the same conditional formatting rule to multiple non-adjacent ranges at once?
- You cannot; rules take only one range
- Enter multiple ranges separated by commas in the 'Apply to range' box (Correct answer)
- Create a separate rule for each range only
- Merge the cells first
Correct answer: Enter multiple ranges separated by commas in the 'Apply to range' box
The 'Apply to range' field accepts several ranges separated by commas, applying one rule to all of them.
Question 6: What happens to a conditional formatting rule when you delete the rows or columns it referenced?
- The rule automatically adjusts or shrinks its range (Correct answer)
- The entire spreadsheet loses formatting
- Nothing changes ever
- The rule converts to static formatting
Correct answer: The rule automatically adjusts or shrinks its range
Google Sheets updates the rule's applied range to reflect deleted rows or columns.
Question 7: Which condition best highlights cells whose numeric value is between 50 and 100 inclusive?
- Greater than 50
- Is between 50 and 100 (Correct answer)
- Less than 100
- Text contains 50
Correct answer: Is between 50 and 100
The 'Is between' condition formats values within the specified inclusive range.
Google Sheets Test Google Sheets Conditional Formatting Rules 3
What does a custom formula rule of =ISODD(ROW()) accomplish when applied to a range?