Question: The text filter in column A is designed to display only those rows where column A entry has a particular attribute. What is this attribute?

  1. The second character in the cell is 9.
  2. The number 9 appears one or more times within the cell.
  3. The cell is comprised of 9 characters.
  4. The number 9 appears once and only once within the cell.

Answer: The correct answer of the above question is Option A:The second character in the cell is 9.