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

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

A. Ctrl + Shift + Arrow key

B. Ctrl + Space

C. Ctrl + Arrow key

D. Shift + Arrow key

Answer: Option A

Ctrl+Shift+Arrow extends selection to the edge of data region.

This question belongs to: Computer Microsoft Office

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

Question #1 Report Error

What is the shortcut key to move between open workbooks in Excel?

A. Ctrl + F6

B. Ctrl + Tab

C. Alt + Tab

D. Both A and B

Correct Answer: Option D

Explanation:
In Excel, Ctrl+Tab and Ctrl+F6 both cycle through open workbooks. Alt+Tab switches between all open applications.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

What built-in reference tool in MS Word acts as a dictionary of synonyms to look up alternative word choices for a selected term?

A. Thesaurus

B. Smart Lookup

C. Spell Checker

D. Translate Panel

Correct Answer: Option A

Explanation:
The Thesaurus tool (accessible via Shift + F7) searches for synonyms and antonyms for a selected word to improve vocabulary choices.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Excel, what is the intersection of a row and a column called?

A. Range

B. Cell

C. Record

D. Field

Correct Answer: Option B

Explanation:
A cell is the intersection point. Range is a group of cells.

This question belongs to: Computer Microsoft Office