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 Report Error

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. Ctrl + Shift + Down Arrow

B. Shift + Page Down

C. Alt + Shift + Down Arrow

D. Ctrl + Shift + End

Answer: Option A

Solution (By JKExamLibrary)

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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Access, which data type automatically inserts a unique sequential number?

A. Number

B. AutoNumber

C. Text

D. Calculated

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
AutoNumber increments automatically.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In PowerPoint, which option allows you to save a presentation as a video?

A. File -> Export -> Create a Video

B. Both A and B

C. Save As -> MP4

D. Slide Show -> Record -> Export

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Both Export and Save As can create a video file.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

Which of the following functions in Excel returns the current date and time?

A. =TIME()

B. =TODAY()

C. =NOW()

D. =DATE()

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
=NOW() returns the current date and time. =TODAY() returns only current date. =DATE() creates a date from year, month, day. =TIME() creates time.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs