Multiple choice technology

Which function would you use to compare cell contents

  1. LEN

  2. TRIM

  3. EXACT

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

The EXACT function performs case-sensitive comparison of two text strings, returning TRUE only if they match exactly in both content and case. LEN returns the character count, and TRIM removes extra spaces but doesn't compare. When you need to verify whether cell contents are identical (including case sensitivity), EXACT is the correct function.

Keep practicing — related questions