In Excel, which function is used to find the smallest value in a range? MCQ with Answer and Explanation

Question
In Excel, which function is used to find the smallest value in a range?
A. MINIFS
B. SMALL
C. MIN
D. MINA
Answer: Option C
Solution (By JKSSB Mock Tests)
MIN returns the smallest numeric value. SMALL returns the nth smallest, MINA includes logical values, MINIFS based on criteria.
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
What is the shortcut key to open the 'Symbol' dialog in MS Word?
A. Both A and B
B. Alt + Ctrl + S
C. Alt + N, U, S
D. Insert > Symbol
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can insert symbol via Insert > Symbol, and the keyboard shortcut Alt+N,U,S (or Alt+I,S in older versions) opens the Symbol dialog. So both are valid.
This question belongs to: Computer Microsoft Office
Question #2
Which pane in MS PowerPoint allows authors to manage the playback sequence, timings, delays, and trigger rules of individual slide animations?
A. Animation Pane
B. Transition Configuration panel
C. Selection Pane
D. Format Background properties sheet
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Animation Pane opens on the right side of the workspace, providing a timeline layout to view, reorder, adjust timings, and configure triggers for all animations on the slide.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, which function is used to return the number of rows in a range?
A. COLUMNS
B. ROWS
C. COUNT
D. ROW
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
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
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)?