Question

QUESTION 8/15 Based on the values in Cells B77:B81, which function can automatically return the value in Cell C77? с $721 B 76 Sales 77 $794 78 $721 79 $854 80 $912 $1,020 81 Image not displaying? =Lowest O=Min =Floor) =Smallest =Bottom

Answer 1

MIN( ), min function returns the smallest numeric value in a range of values. $721 is the minimum out of the given 5 values, so here use MIN function. There is no function as smallest, lowest and bottom in excel.

What is MIN()?

The MIN function in Excel is a built-in function that locates the lowest value inside a range. Text-filled cells are ignored by the function. Only cells containing numbers will function properly. In contrast to MIN, another function named MAX seeks the largest value inside a range.

Your data range is checked using the MIN function, which returns the least number in the set. The MIN function gives the result that is the smallest numeric value in the given data. Any form of numeric data can have its lowest value returned using the MIN function.

Its syntax is the following: MIN(number1, [number2], …) number1, [number2]

To know more about MIN function, visit:

brainly.com/question/12321880

#SPJ1