DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is not a statistical function below is
|
|
]If
|
|
|
Large
|
|
|
Small
|
|
|
Rank
|
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: -The correct answer to the question “Which one is not a function in MS Excel” is option (b). AVG. There is no function in Excel like AVG, at the time of writing, but if you mean Average, then the syntax for it is also AVERAGE and not AVG. The other two options are correct.
There is 1 question to complete.