In Excel, what does the formula =TRIM(A1) do? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the formula =TRIM(A1) do?

A. Deletes non-printable characters

B. Removes all spaces from the text

C. Removes all extra spaces from text except single spaces between words

D. Converts text to proper case

Answer: Option C

Solution (By JKSSB Mock Tests)

TRIM removes leading, trailing, and repeated spaces. 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 Excel, the 'PMT' function calculates:

A. Interest rate

B. Loan payment amount

C. Future value

D. Present value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
PMT returns periodic payment.

This question belongs to: Computer Microsoft Office

Question #2

Which feature in PowerPoint enables you to record narration for a presentation?

A. Insert tab -> Audio -> Record Audio

B. Slide Show tab -> Record Slide Show

C. Transitions tab -> Sound

D. Animations tab -> Audio

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Record Slide Show captures narration and slide timings.

This question belongs to: Computer Microsoft Office

Question #3

In MS Excel, which chart type is best suited for showing trends over time?

A. Column Chart

B. Pie Chart

C. Bar Chart

D. Line Chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Line charts are ideal for displaying trends over time or categories. Pie charts show proportions, bar and column compare categories.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs