USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What function can be used to find the largest number in a range of numbers?
|
|
=MIN
|
|
|
=MAX
|
|
|
=AVERAGE
|
|
|
=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: -Explanation: The Excel MAX function returns the largest numeric value in a range of values.
There is 1 question to complete.