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. CHAR
C. TEXT
D. LEN
Answer: Option D
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
Which feature in MS Word allows users to create standardized form letters or labels by combining a master template document with an external address list database?
A. Quick Parts automation
B. Mail Merge
C. Track Changes framework
D. Style Separator compilation

Correct Answer: Option B


Explanation:
Mail Merge is an automation tool that merges a standardized template document with an external data source (such as an Excel spreadsheet or Access table) to bulk-generate personalized mass mailings or labels.

This question belongs to: Computer Microsoft Office
Question #2
To start a slide show from the very first slide in MS PowerPoint, press:
A. Ctrl + F5
B. Shift + F5
C. F5
D. Alt + F5

Correct Answer: Option C


Explanation:
F5 starts the slide show from the beginning. Shift + F5 starts from the current slide.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, the 'Allow Zero Length' property is relevant for:
A. All fields
B. Number fields
C. Text and Memo (Long Text) fields
D. Date fields

Correct Answer: Option C


Explanation:
Only text-based fields.

This question belongs to: Computer Microsoft Office