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. ROW()

B. ROW_NUMBER()

C. COLUMN()

D. ROWS()

Answer: Option A

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

Which tab contains the 'Slide Master' command in MS PowerPoint?

A. View

B. Home

C. Insert

D. Design

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Slide Master is located under the View tab, in the Master Views group. It is not in Design, though Design affects themes.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, a 'Query' can be used to:

A. Create relationships

B. Add, delete, or update data in tables

C. Create forms

D. Generate reports

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Queries can be action queries that add, delete, update, or append data. Forms are created separately, reports separately, and relationships are defined in the Relationships window.

This question belongs to: Computer Microsoft Office

Question #3

In MS PowerPoint, what is the default keyboard shortcut used to insert a brand-new, blank slide into the active presentation file?

A. Ctrl + S

B. Ctrl + Shift + N

C. Ctrl + N

D. Ctrl + M

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + M inserts a new slide into the active presentation file. Ctrl + N opens a brand-new, blank presentation file window.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs