Question

The "LEN()" function in MS-Excel belongs to which of the following categories?

• A. Financial
• B. Logical
• C. Maths & Trig
• D. Text

Hint:

The LEN() function is useful for text manipulation in Excel, specifically for counting characters in a string.

Answer 1

The Correct Option is D

Step 1: Understanding the LEN() function.
The LEN() function in MS-Excel is used to count the number of characters in a cell, which is related to text.

Step 2: Analyzing the options.
- (A) Financial: The LEN() function is not used for financial calculations.
- (B) Logical: The LEN() function is not used for logical operations.
- (C) Maths & Trig: The LEN() function is not a mathematical or trigonometric function.
- (D) Text: This is the correct answer, as the LEN() function belongs to the Text category.

Step 3: Conclusion.
The correct answer is (D) Text.