Multiple choice technology

The LEN function does what?

  1. Compares the content in two cells.

  2. Counts the numbers of characters in a cell.

  3. Deletes extra spaces in text.

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The LEN function returns the number of characters in a text string, including spaces and punctuation. For example, LEN('hello') returns 5, and LEN('hello world') returns 11 (counting the space). It's useful for data validation, text manipulation, and checking cell content length before processing.

Keep practicing — related questions