Google Certified Educator Level 2 Practice Exam

Which of the following ways can you apply conditional formatting to a cell?

1. By date

2. By text contained in the cell

3. By a number in the cell

4. By an image in the cell

The correct answer is: By date

Conditional formatting allows you to apply different formatting styles to a cell based on specified conditions. In this question, the correct answer is "By date" because you can apply conditional formatting based on dates, such as highlighting past due dates, highlighting upcoming deadlines, or applying different colors based on different date ranges. The other options are incorrect because: - Conditional formatting can also be applied based on text contained in the cell, which makes option B partially correct. - Conditional formatting can be based on a specific number or range of numbers in a cell, making option C valid in some cases. - Conditional formatting cannot be applied based on an image in the cell since conditional formatting is based on cell values or data types, and not on inserted images.