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 average of numbers in a range?
|
|
=SUM(C1:C23)
|
|
|
=AVERAGE(C1:C23)
|
|
|
=MAX(C1:C23)
|
|
|
=MIN(C1:C23)
|
Explanation:
Detailed explanation-1: -Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Detailed explanation-2: -To do this, you would select the cells that contain the numbers you want to average, and then use the function =DAVERAGE(A1:A10) (assuming that the cells you selected range from A1 to A10). This would calculate the average of all the numbers in the selected range.
There is 1 question to complete.