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?
|
HIGH (B1:B3)
|
|
MAXIMUM (B1:B3)
|
|
MAX(B1:B3)
|
|
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.