USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Returns the largest value in a set of values
|
|
AVERAGE
|
|
|
MIN
|
|
|
MAX
|
|
|
SUM
|
Explanation:
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: -Answer. The Excel MAX function returns the largest numeric value in a range of values.
Detailed explanation-3: -The MAX() function returns the largest value of the selected column.
Detailed explanation-4: -Based on the returned values, the max() function will return the key having the largest value.
There is 1 question to complete.