DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What function was used to find the highest grade?
|
|
average
|
|
|
min
|
|
|
sum
|
|
|
max
|
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: -The MAX function in Excel returns the highest value in a set of data that you specify.
Detailed explanation-3: -The max() function returns the item with the highest value, or the item with the highest value in an iterable.
Detailed explanation-4: -Excel MIN and MAX Functions. Find lowest and highest numbers with Excel MIN and MAX functions. For minimum and maximum with criteria, use with IF function, to create MIN IF and MAX IF formulas, or use MINIFS and MAXIFS in Excel 365.
There is 1 question to complete.