Excel Statistical Function Quiz
Question 1
What is the primary difference between COUNT and COUNTA?
Question 2
Which function returns the middle value of a dataset where 50% of values are above and 50% are below?
Question 3
The MODE function is used to identify:
Question 4
Which function would you use to find the second-highest sales figure in a range?
Question 5
What is the key difference between STDEV.P and STDEV.S?
Question 6
Which function returns the position of a value in a list as a percentage (e.g., 'this is in the top 10%')?
Question 7
The CORREL function is used to measure:
Question 8
What does COUNTBLANK specifically do?
Question 9
Which function predicts a future value based on existing history using linear regression?
Question 10
If you need to know how many times values fell within specific ranges (distribution), use:
Question 11
The GEOMEAN function (Geometric Mean) is commonly used for:
Question 12
What value is returned by =MAX(10, 20, 30)?
Question 13
Which function allows you to calculate the rank of a number in a list of numbers?
Question 14
The VAR.S function measures 'Variance'. Variance is a measure of:
Question 15