WHICH FUNCTION MAY AUTOMATICALLY RETURN THE VALUE

123 views 7:19 am 0 Comments August 12, 2023

Which function may automatically return the value in Cell C77 based on the values in Cells B77:B81?

=Lowest
=Floor)
=Smallest
=Min()
=Bottom

Answer:- 4. =Min()

Min() is the function that can mechanically reappear the value in cell c77.

Explanation: An Excel sheet’s min() function automatically repays the item with the lowest value. In the case of string values, alphabetic comparison is performed using the min() method.

Tags: , , , , , , , , , , ,