Question

To have Excel enter the lowest price from a range of prices, which of the following would you use?

1) MIN function
2) MAX function
3) AVERAGE function
4) SUM function

Answer 1

To have Excel enter the lowest price from a range of prices, you would use the MIN function.

Step-by-step explanation:

To have Excel enter the lowest price from a range of prices, you would use the MIN function. The MIN function in Excel returns the smallest value from a given range of cells. For example, if you have a range of prices in cells A1 to A5, you can use the formula =MIN(A1:A5) to find the lowest price.