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

Question
In Excel, what does the function =ROW() return in cell C5?
A. C5
B. 5
C. 3
D. Error
Answer: Option B
Solution (By JKSSB Mock Tests)
ROW() without argument returns the row number of the cell containing the formula.
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 PowerPoint, what is the default keyboard shortcut used to launch a full-screen slide show presentation starting from the very first slide?
A. F1
B. Shift + F5
C. F5
D. Ctrl + F5
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The F5 key launches the slide show from the first slide. Pressing Shift + F5 launches the slide show from the currently active slide.
This question belongs to: Computer Microsoft Office
Question #2
What is the maximum number of worksheets that can be included in a single Excel workbook (by default)?
A. 16384
B. 3
C. Unlimited, limited by memory
D. 255
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
There is no fixed limit on the number of worksheets; it is limited by available memory. However, the default number of worksheets when creating a new workbook is 1 (in newer versions) or 3 (older). So the answer is unlimited, limited by memory.
This question belongs to: Computer Microsoft Office
Question #3
Which command tool in MS Excel removes duplicate rows from a selected data worksheet based on chosen columns?
A. Remove Duplicates
B. Text to Columns
C. Data Validation
D. Consolidate Data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The 'Remove Duplicates' feature on the Data tab analyzes selected rows and permanently deletes duplicate entries.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?