In Excel, which function is used to return the number of rows in a range? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to return the number of rows in a range?

A. COUNT

B. ROWS

C. COLUMNS

D. ROW

Answer: Option B

Solution (By JKSSB Mock Tests)

ROWS returns the count of rows in a reference. ROW returns the row number of a reference. COLUMNS returns column count.

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 Word, what does the 'Format Painter' tool copy?

A. Both text and formatting combined

B. Text contents alone

C. Images embedded in lines

D. Formatting and style configurations alone

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format Painter copies only visual formatting settings (fonts, colorations, spacing) from a source selection and applies them to a target.

This question belongs to: Computer Microsoft Office

Question #2

The shortcut to close an active document in MS Word is:

A. Alt + F4

B. Both A and B

C. Ctrl + F4

D. Ctrl + W

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+W or Ctrl+F4 closes the current document window. Alt+F4 exits the application.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, the data type that can store files like Word documents or images within a record is:

A. Attachment

B. Memo

C. OLE Object

D. Hyperlink

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Attachment is the modern data type for storing multiple files. OLE Object is older but also stores objects; but Attachment is more versatile.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs