Based on the Values in Cells B77:B81, Which Function Can Automatically Return the Value in Cell C77?

Brief :

A. =Floor)
B. =Smallest
C. =Lowest
D. =Bottom
E. =Min()

Answer

E. =Min()

Based on the values in cells b77: b81, the right answer to this question is in Min(), and it will reappear in cell c77. The min() function in excel, is used to find the lowest number in the range of values. So, as we know, c77 includes the lowest value in this sheet, and to make it reappear, we need to use a min function, as it can draw out the minimum value. But, in the case of string values, this function conducts an alphabetic comparison.

UPTO56%

Avail The Benefit Today!

To View this & another 50000+ free

Enter Email

Get Answer