In Excel, which formula will return the number of characters in cell A1? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which formula will return the number of characters in cell A1?

A. =LENGTH(A1)

B. =LEN(A1)

C. =COUNT(A1)

D. =CHAR(A1)

Answer: Option B

Solution (By JKSSB Mock Tests)

LEN returns character count.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

In Word, which of the following is used to insert a symbol?

A. Insert > Advanced Symbol

B. Both A and B

C. Home > Symbol

D. Insert > Symbol

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Insert > Symbol and Insert > Advanced Symbol are similar.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Access, which of the following is used to create a query that asks for user input?

A. Crosstab Query

B. Select Query

C. Action Query

D. Parameter Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Parameter queries prompt for input.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, what is the purpose of the 'Format Background' option?

A. Allows you to change the background fill of the slide

B. Adds a background music

C. Applies a theme to all slides

D. Formats text and shapes

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Format Background changes slide background color, gradient, picture, etc.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs