In Excel, which function is used to return the number of rows in a range? MCQ with Answer and Explanation

Question
In Excel, which function is used to return the number of rows in a range?
A. COLUMNS
B. COUNT
C. ROW
D. ROWS
Answer: Option D
Solution (By JKSSB Mock Tests)
ROWS returns the count of rows in a reference. ROW returns the row number of a reference. COLUMNS returns column count.
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 Word, which of the following is used to change the case of selected text?
A. Format > Change Case
B. Insert > Change Case
C. Review > Change Case
D. Home > Change Case
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Change Case is in the Home tab, Font group.
This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which feature enables you to quickly save frequently used text or layout blocks so you can insert them with just a few keystrores?
A. AutoCorrect table options
B. Smart Lookup database
C. Quick Parts (AutoText)
D. Mail Merge fields
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Quick Parts (including AutoText blocks) allow you to store text snippets, disclaimers, or layout blocks to reuse them across multiple documents.
This question belongs to: Computer Microsoft Office
Question #3
What is the maximum number of columns in a Word table (as of Word 2016)?
A. 255
B. 63
C. 32767
D. Unlimited
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Word table can have up to 63 columns. The number of rows is virtually unlimited (up to 32,767 rows in a table). So 63 is correct.
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)?