To have Excel enter the lowest price from a range of prices,which of the following would you use?
A) MAX function
B) COUNT function
C) MIN function
D) COUNTA function

Name: To have Excel enter the lowest price from a range of prices,which of the following would you use? A) MAX function B) COUNT function C) MIN function D) COUNTA function
Brand: Quizplus
Rating: 4.9 (37 reviews)

Question

Quizplus · Accepted Answer

The MIN function is used to find the lowest value in a range of values, therefore it is the best choice for entering the lowest price from a range of prices in Excel.

To Have Excel Enter the Lowest Price from a Range