Google Sheets Test Google Sheets Statistical Functions 2

Question 1

Which function calculates the standard deviation based on a sample (not the entire population)?

Accepted Answer

STDEV

Answer

STDEV uses n-1 (Bessel's correction) in its formula, making it appropriate for sample data rather than a full population.

Question 2

What is the key difference between STDEV and STDEVP in Google Sheets?

Accepted Answer

STDEV is for a sample; STDEVP is for an entire population

Answer

STDEV divides by n-1 (sample), while STDEVP divides by n (population), yielding a slightly different result.

Question 3

Which function returns the nth largest value in a dataset?

Accepted Answer

LARGE

Answer

LARGE(range, n) returns the nth largest value, so LARGE(A1:A10, 2) returns the second-highest value.

Question 4

What does the RANK function return in Google Sheets?

Accepted Answer

Returns the rank of a specified number within a list

Answer

RANK(value, range, [order]) returns where the specified value falls among all values in the range.

Question 5

Which function counts cells in a range that meet a single specified criterion?

Accepted Answer

COUNTIF

Answer

COUNTIF(range, criterion) counts only the cells matching the given condition, such as values greater than 50.

Google Sheets Test Practice Test