USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the correct function for finding the largest number in a range?
|
|
=SUM(C1:C23)
|
|
|
=AVERAGE(C1:C23)
|
|
|
=MAX(C1:C23)
|
|
|
=MIN(C1:C23)
|
Explanation:
Detailed explanation-1: -The MAX function in Excel returns the highest value in a set of data that you specify.
Detailed explanation-2: -Answer. The Excel MAX function returns the largest numeric value in a range of values.
Detailed explanation-3: -The LARGE function in Excel is used to return the n-th largest value from a numeric data set. For example, it can calculate the highest score, the 2nd largest order, the 3rd place result, and so on. Where: Array-a range or an array where to search for the largest value.
There is 1 question to complete.