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. LEN
B. CHAR
C. TEXT
D. LENGTH
Answer: Option A
Solution (By JKExamLibrary)
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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Access, the 'Field Size' property for a Number field can be:
A. Currency
B. Text, Memo
C. Byte, Integer, Long Integer, Single, Double, Decimal
D. Yes/No

Correct Answer: Option C


Explanation:
Number field size options include those.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, the small customized toolbar that appears immediately next to your cursor after selecting text containing options like bold, italic, and font size is called the:
A. Status Bar
B. Quick Access Toolbar
C. Mini Toolbar
D. Ribbon Explorer

Correct Answer: Option C


Explanation:
The Mini Toolbar automatically appears as a semi-transparent overlay when text is selected, offering rapid access to high-frequency formatting options.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Access, which of the following is a valid way to create a report?
A. Create > Report Design
B. Create > Report
C. Create > Report Wizard
D. All of the above

Correct Answer: Option D


Explanation:
All methods create reports.

This question belongs to: Computer Microsoft Office