DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AVERAGE
|
|
|
MIN
|
|
|
MAX
|
|
|
SUM
|
Detailed explanation-1: -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. Unlike MAXA function, the MAX function will count numbers but ignore empty cells, text, the logical values TRUE and FALSE, and text values.
Detailed explanation-2: -The Max function finds the maximum value. The Min function finds the minimum value.
Detailed explanation-3: -The MAX function is a premade function in Excel, which finds the highest number in a range. The function ignores cells with text. It will only work for cells with numbers. Note: There is another function called MIN, which finds the lowest value in a range, the opposite of MAX.
Detailed explanation-4: -The MAX() function returns the largest value of the selected column.