DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Sam is using the functions within Excel to complete questions in a school homework assignment. Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
|
|
=AVG(E4, E9)
|
|
|
=AVERAGE(E4:E9)
|
|
|
=AVG(E4:E9)
|
|
|
+AVERAGE(E4:E9)
|
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: -The MIN function checks your data range and returns the smallest value in the set.
Detailed explanation-3: -Use the COUNTIF function to count how many times a particular value appears in a range of cells. For more information, see COUNTIF function.
There is 1 question to complete.