Question

Rick needs to find the lowest number in a set of numbers that includes decimals. Which statistical function in a spreadsheet will help him do so?

A. Mode
B. Rank
C. Min
D. Average

Answer 1

the answer should be C.

Answer 2

C. Min

Explanation

In most spreadsheet programs including those in Microsoft Excel, min is a formula function applied to find the minimum value in a range of cells. The MIN function returns the lowest value from a set of values that are provided. The function ignores empty cells, the logical values and text values.