In Excel, what does the function =ROW() return in cell C5? MCQ with Answer and Explanation

In Excel, what does the function =ROW() return in cell C5?
A. 5
B. Error
C. C5
D. 3
Answer: Option A
Solution (By JKSSB Mock Tests)
ROW() without argument returns the row number of the cell containing the formula.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, which field size validation rule limits a Short Text entry to contain at most 50 characters?
A. Input Mask
B. Format Limit
C. Field Size
D. Validation Rule

Correct Answer: Option C


Explanation:
The Field Size property specifies the maximum character storage capacity limit allowed for Short Text fields.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, the automated reference assistant feature that scans across an entire document to build a hyperlinked directory map of heading milestones is called:
A. Bookmark registry
B. Cross-reference guide
C. Smart Lookup framework
D. Navigation Pane

Correct Answer: Option D


Explanation:
The Navigation Pane indexes document headings (formatted with Heading styles), creating an interactive, click-to-jump directory outline map on the left side of the screen.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, the 'Cascade Update Related Fields' option will:
A. Prevent deletion of records that have related records
B. Delete related records when the primary record is deleted
C. Automatically update the foreign key in related records when the primary key is changed
D. Copy the primary key to child table

Correct Answer: Option C


Explanation:
Cascade Update updates foreign keys. Cascade Delete deletes related records.

This question belongs to: Computer Microsoft Office