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

Question
In Excel, which formula will correctly return the text 'Hello' from cell A1 if A1 contains 'Hello World'?
A. =LEFT(A1,5)
B. =MID(A1,1,6)
C. =RIGHT(A1,5)
D. =TRIM(A1)
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
What is the shortcut to open the 'Format Cells' dialog with Font tab in Excel?
A. Ctrl + Shift + P
B. Ctrl + 1
C. Ctrl + Shift + F
D. Alt + F
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Shift+F opens Format Cells -> Font. Ctrl+1 opens main Format Cells.
This question belongs to: Computer Microsoft Office
Question #2
What is the function of the shortcut key combination Ctrl + Shift + G in MS Word?
A. Activates the Research pane
B. Inserts a hyperlink
C. Toggles between uppercase and lowercase text
D. Opens the Word Count dialog box
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + Shift + G directly opens the Word Count statistics dialog box in MS Word, providing details like pages, words, characters, and paragraphs.
This question belongs to: Computer Microsoft Office
Question #3
Which specialized view or wizard tool in MS Excel displays a step-by-step breakdown of calculations to help troubleshoot nested formulas?
A. Trace Dependents map
B. Watch Window tool
C. Evaluate Formula
D. Error Checking guide
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Evaluate Formula tool on the Formulas tab steps through each part of a formula in sequence, showing calculated values at each step to simplify debugging.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?