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

LEN returns the count of all characters in a cell including letters, numbers, spaces, and punctuation. For example, LEN("Hello") returns 5, and LEN("Hi There") returns 8 including the space.