In Excel, how do you select an entire row? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, how do you select an entire row?

A. Both A and B

B. Press Shift + Spacebar

C. Press Ctrl + Spacebar

D. Click the row number

Answer: Option A

Solution (By JKSSB Mock Tests)

Clicking the row number selects the entire row, and Shift + Spacebar is the keyboard shortcut. Ctrl + Spacebar selects the entire column.

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

What is the shortcut key to open the 'Open' dialog in MS Office?

A. Ctrl + P

B. Ctrl + O

C. Ctrl + S

D. Ctrl + N

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+O opens the Open dialog.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type should you choose to store a web address?

A. Attachment

B. Text

C. Hyperlink

D. Memo

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Hyperlink data type stores URLs.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function calculates the total of a range but ignores error values?

A. SUM

B. SUMIF

C. SUMPRODUCT

D. AGGREGATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs