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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Excel, which of the following functions rounds a number up, away from zero?
A. CEILING()
B. ROUND()
C. ROUNDDOWN()
D. ROUNDUP()

Correct Answer: Option D


Explanation:
ROUNDUP rounds up. CEILING also rounds up but to a specified multiple. ROUND rounds to nearest digit.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which option allows you to change the background style of a slide?
A. Background Styles
B. Both A and B
C. Slide Design
D. Format Background

Correct Answer: Option B


Explanation:
In PowerPoint, you can right-click and select 'Format Background' or use the 'Background Styles' dropdown under Design tab to change the background.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, which of the following is used to create a list of headings and their page numbers?
A. Table of Contents
B. Table of Figures
C. Bibliography
D. Index

Correct Answer: Option A


Explanation:
Table of Contents generates a list of headings with their corresponding page numbers based on heading styles. Index lists keywords, Table of Figures lists captions, Bibliography lists sources.

This question belongs to: Computer Microsoft Office