In Excel, which function returns the row number of a reference? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function returns the row number of a reference?

A. ROWS()

B. ROW_NUMBER()

C. ROW()

D. COLUMN()

Answer: Option C

Solution (By JKSSB Mock Tests)

ROW(reference) returns row number. COLUMN returns column number.

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 'Find' dialog in MS Excel?

A. Ctrl + F

B. Ctrl + G

C. Ctrl + H

D. F5

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+F opens Find and Replace with Find tab. Ctrl+G is Go To, Ctrl+H is Replace, F5 also Go To.

This question belongs to: Computer Microsoft Office

Question #2

In MS PowerPoint, which feature is used to add a text placeholder that can be edited on the slide?

A. Table

B. Text Box

C. WordArt

D. Shape

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Text Box is a rectangular area where you can type and format text independently. WordArt is styled text, Shape can contain text, but Text Box is specifically for editable text.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which field property ensures that each record has a unique identifier?

A. Validation Rule

B. Primary Key

C. Required

D. Indexed

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Primary Key uniquely identifies each record and does not allow nulls. Indexed improves search, Required forces data entry, Validation Rule checks input.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs