What is the result of the Excel formula =LEN("MS Excel 2026")?
A. 10
B. 12
C. 11
D. 13
Answer: Option D
Solution (By JKSSB Mock Tests)
The LEN function counts all characters within a text string, including alphanumeric digits, spaces, and special symbols. "MS Excel 2026" contains exactly 13 characters.
Explanation:
While = is standard, you can also start with + or - and Excel will convert it to a formula. @ is used in table references but not to begin a formula. So only = is required. + also works in some cases (e.g., +A1+A2). Many exams consider = only. I'll stick with = only. I'll set answer A.
No comments yet. Be the first to start the discussion!