Multiple choice general knowledge

This function removes any nonprintable characters from text.

  1. Value

  2. Clean

  3. Round

  4. Print

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The CLEAN function in Excel removes all non-printable characters from text. These are invisible control characters that can cause problems when importing or exporting data, or when processing text. CLEAN is commonly used to clean up data copied from other applications or systems.