In Excel, which function is used to return the smallest value that meets a condition? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to return the smallest value that meets a condition?

A. MINA

B. MINIFS

C. SMALL

D. MIN

Answer: Option B

Solution (By JKSSB Mock Tests)

MINIFS returns the minimum value based on criteria. SMALL can return nth smallest, MIN returns overall min, MINA includes logicals.

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

Share Report

What feature in MS Word allows you to quickly locate and jump to a specific page, section, or line number in a document?

A. Navigation Pane

B. Find tool

C. Go To tool

D. Document Map

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The 'Go To' feature (accessed via Ctrl + G) lets you jump directly to specific pages, section markers, bookmarks, or line positions.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which option is used to create a custom slideshow?

A. Transitions > Custom Show

B. Design > Custom Show

C. Slide Show > Custom Slide Show

D. View > Custom Show

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Custom Slide Show is under the Slide Show tab.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, to delete all records from a table while keeping the structure, use:

A. DELETE * FROM table_name;

B. ALTER TABLE;

C. TRUNCATE TABLE;

D. DROP TABLE table_name;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DELETE command removes records. DROP TABLE removes entire table. Access does not support TRUNCATE.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs