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: Comprehending the LEN() function. The LEN() function in MS-Excel serves to enumerate characters within a cell, specifically pertaining to textual data.

Step 2: Evaluating the alternatives. - (A) Financial: The LEN() function does not apply to financial computations. - (B) Logical: The LEN() function is not utilized for logical operations. - (C) Maths & Trig: The LEN() function is not classified as a mathematical or trigonometric function. - (D) Text: This option is correct, as the LEN() function falls under the Text category.

Step 3: Final Determination. The correct classification is (D) Text.