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

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 JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

What is the function of the 'Alt + Tab' shortcut in Windows OS while working with MS Office?

A. Open Task Manager

B. Switch between open applications

C. Close the current application

D. Switch between documents within the same application

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Alt + Tab is a Windows shortcut to switch between open applications. Ctrl + Tab switches between documents in the same app. Alt + F4 closes the current window. Ctrl + Shift + Esc opens Task Manager.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, how do you select an entire row?

A. Both A and B

B. Click the row number

C. Press Shift + Spacebar

D. Press Ctrl + Spacebar

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Clicking the row number selects the entire row, and Shift + Spacebar is the keyboard shortcut. Ctrl + Spacebar selects the entire column.

This question belongs to: Computer Microsoft Office