COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

OFFICE AUTOMATION SOFTWARE

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following function will use to find the highest number in a series of number?
A
HIGH (B1:B3)
B
MAXIMUM (B1:B3)
C
MAX(B1:B3)
D
None of the above
Explanation: 

Detailed explanation-1: -The MAX Function[1] is categorized under Excel Statistical functions. MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value.

Detailed explanation-2: -Answer: The MAX( ) function is an aggregate function in SQL which returns the maximum value from a set of values.

Detailed explanation-3: -MAX function is used to find the highest number in a set of numbers or a series of cells.

There is 1 question to complete.