FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Below that are not included in statistical functions are ____
A
= sum ()
B
= count ()
C
= min ()
D
= if ()
E
= Max ()
Explanation: 

Detailed explanation-1: -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")

Detailed explanation-2: -The following is not function of statistics is: The correct option is b) Statistics indicate trend behavior. Originally the word ‘statistics’ was used for the collection of data concerning states both historical and descriptive.

Detailed explanation-3: -The most commonly used statistical functions by professional data analysts are MEDIAN, MODE, STANDARD DEVIATION, AVERAGE, VARIANCE, CORRELATION, and QUARTILES, to name a few.

There is 1 question to complete.