In Excel : which Formula of the following can you get the maximum number ? 1-min 2-max 3- sum 4-average

It's very simple question & answer

=MAX(range) then maximum number shall be your output/ answer =8 is answer for below example

3

2

1

4

8

=max(range)

3. MAX

Max function returns the largest value from the numbers provided

The MAX formula in excel returns the largest value from a supplied set of numeric values. So my answer is 2-max

Answer is Max, In Excel we find minimum i.e. smallest number from the series of data using excel formula "min(<range>)". By “max(<range>) we get maximum i.e. greatest number from the data range and using excel formula “sum(<range>)” we get sum of the data series and mean or simple average of the data series from  excel formula “average(<range>).

MAX formula is to find the maximum 

By using the following formula in excel we can get the maximum number : MAX

3. Max formula is to find the maximum 

MAX formula is used to get maximum number

2-(max) is the formula that will give the maximum number in excel

to get the maximum number we should use MAX formula

By Using Max function formula