- Case StudyHelp.com
- Sample Questions
Based on the values in cell b77:b81
Based on the values in cell b77:b81, what functions can automatically return the value in cell c77
a. =Bottom
b. =Lowest
c. =Min()
d. =Floor)
e. =Smallest
Answer:- c. =Min()
Expert Answer
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, the alphabetic comparison is performed using the min () method.
More