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

In Excel, which function is used to return the number of rows in a range?
A. COLUMNS
B. ROWS
C. ROW
D. COUNT
Answer: Option B
Solution (By JKExamLibrary)
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

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error
In PowerPoint, to compress all images in a presentation to reduce file size, use:
A. View -> Slide Master
B. Insert -> Picture -> Compress
C. File -> Compress Pictures (under Save As Tools) or Picture Format -> Compress Pictures
D. Design -> Compress Media

Correct Answer: Option C


Explanation:
Compress Pictures option is available in Picture Format tab or via File > Save As > Tools.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
Which of the following is not a valid way to start a new slide in MS PowerPoint?
A. Ctrl + M
B. Ctrl + N
C. Right-click in the slide pane and select New Slide
D. New Slide button on Home tab

Correct Answer: Option B


Explanation:
Ctrl + N opens a new presentation, not a new slide. Ctrl + M inserts a new slide. The other options insert a new slide.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel?
A. Shift + Enter
B. Ctrl + Enter
C. Alt + Enter
D. Ctrl + Shift + Enter

Correct Answer: Option C


Explanation:
Pressing Alt + Enter inserts a manual line break (starts a new line of text) inside the current cell, automatically enabling text wrapping.

This question belongs to: Computer Microsoft Office