Question

In MS Excel cell, values 29, 19, 27, 39 and 20 are written from A6 to A11. Then what will be the value of = MAX (A6: A11)? A: 29 B: 39 C: 21 D: 20

Answer 1

Answer:

The Answer is B : 39.

Explanation:

In MS Excel the MAX is used to get the highest value in given range. Considering following :

Cell Number | Value

A6 | 29

A7 | 19

A8 | 27

A9 | 39

A10 | 20

and if we apply the =MAX(A6:A10). Since we are specifying a range from A6 to A10 the value 39 will be printed.

Answer 2

Explanation:

39 is correct answer..............