Google Sheets Test Google Sheets Statistical Functions 1 — Questions and Answers
Question 1: Which function calculates the arithmetic average of a range of numbers in Google Sheets?
- SUM
- AVERAGE (Correct answer)
- MEAN
- AVG
Correct answer: AVERAGE
AVERAGE returns the arithmetic mean by summing all values and dividing by the count of those values.
Question 2: Which function counts only cells containing numeric values in a range?
- COUNTA
- COUNTIF
- COUNT (Correct answer)
- COUNTBLANK
Correct answer: COUNT
COUNT only tallies cells that contain numbers, ignoring text, blanks, and errors.
Question 3: What does the MEDIAN function return for a dataset?
- The most frequently occurring value
- The arithmetic mean of all values
- The middle value when data is sorted in order (Correct answer)
- The sum divided by the count
Correct 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.
Question 4: Which Google Sheets function returns the most frequently occurring value in a dataset?
- MEDIAN
- AVERAGE
- MAX
- MODE (Correct answer)
Correct answer: MODE
MODE identifies the value that appears most often; if multiple values tie, it returns the smallest one.
Question 5: Which function returns the largest value in a given range?
- HIGH
- MAX (Correct answer)
- LARGE
- TOP
Correct answer: MAX
MAX scans the entire range and returns the single highest numeric value found.
Question 6: Which function returns the smallest value in a given range?
- MINIMUM
- LOW
- MIN (Correct answer)
- SMALL
Correct answer: MIN
MIN scans the entire range and returns the single lowest numeric value found.
Question 7: Which function counts all non-empty cells in a range, including cells containing text?
- COUNT
- COUNTA (Correct answer)
- COUNTBLANK
- COUNTIF
Correct answer: COUNTA
COUNTA counts every cell that is not empty, regardless of whether it contains a number, text, or formula result.
Google Sheets Test Google Sheets Statistical Functions 1
Which function calculates the arithmetic average of a range of numbers in Google Sheets?