In Excel, which function finds the smallest number in a range? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function finds the smallest number in a range?

A. LOWER()

B. MIN()

C. MAX()

D. SMALL()

Answer: Option B

Solution (By JKSSB Mock Tests)

MIN returns the smallest numeric value. SMALL returns the k-th smallest. LOWER converts text to lowercase.

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 keyboard shortcut to insert a hyperlink in MS Excel?

A. Ctrl + I

B. Ctrl + K

C. Ctrl + H

D. Ctrl + L

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + K is the universal shortcut to insert a hyperlink in Microsoft Office applications, including Excel, Word, and PowerPoint.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which feature allows you to see the formatting applied to text?

A. Thesaurus

B. Format Painter

C. Reveal Formatting

D. Styles

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Reveal Formatting (Shift+F1) shows a task pane displaying all formatting of selected text. Styles show applied style but not all formatting.

This question belongs to: Computer Microsoft Office

Question #3

Which key combination is used to extend a selection to the beginning of a document in MS Word?

A. Ctrl + Shift + Home

B. Shift + Home

C. Alt + Home

D. Ctrl + Home

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+Home selects from cursor to document start.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs