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 PowerPoint, to record a slide show with narration and timings, go to:

A. Transitions tab -> Timing

B. Insert tab -> Audio -> Record

C. Animations tab -> Record

D. Slide Show tab -> Record Slide Show

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Record Slide Show is under Slide Show tab.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, to create a relationship between two tables, you typically use:

A. External Data -> Link Tables

B. Create -> Table Relationships

C. Design -> Relationships

D. Database Tools -> Relationships

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Relationships are managed under Database Tools tab.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the function of the shortcut key combination Ctrl + [ in MS Word?

A. Inserts an opening square bracket block

B. Increases the font size of selected text by 1 point

C. Aligns the paragraph to the left edge

D. Decreases the font size of selected text by 1 point

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + [ decreases the font size of selected characters by exactly 1 point size, whereas Ctrl + ] increases it by 1 point.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs