USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which function returns the highest value in a range?
|
|
SUM
|
|
|
AVERAGE
|
|
|
MAX
|
|
|
MIN
|
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: -The Max function finds the maximum value. The Min function finds the minimum value.
Detailed explanation-3: -In a blank cell, type “=MAX(“ Select the cells you want to find the largest number from. Close the formula with an ending parentheses. Hit enter and the largest number from your selection will populate in the cell.
There is 1 question to complete.