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

Question

Share Report Error

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

A. Removes extra spaces from text

B. Removes non-printable characters

C. Truncates text to a specified length

D. Converts text to proper case

Answer: Option A

Solution (By JKSSB Mock Tests)

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In MS Access, to create a report with grouping and subtotals, use:

A. Chart Wizard

B. Report Wizard

C. Label Wizard

D. Blank Report

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Report Wizard allows grouping and summary options.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, to protect a worksheet from being edited, you can:

A. View tab -> Lock

B. Home tab -> Format -> Protect

C. File -> Info -> Protect Workbook

D. Review tab -> Protect Sheet

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Protect Sheet is under Review tab.

This question belongs to: Computer Microsoft Office

Question #3

In Word, which of the following is used to add a table of figures?

A. Insert > Table of Figures

B. References > Insert Table of Figures

C. View > Table of Figures

D. Review > Table of Figures

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Table of Figures is under References.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs