In Excel, which formula will correctly return the text 'Hello' from cell A1 if A1 contains 'Hello World'? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which formula will correctly return the text 'Hello' from cell A1 if A1 contains 'Hello World'?

A. =LEFT(A1,5)

B. =TRIM(A1)

C. =MID(A1,1,6)

D. =RIGHT(A1,5)

Answer: Option A

Solution (By JKSSB Mock Tests)

LEFT(A1,5) extracts first 5 characters ('Hello'). RIGHT gets from right, MID from any position, TRIM removes extra spaces.

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

What is the keyboard shortcut to left-align a selected block of text characters or an active paragraph in MS Word?

A. Ctrl + R

B. Ctrl + J

C. Ctrl + L

D. Ctrl + E

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key to go to the beginning of a document in MS Word?

A. Ctrl + End

B. Home

C. Ctrl + Page Up

D. Ctrl + Home

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Home moves the cursor to the beginning of the document. Ctrl + End goes to the end. Home moves to the beginning of the line. Ctrl+Page Up moves to previous page.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Access, which of the following is not a valid data type for a field?

A. Currency

B. Yes/No

C. Image

D. AutoNumber

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
There is no 'Image' data type; you use Attachment or OLE Object to store images.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs