In Excel, what does the 'TRIM' function do? MCQ with Answer and Explanation

Question Report Error

In Excel, what does the 'TRIM' function do?

A. Removes extra spaces from text

B. Converts text to proper case

C. Removes non-printable characters

D. Truncates text to a specified length

Answer: Option A

Solution (By JKExamLibrary)

TRIM removes all leading, trailing, and multiple internal spaces, leaving single spaces between words. CLEAN removes non-printable characters.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

Which shortcut key is used to switch between open programs in Windows?

A. Ctrl + Tab

B. Alt + Tab

C. Shift + Tab

D. Windows + Tab

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Alt+Tab switches between open applications.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What is the shortcut key to delete a slide in MS PowerPoint?

A. Delete

B. Ctrl + X

C. Ctrl + D

D. Both A and C

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Pressing the Delete key (or Backspace) when a slide is selected in the thumbnail pane deletes it. Ctrl+D duplicates, Ctrl+X cuts.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Excel, which function returns the number of characters in a text string?

A. CHAR

B. LEN

C. TEXT

D. LENGTH

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
The LEN function returns the number of characters in a text string. LENGTH is not a function, CHAR returns a character based on code, TEXT formats a value.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs