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

In Excel, which function returns the row number of a reference?
A. ROW()
B. ROW_NUMBER()
C. ROWS()
D. COLUMN()
Answer: Option A
Solution (By JKExamLibrary)
ROW(reference) returns row number. COLUMN returns column number.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In MS PowerPoint, what occurs if you select an item block and press the shortcut key combination Ctrl + Shift + C?
A. Centers the text alignment within a container bounding box
B. Copies the formatting and visual style properties of the selected object
C. Clones the active slide canvas layout
D. Inserts a comment block on the active presentation slide

Correct Answer: Option B


Explanation:
Ctrl + Shift + C copies only the style formatting properties of a selected object or text block. Pressing Ctrl + Shift + V applies those copied styles to a new selection.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, what is the function of the 'Crop' tool?
A. To rotate an image
B. To change the brightness of an image
C. To resize an image
D. To remove unwanted areas of an image

Correct Answer: Option D


Explanation:
Crop removes the outer edges of a picture to focus on a specific area. It does not resize (though cropping changes dimensions), adjust brightness, or rotate.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
To move the cursor to the end of a document in MS Word, press:
A. End
B. Ctrl + End
C. Shift + End
D. Ctrl + Page Down

Correct Answer: Option B


Explanation:
Ctrl+End jumps to end of document. End goes to end of line.

This question belongs to: Computer Microsoft Office