In Excel, which keyboard shortcut extends the selection to the last non-blank cell in the same column or row? MCQ with Answer and Explanation

Question
In Excel, which keyboard shortcut extends the selection to the last non-blank cell in the same column or row?
A. Ctrl + Arrow key
B. Ctrl + Space
C. Ctrl + Shift + Arrow key
D. Shift + Arrow key
Answer: Option C
Solution (By JKSSB Mock Tests)
Ctrl+Shift+Arrow extends selection to the edge of data region.
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 MS Excel, what does the error code '#NULL!' indicate?
A. A required lookup key value cannot be located inside a range array.
B. A formula specifies an intersection of two cell ranges that do not intersect.
C. A formula attempts to divide a numeric value by an empty cell row.
D. A function name contains a typographical misspelling mistake.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The #NULL! error occurs when a space operator is used between two ranges that do not intersect, such as evaluating =SUM(A1:A2 B1:B2) instead of using a comma operator.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, the 'Evaluate Formula' feature is found under which tab?
A. View
B. Data
C. Review
D. Formulas
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Evaluate Formula is in Formulas tab, Formula Auditing group.
This question belongs to: Computer Microsoft Office
Question #3
In PowerPoint, which view is best for reordering slides using drag and drop?
A. Notes Page
B. Normal
C. Reading
D. Slide Sorter
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Slide Sorter simplifies reordering.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Operating Systems 510 Memory and Storage Devices 438 CPU (Central Processing Unit) 327 Computer Software 347 Computer Fundamentals 326
Explore Subjects
Science 4430 Maths 5575 History GK 3374 Computer 5279 English 15164
Practice Mix
Which soil is generally found along the foothills of the Himalayas?
The Coromandel Coast receives most of its rainfall from:
Which of these is a famous folk dance of Tripura?
The 'BCCI' stands for:
What does the term 'cache hit' refer to?