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. ROWS

B. COUNT

C. ROW

D. COLUMNS

Answer: Option A

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 is the purpose of 'Section Break (Next Page)'?

A. Starts a new section on the same page

B. Inserts a page break only

C. Ends the document

D. Starts a new section on the next page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Next Page section break starts a new section on a new page.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'Field Size' property for a Number field can be:

A. Text, Memo

B. Byte, Integer, Long Integer, Single, Double, Decimal

C. Yes/No

D. Currency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Number field size options include those.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, which key can be used to jump to a specific slide number during a slide show?

A. Alt + slide number

B. Ctrl + G

C. Type slide number and press Enter

D. Shift + slide number

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
During slide show, type number and Enter to go to that slide.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs