Google Sheets Statistical Functions Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Statistical Functions flashcards as text
Which function calculates the standard deviation based on a sample (not the entire population)?
Answer: STDEV
STDEV uses n-1 (Bessel's correction) in its formula, making it appropriate for sample data rather than a full population.
What is the key difference between STDEV and STDEVP in Google Sheets?
Answer: STDEV is for a sample; STDEVP is for an entire population
STDEV divides by n-1 (sample), while STDEVP divides by n (population), yielding a slightly different result.
Which function returns the nth largest value in a dataset?
Answer: LARGE
LARGE(range, n) returns the nth largest value, so LARGE(A1:A10, 2) returns the second-highest value.
What does the RANK function return in Google Sheets?
Answer: Returns the rank of a specified number within a list
RANK(value, range, [order]) returns where the specified value falls among all values in the range.
Which function counts cells in a range that meet a single specified criterion?
Answer: COUNTIF
COUNTIF(range, criterion) counts only the cells matching the given condition, such as values greater than 50.
What does the AVERAGEIF function do in Google Sheets?
Answer: Returns the average of cells that meet a specified condition
AVERAGEIF(range, criterion, [average_range]) averages only those cells whose corresponding range cells meet the criterion.
Which function returns the nth smallest value in a dataset?
Answer: SMALL
SMALL(range, n) returns the nth smallest value, so SMALL(A1:A10, 3) returns the third-lowest value.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy