Question

10) Which function in Excel is used to find the biggest value in a range?
A. Ceiling
c. LÊN
B.
DMAX
D. MAX​

Answer 1

Explanation:

The MAX function in Excel returns the highest value in a set of data that you specify. The syntax is as follows: MAX(number1, [number2], …) Where number can be represented by a numeric value, array, named range, a reference to a cell or range containing numbers.