The "LEN()" function in MS-Excel belongs to which of the following categories?
Show Hint
- Financial
- Logical
- Maths & Trig
- Text
The Correct Option is D
Solution and Explanation
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.
Questions Asked in CUET PG exam
- A rectangular section has width $b$ and depth $d$ and a symmetrical triangular section has base $b$ and depth $d$. The ratio of moment of inertia of rectangular section to that of triangular section with respect to their respective centroidal axis will be:
- CUET (PG) - 2025
- Strength of Materials
A weight of $500\,$N is held on a smooth plane inclined at $30^\circ$ to the horizontal by a force $P$ acting at $30^\circ$ to the inclined plane as shown. Then the value of force $P$ is:
- CUET (PG) - 2025
- Engineering Mechanics
A steel wire of $20$ mm diameter is bent into a circular shape of $10$ m radius. If modulus of elasticity of wire is $2\times10^{5}\ \text{N/mm}^2$, then the maximum bending stress induced in wire is:
- CUET (PG) - 2025
- Strength of Materials
- Shape of the "shear force diagram" for a simply supported beam subjected to pure moment $M$ at the center of span, will be:
- CUET (PG) - 2025
- Strength of Materials
- Which of the following statements is correct?
- CUET (PG) - 2025
- Strength of Materials