Maximum Value | MCQs

Explanation

The MAX function in Excel returns the highest value in a set of data that you specify.

It can be used to find the maximum value in a range of cells, a list of numbers, or an array.

Example: =MAX(A1:A10) returns the highest value in cells A1 through A10.