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. SMALL()

B. MIN()

C. MAX()

D. LOWER()

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

In Excel, which function is used to convert a date to a serial number?

A. DATEVALUE

B. NOW

C. VALUE

D. DATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DATEVALUE converts a date in text format to a serial number. VALUE converts text to number generally.

This question belongs to: Computer Microsoft Office

Question #2

Which of the following is the shortcut to save the current workbook in Excel?

A. F12

B. Ctrl + S

C. Alt + F4

D. Ctrl + Shift + S

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + S saves. F12 opens Save As. Alt + F4 closes Excel.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, what field rule dictates whether a database field can accept or store null values?

A. Default Value option

B. Required property

C. Validation Rule

D. Allow Zero Length setting

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
When 'Required' is set to 'Yes', the field cannot be left blank or contain a null value when saving records.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs