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

Share Report Error

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

A. Ctrl + Space

B. Ctrl + Shift + Arrow key

C. Ctrl + Arrow key

D. Shift + Arrow key

Answer: Option B

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 PowerPoint, what is the maximum zoom percentage?

A. 400%

B. 500%

C. 200%

D. 300%

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
PowerPoint allows zoom up to 400%.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, to create a report with grouping and subtotals, use:

A. Report Wizard

B. Label Wizard

C. Chart Wizard

D. Blank Report

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Report Wizard allows grouping and summary options.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, to create a bulleted list quickly, type an asterisk (*) and press:

A. Ctrl + Enter

B. Shift + Enter

C. Spacebar or Tab

D. Enter

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Typing * followed by Spacebar or Tab automatically starts a bulleted list (AutoFormat).

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs