DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The following are not included statistical functions are ____
|
|
=if()
|
|
|
=sum()
|
|
|
=count()
|
|
|
=min()
|
Explanation:
Detailed explanation-1: -The most commonly used statistical functions by professional data analysts are MEDIAN, MODE, STANDARD DEVIATION, AVERAGE, VARIANCE, CORRELATION, and QUARTILES, to name a few.
Detailed explanation-2: -Syntax. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK")
There is 1 question to complete.