What is the keyboard shortcut to extend a cell selection block from the active cursor position down to the very last populated cell in that column in MS Excel? MCQ with Answer and Explanation

Question
What is the keyboard shortcut to extend a cell selection block from the active cursor position down to the very last populated cell in that column in MS Excel?
A. Shift + Page Down
B. Alt + Shift + Down Arrow
C. Ctrl + Shift + End
D. Ctrl + Shift + Down Arrow
Answer: Option D
Solution (By JKSSB Mock Tests)
Ctrl + Shift + Down Arrow extends the selection range down to the last non-blank cell in that column. Pressing Ctrl + Down Arrow jumps to that cell without selecting the range.
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 Access, which of the following is not a valid field property?
A. Caption
B. Format
C. Sort Order
D. Field Size
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.
This question belongs to: Computer Microsoft Office
Question #2
In PowerPoint, to compress all images in a presentation to reduce file size, use:
A. View -> Slide Master
B. Insert -> Picture -> Compress
C. File -> Compress Pictures (under Save As Tools) or Picture Format -> Compress Pictures
D. Design -> Compress Media
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Compress Pictures option is available in Picture Format tab or via File > Save As > Tools.
This question belongs to: Computer Microsoft Office
Question #3
In MS Word, 'Kerning for fonts' can be set from:
A. Paragraph dialog
B. Page Setup
C. Font dialog -> Advanced tab
D. Styles
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Kerning is under Font -> Advanced.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: