In Excel, which function returns the number of characters in a text string? MCQ with Answer and Explanation

In Excel, which function returns the number of characters in a text string?
A. LENGTH
B. LEN
C. TEXT
D. CHAR
Answer: Option B
Solution (By JKSSB Mock Tests)
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.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Word, which of the following is not a type of tab stop?
A. Center
B. Left
C. Right
D. Justify

Correct Answer: Option D


Explanation:
Word tab stops include Left, Center, Right, Decimal, and Bar. Justify is a text alignment option, not a tab stop.

This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, to record a slide show with narration and timings, go to:
A. Slide Show tab -> Record Slide Show
B. Animations tab -> Record
C. Transitions tab -> Timing
D. Insert tab -> Audio -> Record

Correct Answer: Option A


Explanation:
Record Slide Show is under Slide Show tab.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, the 'Print Layout' view shows:
A. Outline headings
B. Document as it will appear when printed, with margins and page breaks
C. Thumbnails
D. Only text without formatting

Correct Answer: Option B


Explanation:
Print Layout is WYSIWYG view.

This question belongs to: Computer Microsoft Office