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

STDEVP

Answer

VAR

Answer

STDDEV

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 works on text; STDEVP works on numbers

Answer

STDEV excludes zeros; STDEVP includes zeros

Answer

They are identical functions with different names

Question 3

Which function returns the nth largest value in a dataset?

Accepted Answer

LARGE

Answer

MAX

Answer

RANK

Answer

HIGH

Question 4

What does the RANK function return in Google Sheets?

Accepted Answer

Returns the rank of a specified number within a list

Answer

Sorts a range from smallest to largest

Answer

Counts how many items are in the list

Answer

Highlights the highest value in a range

Question 5

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

Accepted Answer

COUNTIF

Answer

COUNT

Answer

COUNTA

Answer

COUNTBLANK

Question 6

What does the AVERAGEIF function do in Google Sheets?

Accepted Answer

Returns the average of cells that meet a specified condition

Answer

Returns the average of all cells in a range regardless of content

Answer

Counts the cells that satisfy a given condition

Answer

Sums only the cells that meet a given condition

Question 7

Which function returns the nth smallest value in a dataset?

Accepted Answer

SMALL

Answer

MIN

Answer

LOW

Answer

RANK