Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel? MCQ with Answer and Explanation

Question
Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel?
A. Ctrl + Shift + Enter
B. Ctrl + Enter
C. Shift + Enter
D. Alt + Enter
Answer: Option D
Solution (By JKSSB Mock Tests)
Pressing Alt + Enter inserts a manual line break (starts a new line of text) inside the current cell, automatically enabling text wrapping.
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 function of the keyboard shortcut Ctrl + Equal Sign (=) when a block of text characters is highlighted in MS Word?
A. Applies a subscript text formatting layer
B. Resets the font size to the default preset sizing
C. Inserts an automated calculation formula field
D. Applies a superscript text formatting layer
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + Equal Sign (=) applies subscript formatting to the selected text, lowering it below the baseline. Ctrl + Shift + Plus Sign (+) applies superscript formatting.
This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, which option is used to set the slide show to loop continuously?
A. Design -> Loop
B. Transitions -> Advance Slide -> After
C. Animations -> Repeat
D. Slide Show -> Set Up Show -> Loop continuously until 'Esc'
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Loop setting in Set Up Show.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, the function =LARGE(A1:A10, 2) returns:
A. The smallest value
B. The average of top two
C. The second largest value in the range
D. The largest value
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
LARGE(array, k) returns k-th largest.
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)?