In Excel, which formula will return '5' from the text 'Excel5'? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which formula will return '5' from the text 'Excel5'?

A. =LEN("Excel5")

B. =LEFT("Excel5",1)

C. =RIGHT("Excel5",1)

D. =MID("Excel5",2,1)

Answer: Option C

Solution (By JKSSB Mock Tests)

RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.

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

In Access, which of the following is used to create a query that uses SQL?

A. SQL View

B. Both A and B

C. Datasheet View

D. Design View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can create a query in SQL View or Design View.

This question belongs to: Computer Microsoft Office

Question #2

What is the shortcut key sequence to center-align a paragraph block in MS Word?

A. Ctrl + J

B. Ctrl + C

C. Ctrl + Alt + C

D. Ctrl + E

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + E is the standard keyboard shortcut used to apply center alignment to text or paragraphs in MS Word.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the chart type that shows the relationship between two sets of numeric data using dots is:

A. Bar chart

B. Scatter (XY) chart

C. Bubble chart

D. Line chart

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Scatter chart plots x,y pairs.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs