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 arithmetic average of a range of numbers in Google Sheets?
Answer: AVERAGE
AVERAGE returns the arithmetic mean by summing all values and dividing by the count of those values.
Which function counts only cells containing numeric values in a range?
Answer: COUNT
COUNT only tallies cells that contain numbers, ignoring text, blanks, and errors.
What does the MEDIAN function return for a dataset?
Answer: The middle value when data is sorted in order
MEDIAN returns the middle value after sorting; for an even count it averages the two middle values.
Which Google Sheets function returns the most frequently occurring value in a dataset?
Answer: MODE
MODE identifies the value that appears most often; if multiple values tie, it returns the smallest one.
Which function returns the largest value in a given range?
Answer: MAX
MAX scans the entire range and returns the single highest numeric value found.
Which function returns the smallest value in a given range?
Answer: MIN
MIN scans the entire range and returns the single lowest numeric value found.
Which function counts all non-empty cells in a range, including cells containing text?
Answer: COUNTA
COUNTA counts every cell that is not empty, regardless of whether it contains a number, text, or formula result.
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