Which of the following functions is used to find the smallest value in a range of cells using Microsoft Excel?
A)MAX(range)
B)MIN(range)
C)SUM(range)
D)AVERAGE(range)

Question

Quizplus · Accepted Answer

The MIN function in Excel is used to find the smallest value in a range of cells. The MAX function, on the other hand, is used to find the largest value in a range of cells. The SUM function is used to add up a range of cells, and the AVERAGE function is used to find the average value of a range of cells.

Which of the Following Functions Is Used to Find the Smallest