Google Sheets Test Google Sheets Statistical Functions

Question 1

Which function calculates the arithmetic average of a range of numbers in Google Sheets?

Accepted Answer

AVERAGE

Answer

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?

Accepted Answer

COUNT

Answer

COUNT only tallies cells that contain numbers, ignoring text, blanks, and errors.

Question 3

What does the MEDIAN function return for a dataset?

Accepted Answer

The middle value when data is sorted in order

Answer

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?

Accepted Answer

MODE

Answer

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?

Accepted Answer

MAX

Answer

MAX scans the entire range and returns the single highest numeric value found.

Google Sheets Test Practice Test